Employees - Contacts Table Formats (EMContactAssoc)

Follow Vision 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