Marketing Campaigns - Projects Table Formats (MktCampaignProjectAssoc)

Follow Vision specifications for preparing a file containing marketing campaign-project associations.

Field Name Data Type Length Notes
CampaignID varchar 32 Internal reference number for the marketing campaign record; primary key; must exist in MktCampaign
WBS1 varchar 30 Projectnumber; primary key; must exist in PR
WBS2 varchar 7 Phase number; primary key; must exist in PR
WBS3 varchar 7 Task number; primary key; must exist in PR