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) |
IT_DATE_CREATED | |
REPORTING_DATE | |
STAT_PERIOD_NO | Identifies statistic month of year. |
STAT_YEAR_NO | The statistic year number. |
BEG_BALANCE | |
SITE | |
INVENTORY_PART | |
BASE_CURRENCY_CODE | |
REP_CURR_CODE | |
COMPANY | |
PLANNER_BUYER_NEW | |
SECOND_COMMODITY | |
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. |
REP_CURR_INVENTORY_VALUE | |
REP_CURR_BEG_INVENTORY_BALANCE | |
REP_CURR_ISSUED_VALUE | |
REP_CURR_ISSUED_ABNORMAL_VALUE |
Model Name |
Inventory |
The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.
Additional information can be found in the online documentation of Information Sources.
Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
INVENTORY TURNOVER | FACT_INVENTORY_TURNOVER_BI | FACT_INVENTORY_TURNOVER_PQ | On Line |