On this page you will find the specifications regarding the Model: CRM and Dimension Table: BUSINESS OPPORTUNITY.
Attribute | Description (where applicable) |
Reference Type ID | The type of reference that was created by the opportunity. |
Opportunity Description | The description of the business opportunity. |
Opportunity Type | Specifies the nature of the opportunity. |
Opportunity Revision Note | The note entered when creating a new revision of the business opportunity. |
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. |
Opportunity Status | The status of the Business Opportunity. |
Opportunity Estimated Value/Base | The total estimated value of the opportunity which is entered when creating the opportunity, expressed in the company currency. |
Not Quoted Opportunity Value/Base | The opportunity value that is not quoted, expressed in the company currency. |
Opportunity Total Cost Value | The total cost of the revision in the company's base currency. |
Business Type | Indicates if the opportunity is regarding new or recurring sales. |
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. |
Opportunity Source | The origin of 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. |
Opportunity Closed Status | Indicates if the opportunity was won or lost. |
Opportunity Type Description | Specifies the nature of the opportunity. |
Not Quoted Opportunity Value/Curr | The opportunity value that is not quoted, expressed in the opportunity currency. |
Opportunity Estimated Value | The total estimated value of the opportunity which is entered when creating the opportunity. |
Opportunity No | The identification number of the business opportunity. |
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. |
Lost To | If the opportunity was lost, this is the competitor who won the deal. |
Won Opportunity Value/Curr | This is the total value of all customer order lines created from this opportunity, expressed in the opportunity currency. |
Model Name |
CRM |
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 OPPORTUNITY | FACT_BUSINESS_OPP_BI | FACT_BUSINESS_OPP | On Line |