On this page you will find the specifications regarding the Model: CRM and Dimension Table: BUSINESS OPP LINE.
This model dimension represents the business opportunity lines and is based on the IFS Cloud dimension FACT_BUSINESS_OPP_LINE. All models that refers to this dimension will have the attributes and hierarchies as described below.
| Attribute | Description (where applicable) |
| Catalog Number | The sales part number. |
| Configurable | Indicates if the part is configurable. |
| Configurable Status | The status of the configuration created for the part. |
| Contract | Site |
| Contribution Object Reference 1 | A reference to another object which was created by the opportunity line. |
| Contribution Object Reference 2 | A reference to another object which was created by the opportunity line. |
| Contribution Object Reference 3 | A reference to another object which was created by the opportunity line. |
| Contribution Object Reference 4 | A reference to another object which was created by the opportunity line. |
| Contribution Object Type | The type of object referenced to the opportunity line. |
| Customer Part Number | The part number used by the customer for the opportunity line part. |
| Customer Part Unit Of Measure | The UoM used by the customer for the opportunity line part. |
| Description | The description of the opportunity line part. |
| Line Item | The opportunity line item |
| Line Number | The opportunity line number |
| Non Existing Part | An opportunity line part which has not been registered as a sales part. |
| Oppurtunity Number | The identity number of the business opportunity. |
| Original Part Number | Opportunity part number |
| Price Source | The origin of the part's price on the opportunity line. |
| Reason Note | A note which was added when the opportunity line was closed. |
| Revision Number | The opportunity line revision number. |
| Revision State | The opportunity revision state. The state can be won, lost or partially won. |
| Revision State Description | The opportunity revision state description |
| Revision Status | The status of the opportunity line revison. |
| Sales Part Type | Indicates if the opportunity line part is an inventory part or a non-inventory part. |
| Sales Unit Measure | UoM used for the opportunity line part. |
| State | The status of the oportunity line. |
| Model Name |
| CRM |
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 OPP LINE | FACT_BUSINESS_OPP_LINE_TM | FACT_BUSINESS_OPP_LINE_BI | FACT_BUSINESS_OPP_LINE | Data Mart |