Opportunities - Employees Table Formats (OpportunityEMAssoc)

Follow Vision specifications for preparing a file containing opportunity-employee associations.

Field Name Data Type Length Notes
OpportunityID varchar 32 Opportunity's number; primary key; must exist in Opportunity (OpportunityID/Opportunity)
Employee varchar 20 Employee's employee number; primary key; must exist in EM
Role varchar 10 Employee's role in the opportunity; null or must exist in CFGEmployeeRole (Code/Description)
RoleDescription text 16 Text describing the role