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 TypeLength
1STATIONID SearchDepot Station IDSTR10_LBAUString10
2SEQUENCE1 SearchSequenceDLR19_$S2Currency19
3Queue_Status SearchQueue_StatusSTR2_LBAU0String2
4WORECTYPE SearchWork Order Record TypeDDL_Work_Order_Record_TypeInteger0
5WORKORDNUM SearchWork Order NumberSTR10_LBAUString10
6Route_Sequence SearchRoute_SequenceDLR19_$S2Currency19
7SVC_Depot_Priority SearchSVC_Depot_PrioritySVC_Depot_PriorityCurrency7
8Status SearchStatusINTInteger0
9TECHID SearchTech IDSTR10_LBAUString10
10ETTR SearchETTRCURR_MTTRCurrency10
11ETADTE SearchETA DateDT_DateDate6
12ETATME SearchETA TimeTM6Time6
13ECOMPDT SearchEComp DateDT_DateDate6
14EComp_Time SearchEComp TimeTM6Time6
15ACTSTRTDTE SearchActual Strt DateDT_DateDate6
16ACTSTRTTME SearchActual Start TimeTM6Time6
17LSTSTAID SearchLast Station IDSTR10_LBAUString10
18Last_Sequence SearchLast SequenceDLR19_$S2Currency19
19NXTSTATID SearchNext Station IDSTR10_LBAUString10
20NXTSEQ SearchNext SequenceDLR19_$S2Currency19
21DEX_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.

Leave a Reply

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