Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CN04001
Product: Collections Management (1157)
Series: Sales
Display Name: Collections - Customer DSO Log
Physical Name: CN04001
Technical Name: CN_Customer_DSO_LogSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR 
Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['Collections - Customer DSO Log'].CUSTNMBR AS 'Collections - Customer DSO Log-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
CN04001 AS ['Collections - Customer DSO Log']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Collections - Customer DSO Log'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 STRTDATE Start Date DT Date 8 3 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 4 ENDDATE End Date DT Date 8 5 DATEDONE Date Done DT Date 8 6 SLSAMNT Sales Amount DLR19_RBSO_UTR$ Currency 19 7 Outstanding_Amount Outstanding Amount DLR19_RBS0_UTR$ Currency 19 8 NMBROFDYS Number of Days INT3_U0 Integer 3 9 CN_DSO CN_DSO DLR5_U2 Currency 8