ACACTMXVAL – Activity List Attribute Values

System
Activity Management (AC)
Prefix
AJV
Primary key
OBJ-ID, MATRIX-CAT
Fields
4
Updated by
12 programs
Referenced by
129 programs

ACACTMXVAL is the Activity List Attribute Values table in Lawson Activity Management (prefix AJV). It is indexed by OBJ-ID, MATRIX-CAT (AJVSET1); alternate indexes: AJVSET2. It is related 1:1 to ACACTIVITY, MXCATDEF and MXOBJCAT and 1:M to ACACTMXVAL. It is updated by AC10.1, AC110, AC13.1, AC13.2, AC135, AC300, AC500, AC510 and 4 more and referenced by AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 and 121 more. The table has 4 fields, 2 indexes and 4 documented relations.

About ACACTMXVAL

This file contains activity attributes from AC13.1 (Activity Attributes) and attribute values from AC13.2 (Values by Activity Attributes). It contains a record for each activity level, with the level attribute from AC10.1 (Activity). The file includes the activity object ID and the attributes and values assigned to the activity. You can define unlimited attributes for the Activity Management system, to be used in tracking additional information for reporting and analysis. You define attributes in AC13.1.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
AJV-OBJ-ID PK
OBJ_ID		Numeric 12This field is used with activity attributes. Attribute matrix files are keyed by object ID.AC110, AC13.1, AC13.2, AC135, AC500, AC510, AC560, BR10.8 +1 more
AJV-MATRIX-CAT PK
MATRIX_CAT		Alpha 12This is an attribute value assigned to an activity to track additional information. Attribute values can then be used in selection and sorting for reporting and analysis.AC110, AC13.1, AC13.2, AC135, AC500, AC510, AC560, BR10.8 +1 more
AJV-MX-VALUE
MX_VALUE		Alpha 32This is the value assigned to the attribute for the activity.AC110, AC13.1, AC13.2, AC135, AC500, AC510, AC560, BR10.7 +2 more
AJV-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.—

Indexes (2)

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

IndexKeysFlagsConditionUsed in
AJVSET1OBJ-ID, MATRIX-CATPrimaryAC01.1, AC10.1, AC105, AC110, AC112, AC113, AC120, AC121 +22 more (list truncated in source)
AJVSET2MATRIX-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
AcactivityACACTIVITYRequiredAJV-OBJ-ID → ACV-OBJ-ID
MxcatdefMXCATDEFRequiredAJV-MATRIX-CAT → MXC-MATRIX-CAT
MxobjcatMXOBJCATRequired"ACTVY" → MOC-OBJ-TYPE, AJV-MATRIX-CAT → MOC-MATRIX-CAT

One to many (1) — child tables

RelationTableRulesConditionField map
Same ValueACACTMXVALAJV-MATRIX-CAT → AJV-MATRIX-CAT, AJV-MX-VALUE → AJV-MX-VALUE, → AJV-OBJ-ID

Programs

Updated by (12)

Referenced by (129)