SVC_Service_Escalation_Audit (SVC00211)

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

Display Name: SVC_Service_Escalation_Audit
Physical Name: SVC00211
Technical Name: SVC_Service_Escalation_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	SRVRECTYPE	Service Record Type	Integer	DDL_Service_Record_Type	0
2	CALLNBR	Service Call Number	String	STR10_LBAU	10
3	SVC_Task_ID	SVC_Task_ID	String	TASKID	0
4	SVC_Task_Name	SVC_Task_Name	String	STR30	30
5	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SVC_Service_Escalation_Audit'].USERID AS 'SVC_Service_Escalation_Audit-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVC00211 AS ['SVC_Service_Escalation_Audit'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SVC_Service_Escalation_Audit'].USERID = ['Users Master'].USERID
6	DATE1	Date	Date	DT6	6
7	TIME1	Time	Time	TM6	6
8	SVC_Escalation_Status	SVC_Escalation_Status	Integer	SVC_Escalation_Status	0
9	ENDDATE	End Date	Date	DT	8
10	ENDTIME	End Time	Time	TM6	6
11	SVC_Task_Start_Date	SVC_Task_Start_Date	Long Integer	SVC_Task_DateTime	0
12	SVC_Task_Start_Time	SVC_Task_Start_Time	Long Integer	SVC_Task_DateTime	0
13	SVC_Task_End_Date	SVC_Task_End_Date	Long Integer	SVC_Task_DateTime	0
14	SVC_Task_End_Time	SVC_Task_End_Time	Long Integer	SVC_Task_DateTime	0
15	SVC_Command_Text	SVC_Command_Text	String	SVC_Command_Text	0
16	SVC_Task_Comment	SVC_Task_Comment	String	SVC_Command_Text	0