Model: CRM - Specifications for Dimension Table: CUSTOMER ORDER LINE

On this page you will find the specifications regarding the Model: CRM and Dimension Table: CUSTOMER ORDER LINE.

Attributes

Attribute Description (where applicable)
Invoice Blocked Indicates if an order line is invoice blocked. This means that the order line cannot be invoiced.
Tax Code Tax code
PriceList No The price list from which the prices are fetched for the order line.
Price Source The origin of the part's price on the order line.
Rental Indicates whether the order line is a rental line.
Ship Days Off Time Interval Interval describing the number of deviation days an
Ship Days Late Interval Interval describing the number of days an order line
Ship Days Early Interval Interval describing the number of days an order line
Demand Code This column shows from where the customer order was created.
Line Status The status of the customer order line.
Supply Code 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
CUSTOMER ORDER LINE FACT_CUSTOMER_ORDER_LINE_PQ_BI FACT_CUSTOMER_ORDER_LINE_PQ On Line