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 TypeSQL DB LengthKeyable Length
1STATIONID SearchDepot Station IDSTR10_LBAUString1210
2STATIONDESC SearchStation ID DescriptionSTR30String3230
3WORECTYPE SearchWork Order Record TypeDDL_Work_Order_Record_TypeInteger20
4WORKORDNUM SearchWork Order NumberSTR10_LBAUString1210
5SEQUENCE1 SearchSequenceDLR19_$S2Currency1019
6DSCRIPTN SearchDescriptionSTR30String3230
7Status SearchStatusINTInteger20
8WOStatus SearchWO StatusSTR10String1210
9TECHID SearchTech IDSTR10_LBAUString1210
10WOTYPE SearchWork Order TypeSTR10_LBAUString1210
11WOSTAT SearchWork Order StatusSTR3_LBUString43
12SVC_Depot_Priority SearchSVC_Depot_PrioritySVC_Depot_PriorityCurrency107
13OFFID SearchOffice IDSTR10_LBAUString1210
14ETTR SearchETTRCURR_MTTRCurrency1010
15ETADTE SearchETA DateDT_DateDate46
16ETATME SearchETA TimeTM6Time46
17ECOMPDT SearchEComp DateDT_DateDate46
18EComp_Time SearchEComp TimeTM6Time46
19STRTDATE SearchStart DateDTDate48
20STRTTIME SearchStart TimeTM6Time46
21ENDDATE SearchEnd DateDTDate48
22ENDTIME SearchEnd TimeTM6Time46
23TRANSTME SearchTransaction TimeSTR_Bill_TimeString86
24ACTUALETTR SearchActual ETTRINTInteger20
25DEX_ROW_ID Searchintint1010

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 *