Vendors - WBS1s Table Formats (VEProjectAssoc)
Follow Ajera CRM 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 |