Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC06300
Product: FieldService (949)
Series:
Display Name: Depot Schedule Group Display Name: Service Table Group
Physical Name: SVC06300
Technical Name: SVC_Depot_Schedule
Group Technical Name: Service
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
---|---|---|---|---|---|
1 | STATIONID | Depot Station ID | String | STR10_LBAU | 10 |
2 | SEQUENCE1 | Sequence | Currency | DLR19_$S2 | 19 |
3 | Queue_Status | Queue_Status | String | STR2_LBAU0 | 2 |
4 | WORECTYPE | Work Order Record Type | Integer | DDL_Work_Order_Record_Type | 0 |
5 | WORKORDNUM | Work Order Number | String | STR10_LBAU | 10 |
6 | Route_Sequence | Route_Sequence | Currency | DLR19_$S2 | 19 |
7 | SVC_Depot_Priority | SVC_Depot_Priority | Currency | SVC_Depot_Priority | 7 |
8 | Status | Status | Integer | INT | 0 |
9 | TECHID | Tech ID | String | STR10_LBAU | 10 |
10 | ETTR | ETTR | Currency | CURR_MTTR | 10 |
11 | ETADTE | ETA Date | Date | DT_Date | 6 |
12 | ETATME | ETA Time | Time | TM6 | 6 |
13 | ECOMPDT | EComp Date | Date | DT_Date | 6 |
14 | EComp_Time | EComp Time | Time | TM6 | 6 |
15 | ACTSTRTDTE | Actual Strt Date | Date | DT_Date | 6 |
16 | ACTSTRTTME | Actual Start Time | Time | TM6 | 6 |
17 | LSTSTAID | Last Station ID | String | STR10_LBAU | 10 |
18 | Last_Sequence | Last Sequence | Currency | DLR19_$S2 | 19 |
19 | NXTSTATID | Next Station ID | String | STR10_LBAU | 10 |
20 | NXTSEQ | Next Sequence | Currency | DLR19_$S2 | 19 |