Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CN100200
Product: Collections Management (1157)
Series: Sales
Display Name: Collections - Build Letters Work Group Display Name: Collection Query
Physical Name: CN100200
Technical Name: CN_Build_Letters
Group Technical Name: CollectionQuery
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | USERID  | User ID | STR15_User_ID | String | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Collections - Build Letters Work'].USERID AS 'Collections - Build Letters Work-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CN100200 AS ['Collections - Build Letters Work']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Collections - Build Letters Work'].USERID = ['Users Master'].USERID | ||||||
| 2 | CUSTNMBR | Customer Number | STR15_RM_Customer_Number | String | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['Collections - Build Letters Work'].CUSTNMBR AS 'Collections - Build Letters Work-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
CN100200 AS ['Collections - Build Letters Work']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Collections - Build Letters Work'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
| 3 | ADRSCODE | Address Code | STR15_Address_Code | String | 15 | |
| 4 | TXTFIELD | Text Field | TX32000 | Text | 32000 | |