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

Additional information can be found in the online documentation of Information Sources.

Model Table BI Access View Referenced Information Source Recommended Access Type
BUSINESS OPPORTUNITYFACT_BUSINESS_OPP_BIFACT_BUSINESS_OPPOn Line