This cube dimension represents inventory transaction history and is based on the IFS Applications fact view FACT_INVENT_TRANS_HIST. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
| Attribute | Hierarchy | Description |
| Configuration ID | NO | This number is automatically assigned to identify a specific part configuration specification which is a unique combination of characteristics and options that is used in conjunction with a Configurable part. |
| Direction | NO | The direction of the transaction. It describes whether the quantity in stock is decreased (-), increased (+), or unaffected (0) by the transaction. |
| Inventory Transaction History ID | NO | Key. Displays the identification number of the inventory transaction. |
| Last Loaded | NO | Identifies the last time the fact table was loaded. |
| Lot Batch No | NO | A lot or batch is a quantity of parts produced together that shares the same production specifications and costs. |
| Order No | 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 | NO | The type of order from which the transaction originated, e.g., a purchase order or shop order. |
| Performed By | NO | The user ID of the person who performed the transaction. |
| Source | NO | Identifies the source for the transaction |
| Waiv Dev Rej No | NO | This is the quantity with a deviating W/D/R Number. |
| StatPeriodHy | YES | Hierarchy defined as "Stat Year No" -> "Stat Period No" |
| Cube Name |
| INVENTORY |
| BI Access View | BI Component | Recommended Source Type |
| FACT_INVENT_TRANS_HIST_BI | INVEFT | On Line |
Please refer to FACT_INVENTORY_TRANS_HIST