ICMXVAL – Matrix Value
- System
- Inventory Control (IC)
- Prefix
IMV- Primary key
IC-OBJ-ID,MATRIX-CAT- Fields
- 3
- Updated by
- 2 programs
- Referenced by
- 13 programs
ICMXVAL is the Matrix Value table in Lawson Inventory Control (prefix IMV). It is indexed by IC-OBJ-ID, MATRIX-CAT (IMVSET1); alternate indexes: IMVSET2. It is related 1:1 to ITEMMAST, MXCATDEF and MXOBJCAT. It is updated by ICBL.3 and MX500 and referenced by IC11.1, IC56.1, IC56.2, IC811, MX123, PO150, PO25.6, PO25.7 and 5 more. The table has 3 fields, 2 indexes and 3 documented relations.
About ICMXVAL
No description in the Lawson data dictionary.
Fields (3)
Column = COBOL field name without the IMV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#IMV-IC-OBJ-ID PKIC_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. | IC56.2, ICBL.3, MX500 |
#IMV-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. | IC56.2, ICBL.3, MX500 |
#IMV-MX-VALUE SET2MX_VALUE | Alpha 32 | The attribute value. | IC56.2, ICBL.3, MX500 |
Indexes (2)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
IMVSET1 |
| Primary | IC11.1, IC56.1, IC56.2, IC811, ICBL.1, ICBL.2, ICBL.3, MX123 +9 more | |
IMVSET2 |
| KeyChange | ICBL.1, ICBL.2, MX123, MX500 |
Relations
One to one (3) — lookups and parents
Programs
Updated by (2)
Referenced by (13)
- IC11.1 Item Master
- IC56.1 Item Attributes
- IC56.2 Values by Item Attributes
- IC811 Item Master Load
- MX123 List Member Build
- PO150 Bid Load to Contract or Catalog
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO26.4 Vendor Agreement Line Price Breaks
- PO26.5 Vendor Agreement Line Price Breaks
- PO28.2 Vendor Agreement Line Detail List
- PO36.2 Vendor Agreement Import Manual Input
- PO536 Vendor Price Agreement Load