Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CIS30201
Product: MIS-AMS Extensions (3459)
Series: Purchasing
Display Name: CIS Vouchers
Physical Name: CIS30201
Technical Name: CIS_VouchersSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CISIRVOU 
CIS IR Voucher Number STR30_LBAU String 30 2 CISDOC CIS Document Type DDL_CIS_Verification Status Integer 0 3 CISIRPER CIS IR Period IR Period String 6 4 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['CIS Vouchers'].VENDORID AS 'CIS Vouchers-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
CIS30201 AS ['CIS Vouchers']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['CIS Vouchers'].VENDORID = ['PM Vendor Master File'].VENDORID5 PAYMENT_AMOUNT Payment Amount DLR19_RBSO_UTR$ Currency 19 6 CISNONTAX CIS Non-taxable Amount DLR17_RBS0_UTR$ Currency 17 7 CISDEDUCT CIS Deducted DLR17_RBS0_STR$ Currency 17