Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/papmtF
Product: Company Archive (1755)
Series: Company
Display Name: PA - PM Paid Trx History Archive Failed
Physical Name: papmtF
Technical Name: paPMTrxHistFailedSeq 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 Trx History Archive Failed'].VENDORID AS 'PA - PM Paid Trx History Archive Failed-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
papmtF AS ['PA - PM Paid Trx History Archive Failed']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PA - PM Paid Trx History Archive Failed'].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 7 ERRDESCR Error Description STR130 String 130 8 APTVCHNM Apply To Voucher Number STR20_LBAU String 20 9 APFVCHNM Apply From Voucher Number STR20_LBAU String 20 10 PSTGDATE Posting Date DT Date 8