Employees - Contacts Table Formats (EMContactAssoc)

Follow Ajera CRM specifications for preparing a file containing employee-contact associations.

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