Customers Address Table Formats (CLAddress)

Follow GovWin Capture Management specifications for preparing a file containing customer addresses.

Field Name	Data Type	Length	Notes
ClientID	varchar	32	Internal reference number for the Customer 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 customer address
Address2	varchar	50	Second line of the customer address
Address3	varchar	50	Third line of the customer address
Address4	varchar	50	Fourth line of the customer address
City	varchar	30	Customer city
State	varchar	10	Customer state. The state must exist in CFGStates. 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	Customer zip code
Country	varchar	40	Customer country
Phone	varchar	24	Customer telephone number
FAX	varchar	24	Customer tax number
Email	varchar	50	Customer email address