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