Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CFM30500
Product: Cash Flow Management (1632)
Series:
Display Name: CFM_SOPSQL
Physical Name: CFM30500
Technical Name: CFM_SOPSQLSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR 
Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['CFM_SOPSQL'].CUSTNMBR AS 'CFM_SOPSQL-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
CFM30500 AS ['CFM_SOPSQL']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['CFM_SOPSQL'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 SOPNUMBE SOP Number String STR20_SOP_Number 17 3 SOPTYPE SOP Type Integer DDL_SOP_Type 0 4 DOCDATE Document Date Date DT 8 5 DUEDATE Due Date Date DT 8 6 PYMTRMID Payment Terms ID String STR20_Payment_Terms_ID 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['CFM_SOPSQL'].PYMTRMID AS 'CFM_SOPSQL-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
CFM30500 AS ['CFM_SOPSQL']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['CFM_SOPSQL'].PYMTRMID = ['Payment Terms Master'].PYMTRMID7 DISGRPER Discount Grace Period Integer INT2_U0 2 8 DUEGRPER Due Date Grace Period Integer INT2_U0 2 9 Amount Amount Currency Currency_19_0 19 10 AMNTPAID Amount Paid Currency DLR17_RBS0_STR$ 17