Employees - Customers Table Formats (EMClientAssoc)

Follow GovWin Capture Management specifications for preparing a file containing employee-customer associations.

Field Name	Data Type	Length	Notes
Employee	varchar	20	Employee number; primary key; must exist in EM
ClientID	varchar	32	Customer record number; primary key; must exist in CL (ClientID/Client)
Relationship	varchar	10	Customer's relationship to the employee; null or must exist in CFGEmployeeRelationship (Code/Description)
RelationshipDesc	text	unlimited	Text describing the relationship