CFM_POPSQL (CFM40100)

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

Product: Cash Flow Management (1632)
Series:

Display Name: CFM_POPSQL
Physical Name: CFM40100
Technical Name: CFM_POPSQL

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_POPSQL'].VENDORID AS 'CFM_POPSQL-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       CFM40100 AS ['CFM_POPSQL']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['CFM_POPSQL'].VENDORID = ['PM Vendor Master File'].VENDORID
2PONUMBER SearchPO NumberStringSTR17_POP_Number17
3POSTATUS SearchPO StatusIntegerDDL_PO_Status0
4DOCDATE SearchDocument DateDateDT8
5PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['CFM_POPSQL'].PYMTRMID AS 'CFM_POPSQL-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       CFM40100 AS ['CFM_POPSQL']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['CFM_POPSQL'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
6DISGRPER SearchDiscount Grace PeriodIntegerINT2_U02
7DUEGRPER SearchDue Date Grace PeriodIntegerINT2_U02
8Amount SearchAmountCurrencyCurrency_19_019

Leave a Reply

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