Added in Version 7.0
The LEAD table stores all the information pertaining to a lead. The table contains lead first name, last name, type of lead, telephone numbers, e-mail addresses, and company name. The lead table also includes many user-defined fields.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
LEADID (PK) |
char(12) |
NOT NULL |
LEAD_LEADID_PK (CA) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (One) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (One) |
|||||
|
(One) to (Many) |
|||||
|
(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 |
|
|
|
|
ACCOUNTMANAGERID (FK) |
char(12) |
NULLS |
LEAD_ACCOUNTMANAGERID (IE) |
(Many) to (One) |
|
|
ASSIGNDATE |
datetime(8) |
NULLS |
|
|
|
|
BUSINESSDESCRIPTION |
varchar(2000) |
NULLS |
|
|
|
|
COMPANY |
varchar(128) |
NULLS |
LEAD_COMPANY (IE) |
|
|
|
COMPANY_UC |
varchar(128) |
NULLS |
LEAD_COMPANY_UC (IE) |
|
|
|
CREDITRATING |
varchar(10) |
NULLS |
|
|
|
|
DATAQUALITY |
varchar(32) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(128) |
NULLS |
|
|
|
|
DIVISION |
varchar(64) |
NULLS |
|
|
|
|
DONOTSOLICIT |
char(1) |
NULLS |
LEAD_DONOTSOLICIT (IE) |
|
|
|
|
varchar(128) |
NULLS |
LEAD_EMAIL (IE) |
|
|
|
EMPLOYEES |
varchar(32) |
NULLS |
|
|
|
|
FAX |
varchar(32) |
NULLS |
|
|
|
|
FIRSTNAME |
varchar(32) |
NULLS |
LEAD_FIRSTNAME (IE) |
|
|
|
HOMEPHONE |
varchar(32) |
NULLS |
|
|
|
|
IMPORTID (FK) |
char(12) |
NULLS |
LEAD_IMPORTID(IE) |
|
|
|
IMPORTSOURCE |
varchar(24) |
NULLS |
|
|
|
|
INDUSTRY |
varchar(64) |
NULLS |
|
|
|
|
INTERESTS |
varchar(128) |
NULLS |
|
|
|
|
ISPRIMARY |
char(1) |
NULLS |
|
|
|
|
LASTCALLDATE |
datetime(8) |
NULLS |
|
|
|
|
LASTNAME |
varchar(32) |
NULLS |
LEAD_LASTNAME (IE) |
|
|
|
LASTNAME_UC |
varchar(32) |
NULLS |
LEAD_LASTNAME_UC (IE) |
|
|
|
LEADSOURCEID (FK) |
char(12) |
NULLS |
LEAD_LEADSOURCEID (IE) |
(Many) to (One) |
|
|
MIDDLENAME |
varchar(32) |
NULLS |
|
|
|
|
MOBILE |
varchar(32) |
NULLS |
|
|
|
|
NEXTCALLDATE |
datetime(8) |
NULLS |
|
|
|
|
NOTES |
text(16) |
NULLS |
|
|
|
|
PREFERRED_CONTACT |
varchar(64) |
NULLS |
|
|
|
|
PREFIX |
varchar(16) |
NULLS |
|
|
|
|
PRIORITY |
varchar(32) |
NULLS |
|
|
|
|
QUALIFICATION_CATEGORYID (FK) |
char(12) |
NULLS |
LEAD_QUALIFICATION_CATEGORYID(IE) |
(Many) to (One) |
|
|
REVENUE |
varchar(32) |
NULLS |
|
|
|
|
SECCODEID (FK) |
char(12) |
NULLS |
LEAD_SECCODEID (IE) |
(Many) to (One) |
|
|
SICCODE |
varchar(64) |
NULLS |
|
|
|
|
STATUS |
varchar(64) |
NULLS |
LEAD_STATUS (IE) |
|
|
|
SUFFIX |
varchar(16) |
NULLS |
|
|
|
|
TICKER |
varchar(16) |
NULLS |
|
|
|
|
TITLE |
varchar(64) |
NULLS |
|
|
|
|
TOLLFREE |
varchar(32) |
NULLS |
|
|
|
|
TYPE |
varchar(64) |
NULLS |
LEAD_TYPE (IE) |
|
|
|
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 |
|
|
|
|
LEAD_ADDRESSID (FK) |
char(12) |
NULLS |
LEAD_LEAD_ADDRESSID (IE) |
(Many) to (One) |
|
|
DONOTEMAIL |
char(1) |
NULLS |
|
|
|
|
DONOTFAX |
char(1) |
NULLS |
|
|
|
|
DONOTMAIL |
char(1) |
NULLS |
|
|
|
|
DONOTPHONE |
char(1) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
|
APPID (FK) |
char(12) |
NULLS |
(Many) to (One) | ||
|
GLOBALSYNCID |
varchar(36) |
NULLS |
|||
|
TICK |
int |
NULLS |