On this page you will find the specifications regarding the Model: Inventory and Dimension Table: INVENTORY VALUE.
This model dimension represents inventory value and is based on the IFS Cloud fact view FACT_INVENTORY_VALUE. All models that refers to this dimension will have the attributes and hierarchies as described below.
| Attribute | Description (where applicable) |
| BASE_CURRENCY_CODE | |
| COMPANY | |
| CONDITION_CODE | |
| CONDITION_CODE_KEY | |
| CONFIGURATION_ID | |
| CONFIGURATION_ID_KEY | |
| CONTRACT | |
| CONTRACT_KEY | |
| ID | Key. Built as CONTRACT_KEY+'-'+STAT_YEAR_NO_KEY+'-'+STAT_PERIOD_NO_KEY+'-'+PART_NO_KEY+'-'+CONFIGURATION_ID_KEY+'-'+LOT_BATCH_NO_KEY+'-'+SERIAL_NO_KEY+'-'+CONDITION_CODE_KEY. |
| INVENTORY_PART | |
| IV_DATE_CREATED | |
| LOCATION_GROUP | |
| LOCATION_GROUP_KEY | |
| LOT_BATCH_NO | A lot or batch is a quantity of parts produced together that shares the same production specifications and costs. |
| LOT_BATCH_NO_KEY | |
| MVT_CREATED_DT | |
| PART_NO | |
| PART_NO_KEY | |
| PLANNER_BUYER_NEW | |
| QTY_WAIV_DEV_REJ | |
| REPORTING_DATE | |
| REP_CURR_CODE | |
| REP_CURR_RATE | |
| REP_CURR_TOTAL_VALUE | |
| REP_CURR_UNIT_COST | The unit cost for a reporting currency. |
| SERIAL_NO | The serial number of the part if there is one. |
| SERIAL_NO_KEY | |
| SITE | |
| STAT_PERIOD_NO | Identifies statistic month of year. |
| STAT_PERIOD_NO_KEY | |
| STAT_YEAR_NO | The statistic year number. |
| STAT_YEAR_NO_KEY |
| 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 VALUE | FACT_INVENTORY_VALUE_TM | FACT_INVENTORY_VALUE_BI | FACT_INVENTORY_VALUE | Data Mart |