Lawson Insight Technical Documentation |
|
SLMXVALUE
SLMXVALUE FILE
PL Attribute Value
The Strategic Ledger Attribute Values (SLMXVALUE) file stores attribute
information you associate with a user analysis.
UPDATED BY
GL146 GL190 GL191 GL197 GL199 GL40.1
GL40.2 GL40.3 GL40.6 GL40.7 GL40.8 GL44.1
GL45.1 IFGT.1 SL40.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SMV-OBJ-ID Numeric 12 GL146 GL190
Element: Object This is the object identifier. It is GL191 GL197
used to relate commitments or posted GL199 GL40.1
transactions back to the originating GL40.2 GL40.3
subsystems. Each subsystem record that GL40.6 GL40.7
is updated as a commitment or posted GL40.8 GL44.1
transaction is assigned an object GL45.1 IFGT.1
identifier. The object identifier is SL40.1
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.
SMV-MATRIX-CAT Alpha 12 GL146 GL190
Element: Attribute CateAttribute name assigned to an object GL191 GL197
(like accounting unit) to track GL40.1 GL40.2
additional information. Attribute GL40.3 GL40.7
values may then be used in selection and GL40.8 GL44.1
sorting for report and analysis. GL45.1 IFGT.1
SL40.1
SMV-MX-VALUE Alpha 32 GL146 GL190
Element: Attribute ValuThe attribute value associated with the GL191 GL197
user analysis. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL40.1
SLMXVALUE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SMVSET1 OBJ-ID GL146 GL190
MATRIX-CAT GL191 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL40.1
SMVSET2 MATRIX-CAT KeyChange
MX-VALUE
OBJ-ID
SLMXVALUE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mxcatdef MXCATDEF Required
SMV-MATRIX-CAT -> MXC-MATRIX-CAT (MXCSET1)
Sltrans SLTRANS Required
SMV-OBJ-ID -> SLT-OBJ-ID
|