On this page you will find the specifications regarding the Model: CRM and Dimension Table: SALES QUOTATION LINE.
This model fact represents information about sales quotations which is a pre-step of customer orders and is based on the IFS Cloud dimension FACT_SALES_QUOTATION_LINE. All models that refers to this fact will have the attributes and hierarchies as described below.
| Attribute | Description (where applicable) |
| Additional Discount | An additional discount (%) which is added to the sales quotation and lines. |
| Charged Item | A sales quotation line which should be invoiced. |
| Charged Item Description | A sales quotation line which should be invoiced. |
| Conversion Factor | The conversion factor between the sales unit of measure (UoM) and inventory UoM. |
| Currency Rate | The currency rate used conversion between curr amount and amount. |
| Demance Code | Not Required |
| Demance Code Description | Not Required |
| Discount | The line discount percentage. |
| Group Discount | The discount percentage applicable to the sales part's discount group. |
| Line Item Number | Line item number connected to sales quotation |
| Line Number | The identity number of the sales quotation line. |
| Lost To | If the quotation line was lost, this is the competitor who won the deal. |
| Price Conversion Factor | The conversion factor used to convert the sales quantity expressed in sales unit of measure (UoM) to the quantity expressed in price UoM. |
| Price List Number | The price list from which the prices are fetched for the quotation line. |
| Probability To Win | The estimated probability to win the deal. |
| Quotation Number | The identity number of the sales quotation. |
| Rental | Indicates whether the order line is a rental line. |
| Rental Description | Description of the rental line |
| Sale Unit Price | The unit price. |
| Sales Part Type | Indicates if the quotation line part is an inventory part or a non-inventory part. |
| Sales Part Type Description | Indicates if the quotation line part is an inventory part or a non-inventory part. |
| Sales Unite Measure | The sales unit of measure in which the part is sold, e.g., piece, meter, or kilo. |
| State | The status of the quotation line. |
| State Description | The status of the quotation line. |
| Supply Code | The supply code specifies how a part should be supplied. |
| Supply Code Description | The supply code specifies how a part should be supplied. |
| Tax Code | Tax code |
| Tax Code Description | Tax code |
| 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 |
| SALES QUOTATION LINE | FACT_SALES_QUOTATION_LINE_TM | FACT_SALES_QUOTATION_LINE_BI | FACT_SALES_QUOTATION_LINE | Data Mart |