Added in Version 7.0
The LEAD_QUALIFICATION table stores lead qualification information.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
LEAD_QUALIFICATIONID (PK) |
char(12) |
NOT NULL |
LEAD_QUALIFICATION_ID_PK (CA) |
|
|
|
QUALIFICATIONID (FK) |
char(12) |
NOT NULL |
LEAD_QUALIFICATION_QUALID (IE) |
(Many) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
CHECKED |
char(1) |
NULLS |
|
|
|
|
LEADID (FK) |
char(12) |
NULLS |
LEAD_QUALIFICATION_LEADID (IE) |
(Many) to (One) |
|
|
NOTES |
text(16) |
NULLS |
|
|
|