CFM_POP (CFM40000)

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

Product: Cash Flow Management (1632)
Series:

Display Name: CFM_POP
Physical Name: CFM40000
Technical Name: CFM_POP

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_POP'].VENDORID AS 'CFM_POP-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       CFM40000 AS ['CFM_POP']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['CFM_POP'].VENDORID = ['PM Vendor Master File'].VENDORID
2PONUMBER SearchPO NumberStringSTR17_POP_Number17
3POSTATUS SearchPO StatusIntegerDDL_PO_Status0
4DOCDATE SearchDocument DateDateDT8
5DUEDATE SearchDue DateDateDT8
6Amount SearchAmountCurrencyCurrency_19_019

Leave a Reply

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