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) |
| 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. |
| CONTRACT_KEY | |
| CONFIGURATION_ID_KEY | |
| LOT_BATCH_NO_KEY | |
| CONDITION_CODE_KEY | |
| LOCATION_GROUP_KEY | |
| CONTRACT | |
| PART_NO | |
| CONFIGURATION_ID | |
| LOT_BATCH_NO | A lot or batch is a quantity of parts produced together that shares the same production specifications and costs. |
| LOCATION_GROUP | |
| COMPANY | |
| INVENTORY_PART | |
| CONDITION_CODE | |
| IV_DATE_CREATED | |
| BASE_CURRENCY_CODE | |
| STAT_YEAR_NO_KEY | |
| STAT_PERIOD_NO_KEY | |
| PART_NO_KEY | |
| SERIAL_NO_KEY | |
| QTY_WAIV_DEV_REJ | |
| SERIAL_NO | The serial number of the part if there is one. |
| STAT_PERIOD_NO | Identifies statistic month of year. |
| REPORTING_DATE | |
| PLANNER_BUYER_NEW | |
| REP_CURR_RATE | |
| SITE | |
| STAT_YEAR_NO | The statistic year number. |
| REP_CURR_CODE | |
| REP_CURR_TOTAL_VALUE | |
| REP_CURR_UNIT_COST | The unit cost for a reporting currency. |
| 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 VALUE | FACT_INVENTORY_VALUE_BI | FACT_INVENTORY_VALUE_PQ | On Line |