Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CFM10000
Product: Cash Flow Management (1632)
Series:
Display Name: CFM PM Transaction WORK
Physical Name: CFM10000
Technical Name: CFM_PM_Transaction_WORKSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VENDORID 
Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['CFM PM Transaction WORK'].VENDORID AS 'CFM PM Transaction WORK-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
CFM10000 AS ['CFM PM Transaction WORK']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['CFM PM Transaction WORK'].VENDORID = ['PM Vendor Master File'].VENDORID2 DOCTYPE Document Type Integer DDL_Document_Type 0 Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo3 DOCDATE Document Date Date DT 8 4 DOCNUMBR Document Number String STR20_Document_Number 20 5 CURTRXAM Current Trx Amount Currency DLR17_RBS0_UTR$ 17 6 DUEDATE Due Date Date DT 8 7 DOCAMNT Document Amount Currency DLR19_RBSO_UTR$ 19 8 VCHRNMBR Voucher Number String STR20_LBAU 20 Partial key to the PM Key Master File (PM00400).
Click to show/hide
SELECT
['CFM PM Transaction WORK'].VCHRNMBR AS 'CFM PM Transaction WORK-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
CFM10000 AS ['CFM PM Transaction WORK']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['CFM PM Transaction WORK'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['CFM PM Transaction WORK'].DOCTYPE = ['PM Key Master File'].DOCTYPE9 TRXSORCE TRX Source String STR13 13