Marketing Campaigns File Links Table Formats (MktCampaignFileLinks)

Follow Vision specifications for preparing a file containing marketing campaign file links.

Field Name Data Type Length Notes

LinkID

varchar 32 Unique internal key for the file's link to the marketing campaign record; primary key

CampaignID

varchar 32 Internal reference number for the marketing campaign record; required field; must exist in MktCampaign

Description

varchar 100 User-entered file description

FilePath

varchar 255 File's file path location

Graphic

varchar 1 Variable indicating whether or not the linked file is a graphic file; default is N (No)