Model: CRM - Specifications for Dimension Table: BUSINESS LEAD FACT

On this page you will find the specifications regarding the Model: CRM and Dimension Table: BUSINESS LEAD FACT.

Attributes

Attribute	Description (where applicable)
Annual Revenue	Annual revenue of the lead.
Association No.	The customer's association number.
Business Lead Company	The name of the lead company.
Business Lead Creation Date	The date that the lead is created.
Business Lead Description	The description of the lead.
Business Lead ID	Not Needed
Business Lead Probability	The probability level set for the lead.
Business Lead Status	The status of the lead.
Country	Not Needed
Country ID	Country of the lead company.
Currency	Currency related to the lead.
Default Language ID	Language related to the lead.
Forms of Business	The form of business of the lead or the relavent account.
Forms of Business ID	The form of business of the lead or the relavent account.
Is from Existing Account	Whether the lead is created related to an existing account or not.
Market ID	Market of the lead company.

USED BY MODEL(S)

Model Name

CRM

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
BUSINESS LEAD FACT	FACT_BUSINESS_LEAD_TM	FACT_BUSINESS_LEAD_BI	FACT_BUSINESS_LEAD	Data Mart