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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AJVSET1
  1. OBJ-ID
  2. MATRIX-CAT
PrimaryAC01.1, AC10.1, AC105, AC110, AC112, AC113, AC120, AC121 +22 more (list truncated in source)
AJVSET2
  1. MATRIX-CAT
  2. MX-VALUE
  3. OBJ-ID
KeyChangeAC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACTIVITYMXCATDEFMXOBJCATACACTMXVALACACTMXVAL

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequired
AJV-OBJ-ID→ACV-OBJ-ID
MxcatdefMXCATDEFRequired
AJV-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 ValueACACTMXVAL
AJV-MATRIX-CAT→AJV-MATRIX-CAT
AJV-MX-VALUE→AJV-MX-VALUE
—→AJV-OBJ-ID

Programs

Updated by (12)

Referenced by (129)