Service Master Audit Trail (SVC00210)

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

Display Name: Service Master Audit Trail
Physical Name: SVC00210
Technical Name: SVC_Service_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	CALLNBR	Service Call Number	String	STR10_LBAU	10
2	SRVRECTYPE	Service Record Type	Integer	DDL_Service_Record_Type	0
3	LNITMSEQ	Line Item Sequence	Long Integer	LI_Sequence_Number	10
4	FRMSTAT	From Service Call Status	String	STR3_LBU	3
5	TOSTAT	To Service Call Status	String	STR3_LBU	3
6	TECHID	Tech ID	String	STR10_LBAU	10
7	DSCRIPTN	Description	String	STR30	30
8	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Service Master Audit Trail'].USERID AS 'Service Master Audit Trail-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVC00210 AS ['Service Master Audit Trail'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Service Master Audit Trail'].USERID = ['Users Master'].USERID
9	CREATDDT	Created Date	Date	DT	8
10	CREATETIME	Created Time	Time	TM6	6