Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CFM30000
Product: Cash Flow Management (1632)
Series:
Display Name: CFM_SOPDueDateQuote
Physical Name: CFM30000
Technical Name: CFM_SOPDueDateQuoteSeq 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_SOPDueDateQuote'].CUSTNMBR AS 'CFM_SOPDueDateQuote-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
CFM30000 AS ['CFM_SOPDueDateQuote']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['CFM_SOPDueDateQuote'].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 Amount Amount Currency Currency_19_0 19 7 AMNTPAID Amount Paid Currency DLR17_RBS0_STR$ 17