Serial Superssion Master (SVC00302)

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

Display Name: Serial Superssion Master
Physical Name: SVC00302
Technical Name: SVC_Serial_MSTR_Supersession

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	SERLNMBR	Serial Number	String	STR20_LBAU	20
3	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Serial Superssion Master'].ITEMNMBR AS 'Serial Superssion Master-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SVC00302 AS ['Serial Superssion Master'] INNER JOIN IV00101 AS ['Item Master'] ON ['Serial Superssion Master'].ITEMNMBR = ['Item Master'].ITEMNMBR
4	REFRENCE	Reference	String	STR30	30
5	OLDEQUIPID	Old Equipment ID	Long Integer	Long Int	8
6	OLDSERNBR	Old Serial Number	String	STR20_LBAU	20
7	OLDITEMNBR	SVC Old Item Number	String	STR30_Item_Number	30
8	OLDREFID	Old Reference ID	String	STR30	30
9	LSTDTEDT	Last Date Edited	Date	DT_Date	6
10	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Serial Superssion Master'].USERID AS 'Serial Superssion Master-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVC00302 AS ['Serial Superssion Master'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Serial Superssion Master'].USERID = ['Users Master'].USERID