Model: CRM - Specifications for Dimension Table: BUSINESS OPPORTUNITY

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

Attributes

Attribute	Description (where applicable)
Business Type	Indicates if the opportunity is regarding new or recurring sales.
Lost To	If the opportunity was lost, this is the competitor who won the deal.
Not Quoted Opportunity Value/Base	The opportunity value that is not quoted, expressed in the company currency.
Not Quoted Opportunity Value/Curr	The opportunity value that is not quoted, expressed in the opportunity currency.
Opportunity Closed Status	Indicates if the opportunity was won or lost.
Opportunity Description	The description of the business opportunity.
Opportunity Estimated Value	The total estimated value of the opportunity which is entered when creating the opportunity.
Opportunity Estimated Value/Base	The total estimated value of the opportunity which is entered when creating the opportunity, expressed in the company currency.
Opportunity No	The identification number of the business opportunity.
Opportunity Revision Note	The note entered when creating a new revision of the business opportunity.
Opportunity Source	The origin of the opportunity.
Opportunity Status	The status of the Business Opportunity.
Opportunity Total Cost Value	The total cost of the revision in the company's base currency.
Opportunity Total Value/Base	The total opportunity value, expressed in the company's currency.
Opportunity Total Value/Curr	The total opportunity value, expressed in the opportunity currency.
Opportunity Type	Specifies the nature of the opportunity.
Opportunity Type Description	Specifies the nature of the opportunity.
Quoted Opportunity Value/Base	This is the total value of all sales quotation lines which are created from the specified opportunity, expressed in the company currency.
Quoted Opportunity Value/Curr	This is the total value of all sales quotation lines which are created from the specified opportunity, expressed in the opportunity currency.
Reference Type ID	The type of reference that was created by the opportunity.
Won Opportunity Value/Base	This is the total value of all customer order lines created from this opportunity, expressed in the company currency.
Won Opportunity Value/Curr	This is the total value of all customer order lines created from this opportunity, expressed in the opportunity currency.

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 OPPORTUNITY