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.

Field / column	Type	Description & values	Updated by
`IMV-IC-OBJ-ID` PK IC_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` PK MATRIX_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` MX_VALUE	Alpha 32	The attribute value.	IC56.2, ICBL.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
`IMVSET1`	`IC-OBJ-ID`, `MATRIX-CAT`	Primary		IC11.1, IC56.1, IC56.2, IC811, ICBL.1, ICBL.2, ICBL.3, MX123 +9 more
`IMVSET2`	`MATRIX-CAT`, `MX-VALUE`, `IC-OBJ-ID`	KeyChange		ICBL.1, ICBL.2, MX123, MX500

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Field map
Itemmast	ITEMMAST	Required	`IMV-IC-OBJ-ID` → `ITE-IC-OBJ-ID`
Mxcatdef	MXCATDEF	Required	`IMV-MATRIX-CAT` → `MXC-MATRIX-CAT`
Mxobjcat	MXOBJCAT	Required	`"ITEM"` → `MOC-OBJ-TYPE`, `IMV-MATRIX-CAT` → `MOC-MATRIX-CAT`

Programs

Updated by (2)

ICBL.3 Item Matrix Value Object
MX500 Attribute Value Population

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