CN100100 - Collections - Query
Dynamics GP table CN100100 (Collections - Query) contains 24 columns including USERID, CUSTNMBR, CPRCSTNM....
SQL Query Builder
24 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| USERID | User ID | String | 16 | |
| CUSTNMBR | Customer Number | String | 16 | |
| CPRCSTNM | Corporate Customer Number | String | 16 | |
| CUSTNAME | Customer Name | String | 66 | |
| BALOVER | Balance Overdue | Currency | 10 | |
| CUSTBLNC | Customer Balance | Currency | 10 | |
| CUSTCLAS | Customer Class | String | 16 | |
| CNTCPRSN | Contact Person | String | 62 | |
| STMTNAME | Statement Name | String | 66 | |
| ADRSCODE | Address Code | String | 16 | |
| ADDRESS1 | Address 1 | String | 62 | |
| ADDRESS2 | Address 2 | String | 62 | |
| CITY | City | String | 36 | |
| STATE | State | String | 30 | |
| ZIP | Zip | String | 12 | |
| COUNTRY | Country | String | 62 | |
| PHONE1 | Phone 1 | String | 22 | |
| FAX | Fax | String | 22 | |
| SLPRSNID | Salesperson ID | String | 16 | |
| SALSTERR | Sales Territory | String | 16 | |
| USERDEF1 | User Defined 1 | String | 22 | |
| USERDEF2 | User Defined 2 | String | 22 | |
| PreferredContactMethod | Preferred Contact Method | Integer | 2 | |
| Time_Zone | Time Zone | Integer | 2 |
Related Tables
Tables that share columns with CN100100. Click "Join" to add to your query.