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_POPSeq 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_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'].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 DUEDATE Due Date Date DT 8 6 Amount Amount Currency Currency_19_0 19