Vendors Address Table Formats (VEAddress)
Follow Vision specifications for preparing a file containing vendor addresses.
Field Name | Data Type | Length | Notes |
---|---|---|---|
Vendor | varchar | 20 | Vendor number; primary key; must exist in VE |
Address | varchar | 20 | Vendor address code; primary key |
Address1 | varchar | 50 | First line of the vendor's address |
Address2 | varchar | 50 | Second line of the vendor's address |
Address3 | varchar | 50 | Third line of the vendor's address |
Address4 | varchar | 50 | Fourth line of the vendor's address |
City | varchar | 30 | Vendor's city |
State | varchar | 10 | Vendor's state
If you import both state and country, that combination must already be a valid combination in Vision. If you import a state but not a country, the state must be a valid state for the United States. |
ZIP | varchar | 10 | Vendor's zip code |
Country | varchar | 40 | Vendor's country |
Phone | varchar | 24 | Vendor's telephone number |
FAX | varchar | 24 | Vendor's fax number |
varchar | 50 | Vendor's email address | |
DefaultTaxCode | varchar | 3 | Default tax code for transactions charged to this vendor |
TaxCountryCode | varchar | 2 | Vendor's tax country code |
TaxRegistrationNumber | varchar | 15 | Vendor's tax registration number |
PrimaryInd | varchar | 1 | Flag indicating whether or not the Address is the vendor's primary address; default is N (No) |
VEAddressID | uniqueidentifier | 36 | Internal reference number for the vendor's address. |