Work Order Audit (SVC06110)

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

Display Name: Work Order Audit
Physical Name: SVC06110
Technical Name: SVC_Depot_MSTR_Audit

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	LNITMSEQ	Line Item Sequence	Long Integer	LI_Sequence_Number	10
4	FRMWOSTAT	From Work Order Status	String	STR3_LBAU	3
5	TOWOSTAT	To Work Order Status	String	STR3_LBAU	3
6	STATIONID	Depot Station ID	String	STR10_LBAU	10
7	TECHID	Tech ID	String	STR10_LBAU	10
8	SVC_Audit_Description	SVC Audit Description	String	STR50	50
9	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Work Order Audit '].USERID AS 'Work Order Audit -User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVC06110 AS ['Work Order Audit '] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Work Order Audit '].USERID = ['Users Master'].USERID
10	CREATDDT	Created Date	Date	DT	8
11	CREATETIME	Created Time	Time	TM6	6