Added in Version 6.2
The CAMPAIGN table stores information related to marketing campaigns. This information includes the campaign description, projected and actual launch dates, forecast budget for the campaign, actual cost, target audience details, contact process for the campaign (if applicable), number of units of the campaign item, status, and other details.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
CAMPAIGNID (PK) |
char(12) |
NULLS |
CAMPAIGN_CAMPAIGNID_PK (CA) |
(Many) to (One) |
|
|
(Many) to (One) |
|||||
|
(Many) to (One) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(Many) to (One) |
|||||
|
(One) to (Many) |
|||||
|
(Many) to (One) |
|||||
|
(Many) to (One) |
|||||
|
(One) to (Many) |
|||||
|
(Many) to (One) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
CAMPAIGNNAME |
varchar(64) |
NULLS |
CAMPAIGN_CAMPAIGNNAME (IE) |
|
|
|
CAMPAIGNCODE |
varchar(32) |
NULLS |
CAMPAIGN_CAMPAIGNCODE (IE) |
|
|
|
PROJECTEDLAUNCHDATE |
datetime(8) |
NULLS |
|
|
|
|
ACTUALLAUNCHDATE |
datetime(8) |
NULLS |
|
|
|
|
FORECASTBUDGET |
decimal(17,4) |
NULLS |
|
|
|
|
ACTUALCOST |
decimal(17,4) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(64) |
NULLS |
|
|
|
|
STATUS |
varchar(32) |
NULLS |
|
|
|
|
TARGETAUDIENCENOTES |
varchar(255) |
NULLS |
|
|
|
|
TARGETAUDIENCEGROUP |
varchar(255) |
NULLS |
|
|
|
|
TARGETAUDIENCELIST |
varchar(64) |
NULLS |
|
|
|
|
CONTACTPROCESSNAME |
varchar(64) |
NULLS |
|
|
|
|
UNITSCREATED |
int(4) |
NULLS |
|
|
|
|
EXPECTEDRESULTS |
decimal(17,4) |
NULLS |
|
|
|
|
ACTUALRESULTS |
decimal(17,4) |
NULLS |
|
|
|
|
CALLTOACTION |
varchar(64) |
NULLS |
|
|
|
|
TASKBUDGETAMOUNT |
decimal(17,4) |
NULLS |
|
|
|
|
TASKACTUALAMOUNT |
decimal(17,4) |
NULLS |
|
|
|
|
FAMILY |
varchar(32) |
NULLS |
|
|
|
|
CAMPAIGNTYPE |
varchar(32) |
NULLS |
|
|
|
|
POTENTIALRESPONSES |
int(4) |
NULLS |
|
|
|
|
ACTUALRESPONSES |
int(4) |
NULLS |
|
|
|
|
ACTUALTOTALSALES |
decimal(17,4) |
NULLS |
|
|
|
|
OBJECTIVES |
varchar(255) |
NULLS |
|
|
|
|
LEADSOURCEID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ACCOUNTMANAGERID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CALENDARDISPLAY |
char(12) |
NULLS |
|
|
|
|
TEMPLATEONLY |
char(12) |
NULLS |
|
|
unknown |
|
TARGETAUDIENCETARGETCOUNT |
int(4) |
NULLS |
|
|
|
|
STARTDATE |
datetime(8) |
NULLS |
|
|
|
|
ENDDATE |
datetime(8) |
NULLS |
|
|
|
|
TARGETAUDIENCELOCATION |
varchar(64) |
NULLS |
|
|
|
|
EXPECTEDCONTACTRESPONSES |
int(4) |
NULLS |
|
|
|
|
CAMPAIGNLEADSOURCES |
text(16) |
NULLS |
|
|
|
|
EXPECTEDLEADRESPONSES |
int(4) |
NULLS |
|
|
|
|
USEEXTERNALLIST |
char(1) |
NULLS |
|
|
|
|
SECCODEID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
EXPENSEBUDGET |
float(8) |
NULLS |
|
|
|
|
EXPENSEACTUAL |
float(8) |
NULLS |
|
|
|
|
POTCONTACTLISTRESPQTY |
int(4) |
NULLS |
|
|
|
|
POTLEADLISTRESPQTY |
int(4) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|