| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| VENDORID | Vendor ID |
String | 16 | View | |
| ADRSCODE | Address Code |
String | 16 | View | |
| VNDCNTCT | Vendor 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 | |
| STATE | State |
String | 30 | View | |
| ZIPCODE | Zip Code |
String | 12 | View | |
| COUNTRY | Country |
String | 62 | View | |
| UPSZONE | UPS Zone |
String | 4 | View | |
| PHNUMBR1 | Phone Number 1 |
String | 22 | View | |
| PHNUMBR2 | Phone Number 2 |
String | 22 | View | |
| PHONE3 | Phone 3 |
String | 22 | View | |
| FAXNUMBR | Fax Number |
String | 22 | View | |
| SHIPMTHD | Shipping Method |
String | 16 | View | |
| TAXSCHID | Tax Schedule ID |
String | 16 | View | |
| EmailPOs | Email Purchase Orders |
Boolean | 2 | View | |
| POEmailRecipient | Purchase Order Email Recipient |
String | 82 | View | |
| EmailPOFormat | Email PO Format |
Integer | 2 | View | |
| FaxPOs | Fax Purchase Orders |
Boolean | 2 | View | |
| POFaxNumber | Purchase Order Fax Number |
String | 22 | View | |
| FaxPOFormat | Fax PO Format |
Integer | 2 | View | |
| CCode | Country Code |
String | 8 | View | |
| DECLID | Declarant ID |
String | 16 | View |