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. |
| PARTITION_BY_DATE | Partition Column to partition the data by date for incremental loading |
| PARTITION_BY_MONTH | Partition Column to partition the data by month for incremental loading |
| ROWVERSION | Column to be used as the "Detect Changes" column for incremental loading |
| 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 |