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 |
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) |