Cube Dimension - Customer Order Line

This cube only dimension represents customer order lines and it is based on the fact FACT_CUSTOMER_ORDER_LINE in IFS applications. There is no associated dimension in IFS Applications. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Agreement No NO If Price Source = AGREEMENT, PRICE_SOURCE_ID is displayed
Campaign ID NO If Price Source = CAMPAIGN, PRICE_SOURCE_ID is displayed
Currency Code NO The currency code for currency based amounts
Customer Order Line NO Key. Defined as ORDER_NO_KEY + ' - ' + LINE_NO_KEY + ' - ' + REL_NO_KEY + ' - ' + ' - ' + LINE_ITEM_NO_KEY
Demand Code NO Defined as the description (client value) of demand code (DEMAND_CODE_DESC)
Invoice Blocked NO Defined as the description of invoice blocked attribute (INVOICE_BLOCKED_DESC)
Line Status NO State (db value) of the customer order line (STATE)
Pay Tax NO Defined as the description of pay tax (PAY_TAX_DESC)
Ship Days Early Interval NO Interval describing the number of days an order line was shipped too early compared to planned ship date (SHIP_DAYS_EARLY)
Ship Days Late Interval NO Interval describing the number of days an order line was shipped too late compared to planned ship date (SHIP_DAYS_LATE)
Ship Days Off Time Interval NO Interval describing the number of deviation days an order line was shipped compared to planned ship date (SHIP_DAYS_OFF_TIME)
Supply Code NO Defined as the description of the supply code (SUPPLY_CODE_DESC)
Tax Code NO Defined as the description of the vat (tax) code (FEE_CODE_DESC)

USED BY CUBE

Cube Name
SALES

ETL Information

BI Access View BI Component Recommended
Source Type
FACT_CUSTOMER_ORDER_LINE_BI ORDEFT On Line

Please refer to FACT_CUSTOMER_ORDER_LINE