Customers Table Formats (CL)

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

Field Name	Data Type	Length	Notes
Customer	varchar	20	Customer number
ClientID	varchar	32	Internal identifier for the customer; GovWin Capture Management-generated key; primary key
CurrentStatus	varchar	50	The customer's current relationship to the company; null or must exist in CFGCClientCurrentStatus
ExportInd	varchar	1	Default N; reserved for future use
Memo	text	unlimited 1	Memo field for notes about the customer
Name	varchar	100	Customer name; required field
Status	varchar	30	Customer status; required field; null or must exist in CFGClientStatus (Status/Label); valid options are A (Active), I (Inactive), or D (Dormant)
Type	varchar	10	Customer type; null or must exist in CFGClientType (Code/Description)
WebSite	varchar	255	Customer Web site address
Address	varchar	20	Unique identifier for the address record; required field
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.
Country	varchar	40	Customer country; must exist in CFGCountry
Zip	varchar	10	Customer zip code
EMail	varchar	50	Customer email address
Fax	varchar	24	Customer fax number
Phone	varchar	24	Customer telephone number
PrimaryInd	varchar	1	Variable indicating whether or not this is the customer's primary address; valid options are Y (Yes) or N (No)