Vendor - WBS1s Table Formats (VEProjectAssoc)

Follow Deltek 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