Opportunities - Vendors Table Formats (OpportunityVEAssoc)
Follow DPS 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 |