Depot Master Route (SVC06105)

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

Display Name: Depot Master Route
Physical Name: SVC06105
Technical Name: SVC_Depot_MSTR_Route

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	WORECTYPE	Work Order Record Type	Integer	DDL_Work_Order_Record_Type	0
2	WORKORDNUM	Work Order Number	String	STR10_LBAU	10
3	Status	Status	Integer	INT	0
4	SEQUENCE1	Sequence	Currency	DLR19_$S2	19
5	DSCRIPTN	Description	String	STR30	30
6	DEPSTATGRP	Depot Station Group	String	STR10_LBAU	10
7	STATIONID	Depot Station ID	String	STR10_LBAU	10
8	TECHID	Tech ID	String	STR10_LBAU	10
9	ETTR	ETTR	Currency	CURR_MTTR	10
10	ROUTEPROC	Route Process	String	STR10_LBAU	10
11	SERVICEBOM	Service BOM	String	STR30_Item_Number	30
12	STRTDATE	Start Date	Date	DT	8
13	STRTTIME	Start Time	Time	TM6	6
14	ENDDATE	End Date	Date	DT	8
15	ENDTIME	End Time	Time	TM6	6
16	ETADTE	ETA Date	Date	DT_Date	6
17	ETATME	ETA Time	Time	TM6	6
18	ECOMPDT	EComp Date	Date	DT_Date	6
19	EComp_Time	EComp Time	Time	TM6	6
20	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Depot Master Route'].NOTEINDX AS 'Depot Master Route-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SVC06105 AS ['Depot Master Route'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Depot Master Route'].NOTEINDX = ['Record Notes Master'].NOTEINDX