SVC_Station_Analysis_View (SVC6105V)

azurecurveProductsFieldService (949)ProjectSVC_Station_Analysis_View (SVC6105V)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC6105V

Product: FieldService (949)
Series: Project

Display Name: SVC_Station_Analysis_View
Physical Name: SVC6105V
Technical Name: SVC_Station_Analysis_View

Group Display Name: Service Table Group
Group Technical Name: Service

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1STATIONID SearchDepot Station IDSTR10_LBAUString10
2STATIONDESC SearchStation ID DescriptionSTR30String30
3WORECTYPE SearchWork Order Record TypeDDL_Work_Order_Record_TypeInteger0
4WORKORDNUM SearchWork Order NumberSTR10_LBAUString10
5SEQUENCE1 SearchSequenceDLR19_$S2Currency19
6DSCRIPTN SearchDescriptionSTR30String30
7Status SearchStatusINTInteger0
8WOStatus SearchWO StatusSTR10String10
9TECHID SearchTech IDSTR10_LBAUString10
10WOTYPE SearchWork Order TypeSTR10_LBAUString10
11WOSTAT SearchWork Order StatusSTR3_LBUString3
12SVC_Depot_Priority SearchSVC_Depot_PrioritySVC_Depot_PriorityCurrency7
13OFFID SearchOffice IDSTR10_LBAUString10
14ETTR SearchETTRCURR_MTTRCurrency10
15ETADTE SearchETA DateDT_DateDate6
16ETATME SearchETA TimeTM6Time6
17ECOMPDT SearchEComp DateDT_DateDate6
18EComp_Time SearchEComp TimeTM6Time6
19STRTDATE SearchStart DateDTDate8
20STRTTIME SearchStart TimeTM6Time6
21ENDDATE SearchEnd DateDTDate8
22ENDTIME SearchEnd TimeTM6Time6
23TRANSTME SearchTransaction TimeSTR_Bill_TimeString6
24ACTUALETTR SearchActual ETTRINTInteger0
25DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsFieldService (949)ProjectSVC_Station_Analysis_View (SVC6105V)

Leave a Reply

Your email address will not be published. Required fields are marked *