Lawson Insight Technical Documentation

                             GTMXVALUE FILE

                        Attribute Template Value

This file checks transactions for valid attribute values.

REFERENCED BY

GL170     GL190     GL240     GL256     GL284     GL285
GL286     GL287

UPDATED BY

GL110     GL146     GL199     GL300     GL40.1    GL40.2
GL40.3    GL40.6    GL40.7    GL40.8    GL44.1    GL45.1
IFGT.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

GMV-OBJ-ID           Numeric 12                                  GL110   GL146
Object ID            The ID of the object being used by the      GL199   GL40.1
                     attribute.                                  GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1

GMV-MATRIX-CAT       Alpha 12                                    GL146   GL40.1
Matrix Attribute     Attribute name assigned to an object        GL40.2  GL40.3
                     (like an accounting unit) to track          GL40.7  GL40.8
                     additional information. Attribute values    GL44.1  GL45.1
                     may then be used in selection and           IFGT.1
                     sorting for reporting and analysis.


GMV-MX-VALUE         Alpha 32                                    GL146   GL40.1
Matrix Value         The attribute value.                        GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1

                         GTMXVALUE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GMVSET1   OBJ-ID                                                 GL110   GL146
          MATRIX-CAT                                             GL170   GL190
                                                                 GL199   GL240
                                                                 GL256   GL284
                                                                 GL285   GL286
                                                                 GL287   GL300
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

GMVSET2   MATRIX-CAT    KeyChange                                GL256
          MX-VALUE
          OBJ-ID

                         GTMXVALUE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Gltrans        GLTRANS      Required

                            GMV-OBJ-ID        -> GLT-OBJ-ID

Mxcatdef       MXCATDEF     Required

                            GMV-MATRIX-CAT    -> MXC-MATRIX-CAT