This cube fact represents customer invoices in Financials and is based on the IFS Applications fact FACT_CUSTOMER_INVOICE
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_CUSTOMER_INVOICE_BI | INVOFT | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.2.005 Load IFSAppl_FACT_CUSTOMER_INVOICE_BI.dtsx | IFSAppl_FACT_CUSTOMER_INVOICE_BI |
T - DW | 2.2.005 Load Dw_FACT_CUSTOMER_INVOICE.dtsx | Dw_FACT_CUSTOMER_INVOICE |
L - DM | 3.2.005 Load Dm_FACT_CUSTOMER_INVOICE.dtsx | Dm_FACT_CUSTOMER_INVOICE |
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 invoice date. This date is also used when finding the currency rate for calculation of reporting currency amounts.