Vendors - WBS1s Table Formats (VEProjectAssoc)
Follow Vision specifications for preparing a file containing vendor-WBS1 associations.
Field Name | Data Type | Length | Notes |
---|---|---|---|
Vendor | varchar | 20 | Internal reference number for the vendor record; must exist in VE; primary key |
WBS1 | varchar | 30 | Project record number; must exist in PR; primary key |
Role | varchar | 10 | Vendor's project role; null or must exist in CFGVendorRole (Code/Description) |
RoleDescription | char | unlimited | User-entered description of the vendor's role on the project |
TeamStatus | char | 10 | Variable indicating the vendor's Team status; valid options are Active or Proposed |
WBS2 | varchar | 7 | Phase record number |
WBS3 | varchar | 7 | Task record number |