CFM PM Transaction OPEN (CFM20000)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CFM20000

Product: Cash Flow Management (1632)
Series:

Display Name: CFM PM Transaction OPEN
Physical Name: CFM20000
Technical Name: CFM_PM_Transaction_OPEN

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['CFM PM Transaction OPEN'].VENDORID AS 'CFM PM Transaction OPEN-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       CFM20000 AS ['CFM PM Transaction OPEN']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['CFM PM Transaction OPEN'].VENDORID = ['PM Vendor Master File'].VENDORID
2DOCTYPE SearchDocument TypeIntegerDDL_Document_Type0

Click to show/hide Document Types


1	Invoice
2	Finance Charge
3	Miscellaneous Charges
4	Return
5	Credit Memo
3DOCDATE SearchDocument DateDateDT8
4DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
5CURTRXAM SearchCurrent Trx AmountCurrencyDLR17_RBS0_UTR$17
6DUEDATE SearchDue DateDateDT8
7DOCAMNT SearchDocument AmountCurrencyDLR19_RBSO_UTR$19
8VCHRNMBR SearchVoucher NumberStringSTR20_LBAU20
Partial key to the PM Key Master File (PM00400).

Click to show/hide

SELECT
       ['CFM PM Transaction OPEN'].VCHRNMBR AS 'CFM PM Transaction OPEN-Voucher Number'
       ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
       CFM20000 AS ['CFM PM Transaction OPEN']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['CFM PM Transaction OPEN'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
              AND
                     ['CFM PM Transaction OPEN'].DOCTYPE = ['PM Key Master File'].DOCTYPE
9TRXSORCE SearchTRX SourceStringSTR1313

Leave a Reply

Your email address will not be published. Required fields are marked *