On this page you will find the specifications regarding the Model: Inventory and Dimension Table: MPCCOM TRANSACTION CODE.
This model dimension represents MPCCOM Transaction Code and is based on the IFS Applications dimension DIM_MPCCOM_TRANSACTION_CODE. All models that refers to this dimension will have the attributes described below.
| Attribute | Description (where applicable) |
| MPCCOM Transaction | Built as CODE +'-'+ DESCRIPTION |
| MPCCOM Transaction Code | The CODE of the dimensions, i.e. the MPCCOM Transaction identity |
| MPCCOM Transaction Direction | The direction of the transaction. It describes whether the quantity in stock is decreased (-), increased (+), or unaffected (0) by the transaction. |
| MPCCOM Transaction Source | Represents the source for the transaction |
| MPCCOM Transaction Source Application | Represents the transaction application source |
| MPCCOM Transaction Source Application Desc | |
| MPCCOM Transaction Source Desc | Represents the description of the source for the transaction |
| Transaction | Represents the description of the transaction type |
| 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 |
| MPCCOM TRANSACTION CODE | DIM_MPCCOM_TRANSACTION_CODE_TM | DIM_MPCCOM_TRANSACTION_CODE_BI | DIM_MPCCOM_TRANSACTION_CODE | On Line |