Table Name:	lead_source
Table Number:	5017
Group:	Sales Mgr
Description:	A specific component of a campaign that is associated with incoming leads and other new sales opportunities
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_lead_source

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
comments	CHAR	varchar		255			Comments about the lead source
description	CHAR	varchar		255			Description of the lead source	Search (5)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
end_date	CLK_TIME	datetime					The date the lead source ends	Search (3)
expense	DECIMAL	decimal (19,4)				CURRENCY	Lead source cost
id	CHAR	varchar		32			Unique identifier of the lead source	Search (6)
is_default	LONG	int			0	DIRECT	Indicates whether the object is the default lead source; i.e., 0=no, 1=yes. Used for auto-generated opportunities, which must be related to a lead_source	Search (2)
location	CHAR	varchar		50			Location of the lead source	Search (3)
name	CHAR	varchar	2	80			Name of the lead source	Search (8)
objid	LONG	int	3			DIRECT	Internal record number	Search (11)
phone	CHAR	varchar		20			Phone number of the lead source	Search (3)
start_date	CLK_TIME	datetime					The date the lead source became active	Search (5)
status	CHAR	varchar		40			Status of the lead source. This is a user-defined pop up with default name Lead Source Status	Search (6)
type	CHAR	varchar		40			Type of source; e.g., seminar, trade show, etc. This is a user-defined pop up with default name Lead Source Type	Search (6)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
source2bus_lsc_role	OTM	bus_lsc_role	bus_lsc2lead_source	Account roles for the lead source
source2campaign	MTO	campaign	campaign2lead_source	Campaign associated with the source			Search (4)
source2con_lsc_role	OTM	con_lsc_role	con_lsc2lead_source	Contact roles for the lead source
source2interact	OTM	interact	interact2lead_source	Interactions about the lead source
source2lead	OTM	lead	lead2lead_source	Leads generated by the lead source
source2opportunity	OTM	opportunity	opp2lead_source	Related opportunities
source2per_sce_role	OTM	per_sce_role	per_role2lead_source	Roles for the lead source
source2scr_run	OTM	scr_run	scr_run2lead_source	Call scripts run from the lead source

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
leadsrce_ind	id	UNIQUE
leadsrce_name	source2campaign:name	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_start_date	start_date, end_date	nonclustered located on PRIMARY
leadsrce_ind	id	nonclustered, unique located on PRIMARY
leadsrce_name	source2campaign, name	nonclustered, unique located on PRIMARY
loc5017	location	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5071	cmp_lsc_opp	campaign, gbst_lst, lead_source, opportunity, user
5072	opp_stage	gbst_lst, lead_source, opportunity, user
5075	cmp_lsc	campaign, lead_source
5217	ccc_rundsply	bug, bus_org, campaign, case, contact, contr_itm, contract, demand_dtl, employee, lead_source, opportunity, probdesc, scr_run, site, site_part, subcase, task
5322	bus_lsc_view	bus_lsc_role, bus_org, lead_source
5323	con_lsc_view	con_lsc_role, contact, lead_source
5324	lead_view	lead, lead_source, user
5346	sfa_leadsrc	campaign, lead_source
5357	sfa_opp_mto_v	currency, cycle_stage, lead_source, life_cycle, opportunity, territory
5503	campaign_lead_source	campaign, lead_source
5742	opp_summary_v	currency, cycle_stage, lead_source, life_cycle, opportunity, territory

My Recent Objects

lead_source

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user