Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/papmt001
Product: Company Archive (1755)
Series: Company
Display Name: PA - PM Paid Transaction History File Archive Temp
Physical Name: papmt001
Technical Name: paPMTrxHistTempSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VCHRNMBR 
Voucher Number STR20_LBAU String 20 2 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['PA - PM Paid Transaction History File Archive Temp'].VENDORID AS 'PA - PM Paid Transaction History File Archive Temp-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
papmt001 AS ['PA - PM Paid Transaction History File Archive Temp']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PA - PM Paid Transaction History File Archive Temp'].VENDORID = ['PM Vendor Master File'].VENDORID3 DOCTYPE Document Type DDL_Document_Type Integer 0 4 DOCDATE Document Date DT Date 8 5 DOCNUMBR Document Number STR20_Document_Number String 20 6 CNTRLTYP Control Type INT1 Integer 1