ICLMXVAL – Matrix Attribute Value
- System
- Inventory Control (IC)
- Prefix
ILV- Primary key
ICL-OBJ-ID,MATRIX-CAT- Fields
- 3
- Updated by
- 2 programs
- Referenced by
- 2 programs
ICLMXVAL is the Matrix Attribute Value table in Lawson Inventory Control (prefix ILV). It is indexed by ICL-OBJ-ID, MATRIX-CAT (ILVSET1); alternate indexes: ILVSET2. It is related 1:1 to ICLOCATION, MXCATDEF and MXOBJCAT. It is updated by ICLM.3 and MX500 and referenced by IC02.3 and IC02.4. The table has 3 fields, 2 indexes and 3 documented relations.
About ICLMXVAL
No description in the Lawson data dictionary.
Fields (3)
Column = COBOL field name without the ILV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ILV-ICL-OBJ-ID PKICL_OBJ_ID | Numeric 12 | This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. | IC02.4, ICLM.3, MX500 |
ILV-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis. | IC02.4, ICLM.3, MX500 |
ILV-MX-VALUEMX_VALUE | Alpha 32 | The attribute value. | IC02.4, ICLM.3, MX500 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ILVSET1 | ICL-OBJ-ID, MATRIX-CAT | Primary | IC02.3, IC02.4, ICLM.1, ICLM.3, MX500 | |
ILVSET2 | MATRIX-CAT, MX-VALUE, ICL-OBJ-ID | KeyChange | ICLM.1, MX500 |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Iclocation | ICLOCATION | Required | ILV-ICL-OBJ-ID → ICL-ICL-OBJ-ID | |
| Mxcatdef | MXCATDEF | Required | ILV-MATRIX-CAT → MXC-MATRIX-CAT | |
| Mxobjcat | MXOBJCAT | Required | "ICL" → MOC-OBJ-TYPE, ILV-MATRIX-CAT → MOC-MATRIX-CAT |