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 WinThe estimated probability to win the deal.
Quotation NumberThe identity number of the sales quotation.
State DescriptionThe status of the quotation line.
Line Item NumberLine item number connected to sales quotation
Supply CodeThe supply code specifies how a part should be supplied.
Conversion FactorThe conversion factor between the sales unit of measure (UoM) and inventory UoM.
Group DiscountThe discount percentage applicable to the sales part's discount group. 
Lost ToIf the quotation line was lost, this is the competitor who won the deal.
Additional DiscountAn additional discount (%) which is added to the sales quotation and lines.
Charged Item DescriptionA sales quotation line which should be invoiced.
Line NumberThe identity number of the sales quotation line.
Sales Part Type DescriptionIndicates if the quotation line part is an inventory part or a non-inventory part.
Sales Unite MeasureThe sales unit of measure in which the part is sold, e.g., piece, meter, or kilo.
Price List NumberThe price list from which the prices are fetched for the quotation line.
Currency RateThe currency rate used conversion between curr amount and amount.
Demance Code Description-
Charged ItemA sales quotation line which should be invoiced.
Price Conversion FactorThe conversion factor used to convert the sales quantity expressed in sales unit of measure (UoM) to the quantity expressed in price UoM.
RentalIndicates whether the order line is a rental line.
Demance Code-
Tax Code DescriptionTax code
StateThe status of the quotation line.
DiscountThe line discount percentage.
Rental DescriptionDescription of the rental line
Tax CodeTax code
Sale Unit PriceThe unit price.
Sales Part TypeIndicates if the quotation line part is an inventory part or a non-inventory part.
Supply Code DescriptionThe 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 LINEFACT_SALES_QUOTATION_LINE_BIFACT_SALES_QUOTATION_LINEOn Line