SVC_Depot_Completion_WORK (SVC06115)

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

Display Name: SVC_Depot_Completion_WORK
Physical Name: SVC06115
Technical Name: SVC_Depot_Completion_WORK

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	MKDTOPST	Marked To Post	Boolean	CB	0
2	WORECTYPE	Work Order Record Type	Integer	DDL_Work_Order_Record_Type	0
3	WORKORDNUM	Work Order Number	String	STR10_LBAU	10
4	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SVC_Depot_Completion_WORK'].USERID AS 'SVC_Depot_Completion_WORK-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVC06115 AS ['SVC_Depot_Completion_WORK'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SVC_Depot_Completion_WORK'].USERID = ['Users Master'].USERID
5	STRTDATE	Start Date	Date	DT	8
6	ENDDATE	End Date	Date	DT	8
7	WOTYPE	Work Order Type	String	STR10_LBAU	10
8	STATIONID	Depot Station ID	String	STR10_LBAU	10
9	OFFID	Office ID	String	STR10_LBAU	10
10	POSTED	Posted	Boolean	True/False	0
11	ERMSGNBR	Error Message Number	Integer	INT4	4
12	ERMSGTXT	Error Message Text	String	STR255	255
13	ERMSGTX2	Error Message Text 2	String	STR255	255