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 RevenueAnnual revenue of the lead.
Association No.The customer's association number.
Business Lead CompanyThe name of the lead company.
Business Lead Creation DateThe date that the lead is created.
Business Lead DescriptionThe description of the lead.
Business Lead IDNot Needed
Business Lead ProbabilityThe probability level set for the lead.
Business Lead StatusThe status of the lead.
CountryNot Needed
Country IDCountry of the lead company.
CurrencyCurrency related to the lead.
Default Language IDLanguage related to the lead.
Forms of BusinessThe form of business of the lead or the relavent account.
Forms of Business IDThe form of business of the lead or the relavent account.
Is from Existing AccountWhether the lead is created related to an existing account or not.
Market IDMarket 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 FACTFACT_BUSINESS_LEAD_TMFACT_BUSINESS_LEAD_BIFACT_BUSINESS_LEADData Mart