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
AC45.1 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 AC45.1 GL146
Element: Object This is the object identifier. It is GL190 GL191
used to relate commitments or posted GL197 GL199
transactions back to the originating GL40.1 GL40.2
subsystems. Each subsystem record that GL40.3 GL40.6
is updated as a commitment or posted GL40.7 GL40.8
transaction is assigned an object GL44.1 GL45.1
identifier. The object identifier is IFGT.1 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 AC45.1 GL146
Element: Attribute CateAttribute name assigned to an object GL190 GL191
(like accounting unit) to track GL197 GL40.1
additional information. Attribute GL40.2 GL40.3
values may then be used in selection and GL40.7 GL40.8
sorting for report and analysis. GL44.1 GL45.1
IFGT.1 SL40.1
SMV-MX-VALUE Alpha 32 AC45.1 GL146
Element: Attribute ValuThe attribute value associated with the GL190 GL191
user analysis. GL197 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 AC45.1 GL146
MATRIX-CAT GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL40.1
SLMXVALUE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mxcatdef MXCATDEF Required
SMV-MATRIX-CAT -> MXC-MATRIX-CAT
Sltrans SLTRANS Required
SMV-OBJ-ID -> SLT-OBJ-ID
|