HIST_LEAD Table

Added in Version 7.0

The HisT_LEAD table stores data from the Lead table when a Lead is deleted or converted.

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.
While this table does not have a field defined as a primary key, the HIST_LEADID field should be unique and considered a primary key.

Field	Datatype (Length)	Allow Nulls	Indexes	Relationship	Related Table and Field
HIST_LEADID	char(12)	NOT NULL	HIST_LEAD_HIST_LEADID (IE)	(One) to (Many)	HIST_LEAD_ADDRESS.HIST_LEADID
HIST_LEADID	char(12)	NOT NULL	HIST_LEAD_HIST_LEADID (IE)	(One) to (Many)	HisT_LEAD_HISTORY.HIST_LEADID
CREATEUSER (FK)	char(12)	NULLS		(Many) to (One)	USERINFO.USERID
CREATEDATE	datetime(8)	NULLS
MODIFYUSER (FK)	char(12)	NULLS		(Many) to (One)	USERINFO.USERID
MODIFYDATE	datetime(8)	NULLS
ACCOUNT_MERGED	char(1)	NULLS
ACCOUNTID (FK)	char(12)	NULLS	HIST_LEAD_ACCOUNTID (IE)	(Many) to (One)	ACCOUNT.ACCOUNTID
ACCOUNTMANAGERID (FK)	char(12)	NULLS	HIST_LEAD_ACCOUNTMGRID (IE)	(Many) to (One)	USERSECURITY.USERID
ASSIGNDATE	datetime(8)	NULLS
BUSINESSDESCRIPTION	varchar(2000)	NULLS
COMPANY	varchar(128)	NULLS
COMPANY_UC	varchar(128)	NULLS
CONTACT_MERGED	char(1)	NULLS
CONTACTID (FK)	char(12)	NULLS	HIST_LEAD_CONTACTID (IE)	(Many) to (One)	CONTACT.CONTACTID
CREDITRATING	varchar(10)	NULLS
DATAQUALITY	varchar(32)	NULLS
DESCRIPTION	varchar(128)	NULLS
DIVISION	varchar(64)	NULLS
DONOTSOLICIT	char(1)	NULLS
EMAIL	varchar(128)	NULLS
EMPLOYEES	varchar(32)	NULLS
FAX	varchar(32)	NULLS
FIRSTNAME	varchar(32)	NULLS
HOMEPHONE	varchar(32)	NULLS
IMPORTID (FK)	char(12)	NULLS	HIST_LEAD_IMPORTID (IE)	(Many) to (One)	HIST_LEAD_HISTORY.IMPORTID
IMPORTSOURCE	varchar(24)	NULLS
INDUSTRY	varchar(64)	NULLS
INTERESTS	varchar(128)	NULLS
ISPRIMARY	char(1)	NULLS
LASTCALLDATE	datetime(8)	NULLS
LASTNAME	varchar(32)	NULLS
LASTNAME_UC	varchar(32)	NULLS
LEAD_ADDRESSID (FK)	char(12)	NULLS	HIST_LEAD_ADDRESSID (IE)	(Many) to (One)	LEAD_ADDRESS.LEAD_ADDRESSID
LEAD_PROCESSED_BY (FK)	char(12)	NULLS	HIST_LEAD_PROCESSED_BY (IE)	(Many) to (One)	USERSECURITY.USERID
LEAD_PROCESSED_DATE	datetime(8)	NULLS
LEADID (FK)	char(12)	NULLS	HIST_LEAD_LEADID (IE)	(One) to (One)	LEAD.LEADID
LEADID (FK)	char(12)	NULLS	HIST_LEAD_LEADID (IE)	(One) to (One)	HIST_LEAD_ADDRESS.HIST.LEADID
LEADSOURCEID (FK)	char(12)	NULLS	HIST_LEAD_LEADSOURCEID (IE)	(One) to (One)	LEADSOURCE.LEADSOURCEID
MIDDLENAME	varchar(32)	NULLS
MOBILE	varchar(32)	NULLS
NEXTCALLDATE	datetime(8)	NULLS
NOTES	text(16)	NULLS
OPPORTUNITYID (FK)	char(12)	NULLS	HIST_LEAD_OPPORTUNITYID (IE)	(Many) to (One)	OPPORTUNITY.OPPORTUNITYID
ORIGINAL_CREATEDATE	datetime(8)	NULLS
ORIGINAL_CREATEUSER (FK)	char(12)	NULLS		(Many) to (One)	USERINFO.USERID
ORIGINAL_MODIFYDATE	datetime(8)	NULLS
ORIGINAL_MODIFYUSER (FK)	char(12)	NULLS		(Many) to (One)	USERINFO.USERID
PREFERRED_CONTACT	varchar(64)	NULLS
PREFIX	varchar(16)	NULLS
PRIORITY	varchar(32)	NULLS
RECORD_COLLECTED1	char(1)	NULLS
RECORD_COLLECTED2	char(1)	NULLS
REVENUE	varchar(32)	NULLS
SECCODEID (FK)	char(12)	NULLS	HIST_LEAD_SECCODEID (IE)	(Many) to (One)	SECCODE.SECCODEID
SICCODE	varchar(64)	NULLS
STATUS	varchar(64)	NULLS
SUFFIX	varchar(16)	NULLS
TICKER	varchar(16)	NULLS
TITLE	varchar(64)	NULLS
TOLLFREE	varchar(32)	NULLS
TYPE	varchar(64)	NULLS
USERFIELD1	varchar(80)	NULLS
USERFIELD2	varchar(80)	NULLS
USERFIELD3	varchar(80)	NULLS
USERFIELD4	varchar(80)	NULLS
USERFIELD5	varchar(80)	NULLS
USERFIELD6	varchar(80)	NULLS
USERFIELD7	varchar(80)	NULLS
USERFIELD8	varchar(80)	NULLS
USERFIELD9	varchar(80)	NULLS
USERFIELD10	varchar(80)	NULLS
WEBADDRESS	varchar(128)	NULLS
WORKPHONE	varchar(32)	NULLS