Added in Version 6.2
The CAMPAIGNTASK table stores data related to the tasks associated with marketing campaigns. Tasks are assignments, such as writing the draft copy for a newspaper advertisementor sending a direct mail piece to the printer, that require owners. Owners can be Infor CRM users or outside vendors. Owners are assigned to tasks in the Infor CRM Client using the Manage Campaigns dialog box.
| Field | Datatype (Length) | Allow Nulls | Indexes | Values | Relationship | Related Table and Field |
|---|---|---|---|---|---|---|
|
CAMPAIGNTASKID (PK) |
char(12) |
NOT NULL |
CAMPAIGNTASK_CAMPAIGNTASKID_PK (CA) |
|
|
|
|
CAMPAIGNID(FK) |
char(12) |
NOT NULL |
CAMPAIGNTASK_CAMPAIGNID (IE) |
|
(Many) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
|
DESCRIPTION |
varchar(64) |
NULLS |
|
|
|
|
|
OWNERNAME |
varchar(64) |
NULLS |
|
|
|
|
|
OWNERTYPE |
char(1) |
NULLS |
|
0=Existing Users/Teams, 1=Department, 2=Contact, 3=Other Individual, 4=None |
|
|
|
DATEASSIGNED |
datetime |
NULLS |
|
|
|
|
|
DUEDATE |
datetime |
NULLS |
|
|
|
|
|
COMPLETED |
char(1) |
NULLS |
|
|
|
|
|
BUDGETAMOUNT |
decimal(17,4) |
NULLS |
|
|
|
|
|
ACTUALCOST |
float(8) |
NULLS |
|
|
|
|
|
USERID (FK) |
char(12) |
NULLS |
|
|
(Many) to (One) |
|
|
CONTACTID (FK) |
char(12) |
NULLS |
|
|
(Many) to (One) |
|
|
COMPLETEDDATE |
datetime |
NULLS |
|
|
|
|
|
STATUS |
varchar(64) |
NULLS |
|
|
|
|
|
ASSIGNTOID |
char(12) |
NULLS |
|
|
not populated per Cessna |
|
|
PRIORITY |
varchar(64) |
NULLS |
|
|
|
|
|
PERCENTCOMPLETE |
float(8) |
NULLS |
|
|
|
|
|
CAMPAIGNTYPE |
varchar(64) |
NULLS |
|
|
|
|
|
CALENDARDISPLAY |
char(1) |
NULLS |
|
|
|
|
|
BUDGETHOURS |
float(8) |
NULLS |
|
|
|
|
|
ACTUALHOURS |
float(8) |
NULLS |
|
|
|
|
|
NOTES |
text(16) |
NULLS |
|
|
|
|
|
CAMPAIGNSTAGEID (FK) |
char(12) |
NULLS |
|
|
(Many) to (One) |
|
|
BUDGETEXPENSES |
float(8) |
NULLS |
|
|
|
|
|
ACTUALEXPENSES |
float(8) |
NULLS |
|
|
|
|