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