Added in Version 7.5
The HisT_LEAD_HISTORY table stores all completed activities for Leads when a user deletes a Lead.
|
|
|
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
HIST_LEAD_HISTORYID |
char(12) |
NOT NULL |
HIST_LEAD_HISTORY_PRIMARY (AK) |
|
|
|
HIST_LEADID |
char(12) |
NOT NULL |
HIST_LEAD_HISTORY_HIST_LEADID (IE) |
(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 |
|
|
|
|
ACTIVITYBASEDON |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ACTIVITYID (FK) |
char(12) |
NULLS |
HIST_LEAD_HISTORY_ACTIVITYID (IE) |
(Many) to (One) |
|
|
ATTACHMENT |
varchar(1) |
NULLS |
|
|
|
|
CATEGORY |
varchar(64) |
NULLS |
|
|
|
|
COMPLETEDDATE |
datetime(8) |
NULLS |
HIST_LEAD_HISTORY_COMPLETEDAT (IE) |
|
|
|
COMPLETEDUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
DESCRIPTION |
varchar(64) |
NULLS |
|
|
|
|
DURATION |
int(4) |
NULLS |
|
|
|
|
HISTORYID (FK) |
char(12) |
NULLS |
HIST_LEAD_HISTORY_HISTORYID (IE) |
(Many) to (One) |
|
|
LONGNOTES |
text |
NULLS |
|
|
|
|
NOTES |
varchar(255) |
NULLS |
|
|
|
|
OPPORTUNITYID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
OPPORTUNITYNAME |
varchar(64) |
NULLS |
|
|
|
|
ORIGINAL_CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
ORIGINAL_CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ORIGINAL_MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
ORIGINAL_MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ORIGINALDATE |
datetime(8) |
NULLS |
|
|
|
|
PRIORITY |
varchar(64) |
NULLS |
|
|
|
|
PROCESSID (FK) |
char(12) |
NULLS |
HIST_LEAD_HISTORY_PROCESSID (IE) |
(Many) to (One) |
|
|
PROCESSNODE |
varchar(16) |
NULLS |
|
|
|
|
RECURRING |
varchar(1) |
NULLS |
|
|
|
|
RESULT |
varchar(64) |
NULLS |
HIST_LEAD_HISTORY_RESULT (IE) |
|
|
|
RESULTCODE |
varchar(8) |
NULLS |
|
|
|
|
STARTDATE |
datetime(8) |
NULLS |
HIST_LEAD_HISTORY_STARTDATE (IE) |
|
|
|
TICKETID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
TICKETNUMBER |
varchar(64) |
NULLS |
|
|
|
|
TIMELESS |
varchar(1) |
NULLS |
|
|
|
|
TYPE |
int(4) |
NULLS |
HIST_LEAD_HISTORY_TYPE (IE) |
|
|
|
USERDEF1 |
varchar(255) |
NULLS |
|
|
|
|
USERDEF2 |
varchar(255) |
NULLS |
|
|
|
|
USERDEF3 |
varchar(255) |
NULLS |
|
|
|
|
USERID (FK) |
char(12) |
NULLS |
HIST_LEAD_HISTORY_USERID (IE) |
(Many) to (One) |
|
|
USERNAME |
varchar(64) |
NULLS |
|
|
|
