This cube only dimension represents customer order charges and it is based on the fact FACT_CUSTOMER_ORDER_CHARGE 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 |
Customer Order Charge | NO | Key. Defined as ORDER_NO_KEY + ' - ' + SEQUENCE_NO_KEY represented by the ETL column CUSTOMER_ORDER_CHARGE. |
Customer Order No | NO | Customer order number (ORDER_NO_KEY) |
Customer Order Seq No | NO | Customer order sequence number (SEQUENCE_NO_KEY) |
Customer Order State | NO | The state of the customer order charge (db value represented by STATE) |
Customer Order State Descr | NO | The state description (client value represented by STATE_DESC) |
Cube Name |
SALES |
BI Access View | BI Component | Recommended Source Type |
FACT_CUSTOMER_ORDER_CHARGE_BI | ORDEFT | On Line |
Please refer to FACT_CUSTOMER_ORDER_CHARGE