| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| USERID | User ID |
String | 16 | View | |
| CUSTNMBR | Customer Number |
String | 16 | View | |
| CPRCSTNM | Corporate Customer Number |
String | 16 | View | |
| CUSTNAME | Customer Name |
String | 66 | View | |
| BALOVER | Balance Overdue |
Currency | 10 | View | |
| CUSTBLNC | Customer Balance |
Currency | 10 | View | |
| CUSTCLAS | Customer Class |
String | 16 | View | |
| CNTCPRSN | Contact Person |
String | 62 | View | |
| STMTNAME | Statement Name |
String | 66 | View | |
| ADRSCODE | Address Code |
String | 16 | View | |
| ADDRESS1 | Address 1 |
String | 62 | View | |
| ADDRESS2 | Address 2 |
String | 62 | View | |
| CITY | City |
String | 36 | View | |
| STATE | State |
String | 30 | View | |
| ZIP | Zip |
String | 12 | View | |
| COUNTRY | Country |
String | 62 | View | |
| PHONE1 | Phone 1 |
String | 22 | View | |
| FAX | Fax |
String | 22 | View | |
| SLPRSNID | Salesperson ID |
String | 16 | View | |
| SALSTERR | Sales Territory |
String | 16 | View | |
| USERDEF1 | User Defined 1 |
String | 22 | View | |
| USERDEF2 | User Defined 2 |
String | 22 | View | |
| PreferredContactMethod | Preferred Contact Method |
Integer | 2 | View | |
| Time_Zone | Time Zone |
Integer | 2 | View |