The LeadSource table contains information for marketing sources (leads) that can be associated with contacts or opportunities. Examples of leads are event seminars, direct mailings, trade shows, Web advertisements, or targeted mailings that can direct or point prospective customers to your products or services. This table stores the description, abbreviated description, source date, type, status, and cost of the lead source. The information for the LEADSOURCE table is entered in the Infor CRM Windows Client (Tools > Manage > Lead Sources).
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
LEADSOURCEID (PK) |
STANDARDID(12) |
NOT NULL |
LEADSOURCE_LEADSOURCEID_PK (CA) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
DESCRIPTION |
varchar(64) |
NULLS |
LEADSOURCE_DESCRIPTION (IE) |
|
|
|
ABBREVDESC |
varchar(32) |
NULLS |
LEADSOURCE_ABBREVDESC (IE) |
|
|
|
SOURCEDATE |
datetime(8) |
NULLS |
|
|
|
|
TYPE |
varchar(64) |
NULLS |
|
|
|
|
STATUS |
varchar(64) |
NULLS |
|
|
|
|
COST |
decimal(17,4) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One)
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|