SLMXVALUE – PL Attribute Value

System: Strategic Ledger (SL)
Prefix: SMV
Primary key: OBJ-ID, MATRIX-CAT
Fields: 3
Updated by: 16 programs
Referenced by: 0 programs

SLMXVALUE is the PL Attribute Value table in Lawson Strategic Ledger (prefix SMV). It is indexed by OBJ-ID, MATRIX-CAT (SMVSET1). It is related 1:1 to MXCATDEF and SLTRANS. It is updated by AC45.1, GL146, GL190, GL191, GL197, GL199, GL40.1, GL40.2 and 8 more. The table has 3 fields, 1 index and 2 documented relations.

About SLMXVALUE

No description in the Lawson data dictionary.

Fields (3)

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

Field / column	Type	Description & values	Updated by
`SMV-OBJ-ID` PK OBJ_ID	Numeric 12	This 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.	AC45.1, GL146, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more
`SMV-MATRIX-CAT` PK MATRIX_CAT	Alpha 12	Attribute 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.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +6 more
`SMV-MX-VALUE` MX_VALUE	Alpha 32	The attribute value associated with the user analysis.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +6 more

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`SMVSET1`	`OBJ-ID`, `MATRIX-CAT`	Primary		AC45.1, GL146, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Mxcatdef	MXCATDEF	Required		`SMV-MATRIX-CAT` → `MXC-MATRIX-CAT`
Sltrans	SLTRANS	Required		`SMV-OBJ-ID` → `SLT-OBJ-ID`

Programs

Updated by (16)

AC45.1 Transaction Edit
GL146 Batch Journal Control
GL190 Journal Posting
GL191 Currency Revaluation
GL197 Period, Year End GL Commitments Processing
GL199 Period Closing
GL40.1 Journal Entry
GL40.2 Define Journal
GL40.3 Speed Entry
GL40.6 Journal Copy
GL40.7 Totals
GL40.8 Journal Entry
GL44.1 Report Currency Entry
GL45.1 Journal Control
IFGT.1 GLTRANS Interface
SL40.1 Error Transaction Edit