Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CIS20000
Product: MIS-AMS Extensions (3459)
Series: Purchasing
Display Name: CIS Payables Transactions
Physical Name: CIS20000
Technical Name: CIS_PM_TransactionsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VCHRNMBR 
Voucher Number STR20_LBAU String 20 Partial key to the PM Key Master File (PM00400).
Click to show/hide
SELECT
['CIS Payables Transactions'].VCHRNMBR AS 'CIS Payables Transactions-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
CIS20000 AS ['CIS Payables Transactions']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['CIS Payables Transactions'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['CIS Payables Transactions'].DOCTYPE = ['PM Key Master File'].DOCTYPE2 DOCTYPE Document Type DDL_Document_Type Integer 0 Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo3 CISSCOPE CIS In Scope CB_CIS_In_Scope Boolean 0 4 CISNONTAX CIS Non-taxable Amount DLR17_RBS0_UTR$ Currency 17 5 ORIGNONTAX CIS Original Non-taxable Amount DLR17_RBS0_UTR$ Currency 17 6 CISDEDUCT CIS Deducted DLR17_RBS0_STR$ Currency 17