Cube Dimension - Customer Order Charge

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.

ATTRIBUTES

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)

USED BY CUBE

Cube Name
SALES

ETL Information

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

Please refer to FACT_CUSTOMER_ORDER_CHARGE