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 |