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 TypeIndicates if the opportunity is regarding new or recurring sales.
Lost ToIf the opportunity was lost, this is the competitor who won the deal.
Not Quoted Opportunity Value/BaseThe opportunity value that is not quoted, expressed in the company currency.
Not Quoted Opportunity Value/CurrThe opportunity value that is not quoted, expressed in the opportunity currency.
Opportunity Closed StatusIndicates if the opportunity was won or lost.
Opportunity DescriptionThe description of the business opportunity.
Opportunity Estimated ValueThe total estimated value of the opportunity which is entered when creating the opportunity.
Opportunity Estimated Value/BaseThe total estimated value of the opportunity which is entered when creating the opportunity, expressed in the company currency.
Opportunity NoThe identification number of the business opportunity.
Opportunity Revision NoteThe note entered when creating a new revision of the business opportunity.
Opportunity SourceThe origin of the opportunity.
Opportunity StatusThe status of the Business Opportunity.
Opportunity Total Cost ValueThe total cost of the revision in the company's base currency.
Opportunity Total Value/BaseThe total opportunity value, expressed in the company's currency.
Opportunity Total Value/CurrThe total opportunity value, expressed in the opportunity currency.
Opportunity TypeSpecifies the nature of the opportunity.
Opportunity Type DescriptionSpecifies the nature of the opportunity.
Quoted Opportunity Value/BaseThis is the total value of all sales quotation lines which are created from the specified opportunity, expressed in the company currency.
Quoted Opportunity Value/CurrThis is the total value of all sales quotation lines which are created from the specified opportunity, expressed in the opportunity currency.
Reference Type IDThe type of reference that was created by the opportunity.
Won Opportunity Value/BaseThis is the total value of all customer order lines created from this opportunity, expressed in the company currency.
Won Opportunity Value/CurrThis 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