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) |
Probability To Win | The estimated probability to win the deal. |
Quotation Number | The identity number of the sales quotation. |
State Description | The status of the quotation line. |
Line Item Number | Line item number connected to sales quotation |
Supply Code | The supply code specifies how a part should be supplied. |
Conversion Factor | The conversion factor between the sales unit of measure (UoM) and inventory UoM. |
Group Discount | The discount percentage applicable to the sales part's discount group. |
Lost To | If the quotation line was lost, this is the competitor who won the deal. |
Additional Discount | An additional discount (%) which is added to the sales quotation and lines. |
Charged Item Description | A sales quotation line which should be invoiced. |
Line Number | The identity number of the sales quotation line. |
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. |
Price List Number | The price list from which the prices are fetched for the quotation line. |
Currency Rate | The currency rate used conversion between curr amount and amount. |
Demance Code Description | - |
Charged Item | A sales quotation line which should be invoiced. |
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. |
Rental | Indicates whether the order line is a rental line. |
Demance Code | - |
Tax Code Description | Tax code |
State | The status of the quotation line. |
Discount | The line discount percentage. |
Rental Description | Description of the rental line |
Tax Code | Tax code |
Sale Unit Price | The unit price. |
Sales Part Type | Indicates if the quotation line part is an inventory part or a non-inventory part. |
Supply Code Description | The supply code specifies how a part should be supplied. |
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 |
SALES QUOTATION LINE | FACT_SALES_QUOTATION_LINE_BI | FACT_SALES_QUOTATION_LINE | On Line |