Vendors Address Table Formats (VEAddress)
Follow Ajera CRM 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 Ajera CRM. 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 | |
| PrimaryInd | varchar | 1 | Flag indicating whether or not the Address is the vendor's primary address; default is N (No) |