Depot Schedule (SVC06300)

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

Product: FieldService (949)
Series: Project

Display Name: Depot Schedule
Physical Name: SVC06300
Technical Name: SVC_Depot_Schedule

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
2SEQUENCE1 SearchSequenceDLR19_$S2Currency1019
3Queue_Status SearchQueue_StatusSTR2_LBAU0String42
4WORECTYPE SearchWork Order Record TypeDDL_Work_Order_Record_TypeInteger20
5WORKORDNUM SearchWork Order NumberSTR10_LBAUString1210
6Route_Sequence SearchRoute_SequenceDLR19_$S2Currency1019
7SVC_Depot_Priority SearchSVC_Depot_PrioritySVC_Depot_PriorityCurrency107
8Status SearchStatusINTInteger20
9TECHID SearchTech IDSTR10_LBAUString1210
10ETTR SearchETTRCURR_MTTRCurrency1010
11ETADTE SearchETA DateDT_DateDate46
12ETATME SearchETA TimeTM6Time46
13ECOMPDT SearchEComp DateDT_DateDate46
14EComp_Time SearchEComp TimeTM6Time46
15ACTSTRTDTE SearchActual Strt DateDT_DateDate46
16ACTSTRTTME SearchActual Start TimeTM6Time46
17LSTSTAID SearchLast Station IDSTR10_LBAUString1210
18Last_Sequence SearchLast SequenceDLR19_$S2Currency1019
19NXTSTATID SearchNext Station IDSTR10_LBAUString1210
20NXTSEQ SearchNext SequenceDLR19_$S2Currency1019
21DEX_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.

Leave a Reply

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