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 |