AUMXVALUE – Acct Unit Attribute Value

System
General Ledger Setup (IF)
Prefix
AMV
Primary key
OBJ-ID, MATRIX-CAT
Fields
3
Updated by
11 programs
Referenced by
68 programs

AUMXVALUE is the Acct Unit Attribute Value table in Lawson General Ledger Setup (prefix AMV). It is indexed by OBJ-ID, MATRIX-CAT (AMVSET1); alternate indexes: AMVSET2 and AMVSET3. It is related 1:1 to GLNAMES, MXOBJCAT and MXCATDEF and 1:M to AUMXVALUAU and AUMXVALUE. It is updated by GL110, GL120, GL124, GL125, GL161, GL162, GL20.1, GL20.5 and 3 more and referenced by AC34.1, AC35.1, AC36.1, AM214, AM220, AM221, AM230, AM240 and 60 more. The table has 3 fields, 3 indexes and 6 documented relations.

About AUMXVALUE

This file contains accounting unit attribute category information that is used to build an attribute list.

Fields (3)

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

Field / columnTypeDescription & valuesUpdated by
AMV-OBJ-ID PK
OBJ_ID		Numeric 12The unique object identifier.GL110, GL120, GL124, GL125, GL161, GL162, GL20.1, GL20.5 +3 more
AMV-MATRIX-CAT PK
MATRIX_CAT		Alpha 12Attribute name assigned to an object (like an accounting unit) to track additional information. Attribute values may then be used in selection and sorting for reporting and analysis.GL120, GL124, GL125, GL161, GL162, GL20.1, GL20.5, GL20.7 +2 more
AMV-MX-VALUE
MX_VALUE		Alpha 32The category value assigned to the object.GL120, GL124, GL125, GL161, GL162, GL20.1, GL20.5, GL20.7 +2 more

Indexes (3)

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

IndexKeysFlagsConditionUsed in
AMVSET1OBJ-ID, MATRIX-CATPrimaryAC34.1, AC35.1, AC36.1, AM214, AM220, AM221, AM230, AM240 +22 more (list truncated in source)
AMVSET2MATRIX-CAT, MX-VALUE, OBJ-IDKeyChangeAC34.1, AC35.1, AC36.1, AM214, AM220, AM221, AM230, AM240 +20 more
AMVSET3OBJ-ID, MATRIX-CATSubsetWhere MATRIX-CAT != "LVL 1 VALUE" And MATRIX-CAT != "LVL 2 VALUE" And MATRIX-CAT != "LVL 3 VALUE" And MATRIX-CAT != "LVL 4 VALUE" And MATRIX-CAT != "LVL 5 VALUE"GL20.1

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
Acct UnitGLNAMESNot RequiredAMV-OBJ-ID → GLN-OBJ-ID
GlnamesGLNAMESNot RequiredAMV-OBJ-ID → GLN-OBJ-ID
Matrix CatMXOBJCATRequired"ACCTU" → MOC-OBJ-TYPE, AMV-MATRIX-CAT → MOC-MATRIX-CAT
MxcatdefMXCATDEFRequiredAMV-MATRIX-CAT → MXC-MATRIX-CAT

One to many (2) — child tables

RelationTableRulesConditionField map
AumxvaluauAUMXVALUAUAMV-OBJ-ID → AVA-OBJ-ID, AMV-MATRIX-CAT → AVA-MATRIX-CAT, → AVA-ACTION, → AVA-DATE, → AVA-TIME, → AVA-UNIQUE-I-D
Same ValueAUMXVALUEAMV-MATRIX-CAT → AMV-MATRIX-CAT, AMV-MX-VALUE → AMV-MX-VALUE, → AMV-OBJ-ID

Programs

Updated by (11)

Referenced by (68)