Vendor/Partners Address Table Formats (VEAddress)

Follow GovWin Capture Management specifications for preparing a file containing vendor/partner addresses.

Field Name Data Type Length Notes
Vendor/partner varchar 20 Vendor/partner number; primary key; must exist in VE
Address varchar 20 Vendor/partner address code; primary key
Address1 varchar 50 First line of the vendor/partner's address
Address2 varchar 50 Second line of the vendor/partner's address
Address3 varchar 50 Third line of the vendor/partner's address
Address4 varchar 50 Fourth line of the vendor/partner's address
City varchar 30 Vendor/partner's city
State varchar 10 Vendor/partner's state

If you import both state and country, that combination must already be a valid combination in GovWin Capture Management. If you import a state but not a country, the state must be a valid state for the United States.

ZIP varchar 10 Vendor/partner's zip code
Country varchar 40 Vendor/partner's country
Phone varchar 24 Vendor/partner's telephone number
FAX varchar 24 Vendor/partner's fax number
Email varchar 50 Vendor/partner's email address
PrimaryInd varchar 1 Flag indicating whether or not the Address is the vendor/partner's primary address; default is N (No)