Opportunities - Vendors Table Formats (OpportunityVEAssoc)

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

Field Name Data Type Length Notes

OpportunityID

varchar 32 Primary key; must exist in Opportunity (OpportunityID/Opportunity)

Vendor

varchar 20 Primary key; must exist in VE

Role

varchar 10 Null or must exist in CFGVendorRole (Code/Description)

VEAddress

varchar 20 Null or must exist in VEAddress

RoleDescription

text 16