PA Purchase Order Work (PA10600)

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

Display Name: PA Purchase Order Work
Physical Name: PA10600
Technical Name: PA_PO_WORK_HDR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PApurordnum	PA Purchase Order No.	String	STR17_LBAU	17
2	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['PA Purchase Order Work'].NOTEINDX AS 'PA Purchase Order Work-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM PA10600 AS ['PA Purchase Order Work'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['PA Purchase Order Work'].NOTEINDX = ['Record Notes Master'].NOTEINDX
3	PApodeformatouse	PA Default Format to Use - PO	Integer	GB	0
4	PAFreight_Taxable_P	PA Freight Taxable - Purchase	Integer	PA_DDL_Tax_Options_Purchase	0
5	PAlastprtby	PA Last Printed By	String	STR15_User_ID	15
6	PAMisc_Taxable_P	PA Misc Taxable - Purchase	Integer	PA_DDL_Tax_Options_Purchase	0
7	PA_Trade_Discount_Pcnt	PA Trade Discount Percent	Integer	INT5_%2	5
8	RegKey	RegKey	String	STR128_LBU	128
9	TRXTYPE	Transaction Type	Integer	GB	0
10	USEADVTX	Use Advanced Taxes	Integer	GB	0
11	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['PA Purchase Order Work'].USERID AS 'PA Purchase Order Work-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM PA10600 AS ['PA Purchase Order Work'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['PA Purchase Order Work'].USERID = ['Users Master'].USERID