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