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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
Attribute 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
GL120, GL124, GL125, GL161, GL162, GL20.1, GL20.5, GL20.7 +2 more
Indexes (3)
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.
Index
Keys
Flags
Condition
Used in
AMVSET1
OBJ-ID
MATRIX-CAT
Primary
AC34.1, AC35.1, AC36.1, AM214, AM220, AM221, AM230, AM240 +22 more (list truncated in source)
AMVSET2
MATRIX-CAT
MX-VALUE
OBJ-ID
KeyChange
AC34.1, AC35.1, AC36.1, AM214, AM220, AM221, AM230, AM240 +20 more
AMVSET3
OBJ-ID
MATRIX-CAT
Subset
Where 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
Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
