Clients Address Table Formats (CLAddress)
Follow Vision specifications for preparing a file containing client addresses.
Field Name | Data Type | Length | Notes |
---|---|---|---|
ClientID | varchar | 32 | Internal reference number for the Client record; required field; primary key; must exist in CL (ClientID/Client) |
Address | varchar | 20 | Unique identifier for the address record; required field; primary key |
Address1 | varchar | 50 | First line of the client address |
Address2 | varchar | 50 | Second line of the client address |
Address3 | varchar | 50 | Third line of the client address |
Address4 | varchar | 50 | Fourth line of the client address |
Addressee | varchar | 50 | Invoice addressee; not used |
City | varchar | 30 | Client city |
State | varchar | 10 | Client state.
The state must exist in CFGStates. 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 | Client zip code |
Country | varchar | 40 | Client country |
Phone | varchar | 24 | Client telephone number |
FAX | varchar | 24 | Client fax number |
varchar | 50 | Client email address | |
TaxCountryCode | varchar | 2 | Client tax country code |
TaxRegistrationNumber | varchar | 15 | Client tax registration number |
PrimaryInd | varchar | 1 | Variable indicating whether or not this is the client's primary address; valid options are Y (Yes) or N (No); default 'N' |
Billing | varchar | 1 | Variable indicating whether or not this is the client's billing address; valid options are Y (Yes) or N (No); default 'N' |
CLAddressID | uniqueidentifier | 36 | Internal reference number for the client's address. |