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) |
| COMPANY | |
| CONDITION_CODE | |
| Quantity_Direction | |
| COST | |
| ACTIVITY | |
| BASE_CURRENCY_CODE | |
| ID | |
| TRANSACTION_ID_KEY | |
| QUANTITY | |
| TRANSACTION_ID | |
| LOT_BATCH_NO | A lot or batch is a quantity of parts produced together that shares the same production specifications and costs. |
| SERIAL_NO | |
| WAIV_DEV_REJ_NO | This is the quantity with a deviating W/D/R Number. |
| ENG_CHG_LEVEL | |
| 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. |
| RELEASE_NO | |
| SEQUENCE_NO | |
| LINE_ITEM_NO | |
| ORDER_TYPE | The type of order from which the transaction originated, e.g., a purchase order or shop order. |
| ORDER_TYPE_DESC | |
| SOURCE_REF1 | |
| SOURCE_REF2 | |
| SOURCE_REF3 | |
| SOURCE_REF4 | |
| SOURCE_REF5 | |
| INVENTORY_PART | |
| PROJECT | |
| INVENTORY_LOCATION | |
| SITE | |
| REPORTING_DATE | |
| SOURCE_REF_TYPE_DESC | |
| REP_CURR_RATE | |
| MPCCOM_TRANSACTION_CODE | |
| STAT_PERIOD | |
| REP_CURR_CODE | |
| PLANNER_BUYER_NEW | |
| SCRAPPING_CAUSE | |
| ITH_DATE_CREATED | |
| ITH_DATE_APPLIED | |
| DIRECTION | The direction of the transaction. It describes whether the quantity in stock is decreased (-), increased (+), or unaffected (0) by the transaction. |
| SOURCE_REF_TYPE | |
| USERID | |
| STAT_YEAR | |
| RETURN_CAUSE | |
| ITH_EXPIRATION_DATE | |
| SOURCE | Identifies the source for the transaction |
| Cost_Direction | |
| Cost_Goods_Issued | |
| REP_CURR_INVENTORY_COST | |
| REP_CURR_SUM_UNIT_COST | |
| REP_CURR_TOTAL_COST |
| 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 TRANSACTION HISTORY | FACT_INVENT_TRANS_HIST_BI | FACT_INVENT_TRANS_HIST_PQ | On Line |