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 |