HIST_LEAD_ADDRESS Table

Added in Version 7.0

The HIST_LEAD_ADDRESS table stores data from the Lead_Address 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.

Legend
 

Field Datatype (Length) Allow Nulls Indexes Relationship Related Table and Field

HIST_LEAD_ADDRESSID

char(12)

NOT NULL

HIST_LEAD_ADDRESSID (IE)

    

HIST_LEADID (FK)

char(12)

NOT NULL

HIST_LEAD_HISTLEADID (IE)

(One) to (Many)

HIST_LEAD.HIST_LEADID

(One) to (Many)

HIST_LEAD.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

      

ADDRESS1

varchar(64)

NULLS

      

ADDRESS2

varchar(64)

NULLS

      

ADDRESS3

varchar(64)

NULLS

      

ADDRESS4

varchar(64)

NULLS

      

CITY

varchar(32)

NULLS

      

COUNTRY

varchar(32)

NULLS

      

COUNTY

varchar(32)

NULLS

      

DESCRIPTION

varchar(64)

NULLS

      

IMPORTID (FK)

char(12)

NULLS

HIST_LEAD_IMPORTID (IE)

 

unknown

ISMAILING

char(1)

NULLS

      

ISPRIMARY

char(1)

NULLS

      

POSTALCODE

varchar(24)

NULLS

      

ROUTING

varchar(64)

NULLS

      

SALUTATION

varchar(64)

NULLS

      

STATE

varchar(32)

NULLS

      

TIMEZONE

varchar(64)

NULLS

      

TYPE

varchar(64)

NULLS