Model: CRM - Specifications for Dimension Table: SALES QUOTATION LINE

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.

Attributes

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.

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
SALES QUOTATION LINE FACT_SALES_QUOTATION_LINE_BI FACT_SALES_QUOTATION_LINE On Line