Vendor Address Table Formats (VEAddress)

Follow DPS 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 DPS. 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
Email	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.