PA – Purchase Order History (papopt01)

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

Display Name: PA - Purchase Order History
Physical Name: papopt01
Technical Name: paPOPtemp

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PONUMBER	PO Number	STR17_POP_Number	String	17
2	POTYPE	PO Type	DDL_POP_PO_Type	Integer	0
3	DOCDATE	Document Date	DT	Date	8
4	VENDORID	Vendor ID	STR_15_Vendor_ID	String	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['PA - Purchase Order History'].VENDORID AS 'PA - Purchase Order History-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM papopt01 AS ['PA - Purchase Order History'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['PA - Purchase Order History'].VENDORID = ['PM Vendor Master File'].VENDORID