Shipping Methods Master (SY03000)

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

Display Name: Shipping Methods Master
Physical Name: SY03000
Technical Name: SY_Shipping_Methods_MSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
2	SHMTHDSC	Shipping Method Description	String	STR30	30
3	PHONNAME	Phone Number	String	Phone_Number	14
4	CONTACT	Contact	String	STR60	60
5	CARRACCT	Carrier Account	String	STR15	15
6	CARRIER	Carrier	String	STR30	30
7	SHIPTYPE	Shipping Type	Integer	GB	0
8	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Shipping Methods Master'].NOTEINDX AS 'Shipping Methods Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SY03000 AS ['Shipping Methods Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Shipping Methods Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
9	LSTUSRED	Last User to Edit	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Shipping Methods Master'].LSTUSRED AS 'Shipping Methods Master-Last User to Edit' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SY03000 AS ['Shipping Methods Master'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Shipping Methods Master'].LSTUSRED = ['Users Master'].USERID
10	CREATDDT	Created Date	Date	DT	8
11	MODIFDT	Modified Date	Date	DT	8