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 |