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.
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) |
Cube Name |
SALES |
BI Access View | BI Component | Recommended Source Type |
FACT_CUSTOMER_ORDER_LINE_BI | ORDEFT | On Line |
Please refer to FACT_CUSTOMER_ORDER_LINE