If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document.
The History table stores information about closed activities and events that are associated to accounts, contacts, opportunities, tickets, defects, and contracts. The information includes type of activity, account, contact, and opportunity name, category, results, notes, completed date and time, process associated to the activity, and other details that can be entered by the user when completing an activity.
|
|
If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
HISTORYID (PK) |
STANDARDID(12) |
NOT NULL |
HISTORY_HISTORYID_PK (AK) |
(One) to (Many) |
|
|
(One) |
|||||
|
ACTIVITYID (FK) |
STANDARDID(12) |
NULLS |
HISTORY_ACTIVITYID (IE) |
(Many) to (One) |
|
|
(Many) to (One) |
|||||
|
TYPE |
int(4) |
NULLS |
HISTORY_TYPE (IE) |
|
|
|
ACCOUNTID (FK) |
STANDARDID(12) |
NULLS |
HISTORY_ACCOUNTID (IE) |
(Many) to (One) |
|
|
CONTACTID (FK) |
STANDARDID(12) |
NULLS |
HISTORY_CONTACTID (CA) |
(Many) to (One) |
|
|
OPPORTUNITYID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
ACCOUNTNAME |
varchar(128) |
NULLS |
|
|
|
|
CONTACTNAME |
varchar(128) |
NULLS |
|
|
|
|
OPPORTUNITYNAME |
varchar(64) |
NULLS |
|
|
|
|
PRIORITY |
varchar(64) |
NULLS |
|
|
|
|
CATEGORY |
varchar(64) |
NULLS |
|
|
|
|
STARTDATE |
datetime (8) |
NULLS |
HISTORY_STARTDATE (IE) |
|
|
|
DURATION |
int |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(255) |
NULLS |
|
|
|
|
PROCESSID (FK) |
STANDARDID(12) |
NULLS |
HISTORY_PROCESSID (IE) |
(Many) to (One) |
|
|
PROCESSNODE |
varchar(16) |
NULLS |
|
|
|
|
TIMELESS |
BOOLEAN(1) |
NULLS |
|
|
|
|
RECURRING |
BOOLEAN(1) |
NULLS |
|
|
|
|
ACTIVITYBASEDON (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
USERID (FK) |
STANDARDID(12) |
NULLS |
HISTORY_USERID (IE) |
(Many) to (One) |
|
|
USERNAME |
varchar(64) |
NULLS |
|
|
|
|
ORIGINALDATE |
datetime(8) |
NULLS |
|
|
|
|
RESULT |
varchar(64) |
NULLS |
HISTORY_RESULT (IE) |
|
|
|
RESULTCODE |
varchar(8) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
COMPLETEDDATE |
datetime(8) |
NULLS |
HISTORY_COMPLETEDDATE (IE) |
|
|
|
COMPLETEDUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
NOTES |
varchar(255) |
NULLS |
|
|
|
|
LONGNOTES |
TEXTBLOB(16) |
NULLS |
|
|
|
|
ATTACHMENT |
BOOLEAN(1) |
NULLS |
|
|
|
|
USERDEF1 |
varchar(255) |
NULLS |
|
|
|
|
USERDEF2 |
varchar(255) |
NULLS |
|
|
|
|
USERDEF3 |
varchar(255) |
NULLS |
|
|
|
|
TICKETID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
LEADID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
TICKETNUMBER |
varchar(64) |
NULLS |
|
|
|
|
LEADNAME |
varchar(64) |
NULLS |
|
|
|
|
ATTACHMENTCOUNT |
int |
NULLS |
|
|
|
|
LOCATION |
varchar(255) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
|
APPID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
GLOBALSYNCID |
varchar(36) |
NULLS |
|
|
|
|
TICK |
int |
NULLS |
|
|
|
| IONWORKFLOWDEFINITIONID |
nchar(12) |
NULLS |
|||
| IONWORKFLOWDEFINITIONNAME |
nvarchar(36) |
NULLS |