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 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 IFGT.1
SL195
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SMV-OBJ-ID Numeric 12 GL146 GL190
Object This is the object identifier. It is GL191 GL197
used to relate commitments or posted GL40.1 GL40.2
transactions back to the originating GL40.3 GL40.7
subsystems. Each subsystem record that GL40.8 GL44.1
is updated as a commitment or posted GL45.1 IFGT.1
transaction is assigned an object SL195
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.
SMV-MATRIX-CAT Alpha 12 GL146 GL190
Attribute Category Attribute 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
SL195
SMV-MX-VALUE Alpha 32 GL146 GL190
Attribute Value The 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
SL195
SLMXVALUE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SMVSET1 OBJ-ID GL146 GL190
MATRIX-CAT GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL195
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
|
