Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
CMPANYID | Company ID |
Integer | 2 | View | |
LOCATNID | Location ID |
String | 16 | View | |
LOCATNNM | Location Name |
String | 32 | View | |
ADRSCODE | Address Code |
String | 16 | View | |
ADRCNTCT | Address Contact |
String | 62 | View | |
ADDRESS1 | Address 1 |
String | 62 | View | |
ADDRESS2 | Address 2 |
String | 62 | View | |
ADDRESS3 | Address 3 |
String | 62 | View | |
CITY | City |
String | 36 | View | |
COUNTY | County |
String | 62 | View | |
STATE | State |
String | 30 | View | |
ZIPCODE | Zip Code |
String | 12 | View | |
COUNTRY | Country |
String | 62 | View | |
PHONE1 | Phone 1 |
String | 22 | View | |
PHONE2 | Phone 2 |
String | 22 | View | |
PHONE3 | Phone 3 |
String | 22 | View | |
FAXNUMBR | Fax Number |
String | 22 | View | |
CHANGEBY_I | Change By |
String | 16 | View | |
CHANGEDATE_I | Change Date |
Date | 4 | View | |
NOTEINDX | Note Index |
Currency | 10 | View | |
CCode | Country Code |
String | 8 | View |