Serial Master Audit (SVC00310)

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

Display Name: Serial Master Audit
Physical Name: SVC00310
Technical Name: SVC_Serial_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	EQUIPID	Equipment ID	Long Integer	Long Int	8
2	LNITMSEQ	Line Item Sequence	Long Integer	LI_Sequence_Number	10
3	DATE1	Date	Date	DT6	6
4	TIME1	Time	Time	TM6	6
5	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Serial Master Audit'].USERID AS 'Serial Master Audit-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVC00310 AS ['Serial Master Audit'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Serial Master Audit'].USERID = ['Users Master'].USERID
6	From_Customer_Number	From Customer Number	String	STR15_Customer_Number	15
7	To_Customer_Number	To Customer Number	String	STR15_Customer_Number	15
8	From_Config_Reference	From Config Reference	String	STR20	20
9	To_Config_Reference	To Config Reference	String	STR20	20
10	From_Confg_Level	From Confg Level	Integer	INT4	4
11	To_Config_Level	To Config Level	Integer	INT4	4
12	From_Config_Sequence	From Config Sequence	Integer	INT4	4
13	To_Config_Sequence	To Config Sequence	Integer	INT4	4
14	From_Serial_Number	From Serial Number	String	STR20	20
15	To_Serial_Number	To Serial Number	String	STR20	20
16	From_Item_Number	From Item Number	String	STR30	30
17	To_Item_Number	To Item Number	String	STR30	30
18	DSCRIPTN	Description	String	STR30	30