ACGRPMXVAL – The ACGRPMXVAL file is the primary file updated by AC13.

System
Activity Management (AC)
Prefix
AGV
Primary key
OBJ-ID, MATRIX-CAT
Fields
3
Updated by
7 programs
Referenced by
119 programs

ACGRPMXVAL is the The ACGRPMXVAL file is the primary file updated by AC13. table in Lawson Activity Management (prefix AGV). It is indexed by OBJ-ID, MATRIX-CAT (AGVSET1); alternate indexes: AGVSET2. It is related 1:1 to ACACTGRP, MXCATDEF and MXOBJCAT and 1:M to ACGRPMXVAL. It is updated by AC00.1, AC135, AC14.1, AC14.2, AC300, AC560 and MX500 and referenced by AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 and 111 more. The table has 3 fields, 2 indexes and 4 documented relations.

About ACGRPMXVAL

The ACGRPMXVAL file is the primary file updated by AC13. It stores the activity group attributes and assigned values by object ID.

Fields (3)

Column = COBOL field name without the AGV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
AGV-OBJ-ID PK
OBJ_ID		Numeric 12This is the object identifier. It is used to relate attributes and attribute values back to the activity group.AC135, AC14.1, AC14.2, AC560, MX500
AGV-MATRIX-CAT PK
MATRIX_CAT		Alpha 12Attribute 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.AC135, AC14.1, AC14.2, AC560, MX500
AGV-MX-VALUE
MX_VALUE		Alpha 32The attribute value.AC135, AC14.1, AC14.2, AC560, MX500

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AGVSET1OBJ-ID, MATRIX-CATPrimaryAC00.1, AC01.1, AC105, AC112, AC113, AC120, AC121, AC123 +22 more (list truncated in source)
AGVSET2MATRIX-CAT, MX-VALUE, OBJ-IDKeyChangeAC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPRequiredAGV-OBJ-ID → AGP-OBJ-ID
MxcatdefMXCATDEFRequiredAGV-MATRIX-CAT → MXC-MATRIX-CAT
MxobjcatMXOBJCATRequired"ACGRP" → MOC-OBJ-TYPE, AGV-MATRIX-CAT → MOC-MATRIX-CAT

One to many (1) — child tables

RelationTableRulesConditionField map
Same ValueACGRPMXVALAGV-MATRIX-CAT → AGV-MATRIX-CAT, AGV-MX-VALUE → AGV-MX-VALUE, → AGV-OBJ-ID

Programs

Updated by (7)

Referenced by (119)