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

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