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 |
