Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/papopt02
Product: Company Archive (1755)
Series: Company
Display Name: PA - Purchasing Receipt History
Physical Name: papopt02
Technical Name: paPOReceiptTempSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 POPRCTNM 
POP Receipt Number STR17_POP_Number String 17 2 POPTYPE POP Type DDL_POP_Type Integer 0 3 receiptdate Receipt Date DT Date 8 4 BCHSOURC Batch Source STR15 String 15 5 BACHNUMB Batch Number STR15_LBAU String 15 6 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['PA - Purchasing Receipt History'].VENDORID AS 'PA - Purchasing Receipt History-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
papopt02 AS ['PA - Purchasing Receipt History']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PA - Purchasing Receipt History'].VENDORID = ['PM Vendor Master File'].VENDORID7 TRXSORCE TRX Source STR13 String 13 8 VNDDOCNM Vendor Document Number STR20_Document_Number String 20