On this page you will find the specifications regarding the Model: Inventory and Dimension Table: INVENTORY TURNOVER.
This model dimension represents inventory turnover and is based on the IFS Cloud fact view FACT_INVENTORY_TURNOVER. All models that refers to this dimension will have the attributes and hierarchies as described below.
Attribute | Description (where applicable) |
BASE_CURRENCY_CODE | |
BEG_BALANCE | |
COMPANY | |
CONFIGURATION_ID | This number is automatically assigned to identify a specific part configuration specification which is a unique combination of characteristics and options that is used in conjunction with a Configurable part. |
INVENTORY_PART | |
IT_DATE_CREATED | |
MVT_CREATED_DT | |
PLANNER_BUYER_NEW | |
REPORTING_DATE | |
REP_CURR_BEG_INVENTORY_BALANCE | |
REP_CURR_CODE | |
REP_CURR_INVENTORY_VALUE | |
REP_CURR_ISSUED_ABNORMAL_VALUE | |
REP_CURR_ISSUED_VALUE | |
SECOND_COMMODITY | |
SITE | |
STAT_PERIOD_NO | Identifies statistic month of year. |
STAT_YEAR_NO | The statistic year number. |
Model Name |
Inventory |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
INVENTORY TURNOVER | FACT_INVENTORY_TURNOVER_TM | FACT_INVENTORY_TURNOVER_BI | FACT_INVENTORY_TURNOVER | Data Mart |