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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#SMV-OBJ-ID PKOBJ_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 PKMATRIX_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-VALUEMX_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 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 |
|---|---|---|---|---|
SMVSET1 |
| Primary | AC45.1, GL146, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more |
Relations
One to one (2) — lookups and parents
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