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 BlockedIndicates if an order line is invoice blocked. This means that the order line cannot be invoiced.
Tax CodeTax code
PriceList NoThe price list from which the prices are fetched for the order line.
Price SourceThe origin of the part's price on the order line.
RentalIndicates whether the order line is a rental line.
Ship Days Off Time IntervalInterval describing the number of deviation days an
Ship Days Late IntervalInterval describing the number of days an order line
Ship Days Early IntervalInterval describing the number of days an order line
Demand CodeThis column shows from where the customer order was created.
Line StatusThe status of the customer order line.
Supply CodeThe 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 LINEFACT_CUSTOMER_ORDER_LINE_PQ_BIFACT_CUSTOMER_ORDER_LINE_PQOn Line