FACT -  PURCHASE ORDER CHARGE

This cube fact represents purchase order charge information and is based on the IFS Applications fact FACT_PURCHASE_ORDER_CHARGE.

Note: Please refer to documentation of each cube to find out about attributes used in referenced cubes.

USED BY CUBE

Cube Name Product Area
Procurement Supply Chain

ETL Information

BI Access View BI Component Recommended
Source Type
FACT_PURCHASE_ORDER_CHARGE_BI PURCFT On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.2.021 Load IFSAppl_FACT_PURCHASE_ORDER_CHARGE_BI.dtsx IFSAppl_FACT_PURCHASE_ORDER_CHARGE_BI
T - DW 2.2.021 Load Dw_FACT_PURCHASE_ORDER_CHARGE.dtsx Dw_FACT_PURCHASE_ORDER_CHARGE
L - DM 3.2.021 Load Dm_FACT_PURCHASE_ORDER_CHARGE.dtsx Dm_FACT_PURCHASE_ORDER_CHARGE

SPECIAL INFO

This fact supports Reporting Date, i.e. a time dimension that can be used to when doing cross product/module reporting. The date chosen to connect the fact with the dimension is NVL(LATEST_ARRIVAL_DATE, DATE_ENTERED), i.e. if LATEST_ARRIVAL_DATE is NULL the DATE_ENTERED is selected. This date is also used when finding the currency rate for calculation of reporting currency amounts.