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_POPSQLSeq 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_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'].VENDORID2 PONUMBER PO Number String STR17_POP_Number 17 3 POSTATUS PO Status Integer DDL_PO_Status 0 4 DOCDATE Document Date Date DT 8 5 PYMTRMID Payment Terms ID String STR20_Payment_Terms_ID 20 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'].PYMTRMID6 DISGRPER Discount Grace Period Integer INT2_U0 2 7 DUEGRPER Due Date Grace Period Integer INT2_U0 2 8 Amount Amount Currency Currency_19_0 19