On this page you will find the specifications regarding the Model: Inventory and Dimension Table: INVENTORY TRANSACTION HISTORY.
This model dimension represents inventory transaction history and is based on the IFS Cloud fact view FACT_INVENT_TRANS_HIST. All models that refers to this dimension will have the attributes and hierarchies as described below.
| Attribute | Description (where applicable) |
| ACTIVITY | |
| BASE_CURRENCY_CODE | |
| COMPANY | |
| CONDITION_CODE | |
| COST | |
| Cost_Direction | |
| Cost_Goods_Issued | |
| DIRECTION | The direction of the transaction. It describes whether the quantity in stock is decreased (-), increased (+), or unaffected (0) by the transaction. |
| ENG_CHG_LEVEL | |
| ID | |
| INVENTORY_LOCATION | |
| INVENTORY_PART | |
| ITH_DATE_APPLIED | |
| ITH_DATE_CREATED | |
| ITH_EXPIRATION_DATE | |
| LINE_ITEM_NO | |
| LOT_BATCH_NO | A lot or batch is a quantity of parts produced together that shares the same production specifications and costs. |
| MPCCOM_TRANSACTION_CODE | |
| MVT_CREATED_DT | |
| ORDER_NO | Depending on the type of order, a reference to the origin is displayed. The order number is displayed for shop orders, work orders, customer orders, purchase orders, and material requisitions. |
| ORDER_TYPE | The type of order from which the transaction originated, e.g., a purchase order or shop order. |
| ORDER_TYPE_DESC | |
| PLANNER_BUYER_NEW | |
| PROJECT | |
| QUANTITY | |
| Quantity_Direction | |
| RELEASE_NO | |
| REPORTING_DATE | |
| REP_CURR_CODE | |
| REP_CURR_INVENTORY_COST | |
| REP_CURR_RATE | |
| REP_CURR_SUM_UNIT_COST | |
| REP_CURR_TOTAL_COST | |
| RETURN_CAUSE | |
| SCRAPPING_CAUSE | |
| SEQUENCE_NO | |
| SERIAL_NO | |
| SITE | |
| SOURCE | Identifies the source for the transaction |
| SOURCE_REF1 | |
| SOURCE_REF2 | |
| SOURCE_REF3 | |
| SOURCE_REF4 | |
| SOURCE_REF5 | |
| SOURCE_REF_TYPE | |
| SOURCE_REF_TYPE_DESC | |
| STAT_PERIOD | |
| STAT_YEAR | |
| TRANSACTION_ID | |
| TRANSACTION_ID_KEY | |
| USERID | |
| WAIV_DEV_REJ_NO |
| 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 TRANSACTION HISTORY | FACT_INVENT_TRANS_HIST_TM | FACT_INVENT_TRANS_HIST_BI | FACT_INVENT_TRANS_HIST | Data Mart |