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.
Added in Version 7.0
The CAMPAIGNLEADSOURCE table stores all the information pertaining to a campaign lead source. This information includes, but is not limited to, campaign lead source ID, campaign ID, description, and lead source ID.
|
|
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. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
CAMPAIGNLEADSOURCEID (PK) |
char(12) |
NOT NULL |
CAMPAIGNLEADSOURCE_ID_PK (CA) |
|
|
|
CAMPAIGNID (FK) |
char(12) |
NOT NULL |
|
(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(12) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(64) |
NULLS |
|
|
|
|
LEADSOURCEID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |