Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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