ACCATMXVAL – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
AJB
Primary key
OBJ-ID, MATRIX-CAT
Fields
4
Updated by
10 programs
Referenced by
121 programs

ACCATMXVAL is a Lawson Activity Management table (prefix AJB); no description in the lawson data dictionary. It is indexed by OBJ-ID, MATRIX-CAT (AJBSET1); alternate indexes: AJBSET2. It is related 1:1 to MXCATDEF and MXOBJCAT and 1:M to ACCATMXVDT, ACCATSUM, ACCATSUMX and ACCATMXVAL. It is updated by AC08.1, AC08.2, AC08.3, AC08.6, AC135, AC16.1, AC16.2, AC16.9 and 2 more and referenced by AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 and 113 more. The table has 4 fields, 2 indexes and 6 documented relations.

About ACCATMXVAL

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the AJB- 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
#AJB-OBJ-ID PK
OBJ_ID
Numeric 12This 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.AC135, AC16.1, AC16.2, AC16.9, AC558, MX500
#AJB-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, AC16.1, AC16.2, AC16.9, AC558, MX500
#AJB-MX-VALUE SET2
MX_VALUE
Alpha 32The attribute value.AC135, AC16.1, AC16.2, AC16.9, AC558, MX500
#AJB-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
AJBSET1
  1. OBJ-ID
  2. MATRIX-CAT
PrimaryAC01.1, AC08.1, AC08.2, AC08.3, AC08.6, AC105, AC112, AC113 +22 more (list truncated in source)
AJBSET2
  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)
MXCATDEFMXOBJCATACCATMXVDTACCATSUMACCATSUMXACCATMXVALACCATMXVAL

One to one (2) — lookups and parents

RelationTableRulesConditionField map
MxcatdefMXCATDEFRequired
AJB-MATRIX-CAT→MXC-MATRIX-CAT
MxobjcatMXOBJCATRequired
"ACCAT"→MOC-OBJ-TYPE
AJB-MATRIX-CAT→MOC-MATRIX-CAT

One to many (4) — child tables

RelationTableRulesConditionField map
AccatmxvdtACCATMXVDT
AJB-OBJ-ID→MXB-OBJ-ID
AJB-MATRIX-CAT→MXB-MATRIX-CAT
—→MXB-EFFECTIVE-DATE
AccatsumACCATSUM
AJB-OBJ-ID→SRS-OBJ-ID
—→SRS-STRUCTURE
—→SRS-SUM-ACCT-CAT
AccatsumxACCATSUMX
AJB-OBJ-ID→SRX-OBJ-ID
—→SRX-STRUCTURE
—→SRX-ACCT-CATEGORY
Same ValueACCATMXVAL
AJB-MATRIX-CAT→AJB-MATRIX-CAT
AJB-MX-VALUE→AJB-MX-VALUE
—→AJB-OBJ-ID

Programs

Updated by (10)

Referenced by (121)