Model: Inventory - Specifications for Dimension Table: INVENTORY TURNOVER

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.

Attributes

Attribute Description (where applicable)
BASE_CURRENCY_CODE
BEG_BALANCE
COMPANY
CONFIGURATION_IDThis 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_NOIdentifies statistic month of year.
STAT_YEAR_NOThe statistic year number.

USED BY MODEL(S)

Model Name
Inventory

Data source Information

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 TURNOVERFACT_INVENTORY_TURNOVER_TMFACT_INVENTORY_TURNOVER_BIFACT_INVENTORY_TURNOVERData Mart