Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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     GL199     GL45.1    IFGT.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SMV-OBJ-ID           Numeric 12                                  GL146   GL190
Object               This is the object identifier. It is        GL191   GL199
                     used to relate commitments or posted        GL45.1  IFGT.1
                     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.

SMV-MATRIX-CAT       Alpha 12                                    GL146   GL190
Attribute Category   Attribute name assigned to an object        GL191   GL199
                     (like accounting unit) to track             GL45.1  IFGT.1
                     additional information.  Attribute
                     values may then be used in selection and
                     sorting for report and analysis.

SMV-MX-VALUE         Alpha 32                                    GL146   GL190
Attribute Value      The attribute value associated with the     GL191   GL199
                     user analysis.                              GL45.1  IFGT.1


                         SLMXVALUE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SMVSET1   OBJ-ID                                                 GL146   GL190
          MATRIX-CAT                                             GL191   GL199
                                                                 GL45.1  IFGT.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