Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CN100100
Product: Collections Management (1157)
Series: Sales
Display Name: Collections - Query Group Display Name: Collection Query
Physical Name: CN100100
Technical Name: CN_Query
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 - Query'].USERID AS 'Collections - Query-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CN100100 AS ['Collections - Query']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Collections - Query'].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 - Query'].CUSTNMBR AS 'Collections - Query-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
CN100100 AS ['Collections - Query']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Collections - Query'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
| 3 | CPRCSTNM | Corporate Customer Number | STR15_RM_Customer_Number | String | 15 | |
| 4 | CUSTNAME | Customer Name | STR64_Customer_Name | String | 64 | |
| 5 | BALOVER | Balance Overdue | DLR19_$S2 | Currency | 19 | |
| 6 | CUSTBLNC | Customer Balance | DLR19_RBS0_STR$ | Currency | 19 | |
| 7 | CUSTCLAS | Customer Class | STR15_Customer_Class | String | 15 | |
| 8 | CNTCPRSN | Contact Person | STR60 | String | 60 | |
| 9 | STMTNAME | Statement Name | STR64 | String | 64 | |
| 10 | ADRSCODE | Address Code | STR15_Address_Code | String | 15 | |
| 11 | ADDRESS1 | Address 1 | STR60 | String | 60 | |
| 12 | ADDRESS2 | Address 2 | STR60 | String | 60 | |
| 13 | CITY | City | STR35 | String | 35 | |
| 14 | STATE | State | STR30_State | String | 29 | |
| 15 | ZIP | Zip | STR10 | String | 10 | |
| 16 | COUNTRY | Country | STR60 | String | 60 | |
| 17 | PHONE1 | Phone 1 | Phone_Number | String | 14 | |
| 18 | FAX | Fax | STR14_FAX | String | 14 | |
| 19 | SLPRSNID | Salesperson ID | STR15_Salesperson_ID | String | 15 | |
Key to the RM Salesperson Master (RM00301).
Click to show/hideSELECT
['Collections - Query'].SLPRSNID AS 'Collections - Query-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
CN100100 AS ['Collections - Query']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['Collections - Query'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID | ||||||
| 20 | SALSTERR | Sales Territory | STR15_Sales_Territory | String | 15 | |
Key to the Sales Territory Master File (RM00303).
Click to show/hideSELECT
['Collections - Query'].SALSTERR AS 'Collections - Query-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
CN100100 AS ['Collections - Query']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['Collections - Query'].SALSTERR = ['Sales Territory Master File'].SALSTERR | ||||||
| 21 | USERDEF1 | User Defined 1 | STR20 | String | 20 | |
| 22 | USERDEF2 | User Defined 2 | STR20 | String | 20 | |
| 23 | PreferredContactMethod | Preferred Contact Method | paDDLPreferredContactMethod | Integer | 0 | |
| 24 | Time_Zone | Time Zone | DDL_Time_Zone | Integer | 0 | |