SLUAMXVAL – SL User Analysis Attribute Val

System
Strategic Ledger (SL)
Prefix
UAM
Primary key
OBJ-ID, MATRIX-CAT
Fields
3
Updated by
5 programs
Referenced by
2 programs

SLUAMXVAL is the SL User Analysis Attribute Val table in Lawson Strategic Ledger (prefix UAM). It is indexed by OBJ-ID, MATRIX-CAT (UAMSET1); alternate indexes: UAMSET2. It is updated by MX500, SL00.1, SL00.3, SL00.5 and SL00.6 and referenced by MX202 and SLBL.1. The table has 3 fields, 2 indexes and 0 documented relations.

About SLUAMXVAL

The Strategic Ledger User Analysis Attribute Value (SLUAMXAL) file stores attributes associated with user analysis values.

Fields (3)

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

Field / columnTypeDescription & valuesUpdated by
UAM-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.MX500, SL00.5, SL00.6
UAM-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.MX500, SL00.5, SL00.6
UAM-MX-VALUE
MX_VALUE		Alpha 32The attribute value.MX500, SL00.5, SL00.6

Indexes (2)

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

IndexKeysFlagsConditionUsed in
UAMSET1OBJ-ID, MATRIX-CATPrimaryMX202, MX500, SL00.1, SL00.3, SL00.5, SL00.6, SLBL.1
UAMSET2MATRIX-CAT, MX-VALUE, OBJ-IDKeyChangeMX202, SLBL.1

Programs

Updated by (5)

Referenced by (2)