Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CFM30300
Product: Cash Flow Management (1632)
Series:
Display Name: CFM_SOPAveDaysNoQuote
Physical Name: CFM30300
Technical Name: CFM_SOPAveDaysNoQuoteSeq 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_SOPAveDaysNoQuote'].CUSTNMBR AS 'CFM_SOPAveDaysNoQuote-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
CFM30300 AS ['CFM_SOPAveDaysNoQuote']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['CFM_SOPAveDaysNoQuote'].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