This cube fact represents return material charges in Customer Order and is based on the IFS Applcations fact FACT_RETURN_MATERIAL_CHARGE
Note: Please refer to documentation of each cube to find out about attributes used in referenced cubes.
Cube Name | Product Area |
Sales | Supply Chain |
BI Access View | BI Component | Recommended Source Type |
FACT_RETURN_MATERIAL_CHARGE_BI | ORDEFT | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.2.004 Load IFSAppl_FACT_RETURN_MATERIAL_CHARGE_BI.dtsx | IFSAppl_FACT_RETURN_MATERIAL_CHARGE_BI |
T - DW | 2.2.004 Load Dw_FACT_RETURN_MATERIAL_CHARGE.dtsx | Dw_FACT_RETURN_MATERIAL_CHARGE |
L - DM | 3.2.004 Load Dm_FACT_RETURN_MATERIAL_CHARGE.dtsx | Dm_FACT_RETURN_MATERIAL_CHARGE |
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 the reporting date represented by Date Returned from Return Material Line if not null, else Date Entered from Return Material Charge is used. This date is also used when finding the currency rate for calculation of reporting currency amounts.