Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             MXLISTDTL FILE

                         Attribute List Detail

This file consists of attribute list detail records which are used to define
and access accounting unit detail information.


REFERENCED BY

AC105     AC110     AC112     AC115     AC120     AC123
AC130     AC14.1    AC160     AC165     AC170     AC190
AC191     AC196     AC20.1    AC20.2    AC20.3    AC20.4
AC203     AC206     AC207     AC210     AC214     AC215
AC216     AC240     AC265     AC290     AC295     AC297
AC30.2    AC30.3    AC310     AC32.1    AC401     AC410
AC412     AC415     AC416     AC420     AC421     AC440
AC450     AC460     AC470     AC471     AC472     AC473
AC480     AC490     AC530     AC55.1    AC79.1    ACBA.1
AM220     AM221     AM222     AM223     AM224     AM225
AM230     AM235     AM240     AM245     AM250     AM255
AM260     AM265     AM275     AM277     AM280     AM285
AM290     AM292     AM295     CA10.1    CA10.8    GL191
RW80.1    GLBL.1    MX123     MX210     SLBL.1    GL20.1
IFLU.1    MX00.2    MX00.3

UPDATED BY

AC13.4    AC13.5    AM23.4    AM23.5    GL21.2    MX10.1
MX10.2    MX10.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MLD-OBJ-TYPE         Alpha 5                                     MX10.1
Object Type          Determines the type of object to be
                     used by the Attribute. These values are
                     not user maintainable.


MLD-MATRIX-LIST      Alpha 12                                    AC13.5  AM23.5
Matrix List          Attributes are selection parameters         MX10.1  MX10.3
                     used to build a list of objects
                     (accounting units). Attributes and
                     values are the basis of the selection
                     and sorting. An attribute list can then
                     be used for reporting on and processing
                     "objects."


MLD-OR-GROUP         Alpha 1                                     MX10.1
Group                A single value used to group multiple
                     selections together. Each group of value
                     selections will be treated internally as
                     an "and" and externally as an "or."


MLD-SEQ-NUMBER       Numeric 6                                   MX10.1
Sequence Number      A unique number assigned to each
                     transaction to be transferred into the
                     Lawson system.

MLD-MATRIX-CAT       Alpha 12                                    MX10.1
Matrix Category      Attribute name assigned to an object
                     (like an accounting unit) to track
                     additional information. Attribute values
                     may then be used in selection and
                     sorting for reporting and analysis.


MLD-FR-MX-VAL        Alpha 20                                    MX10.1
From Matrix Value    The beginning value in a range of
                     values.


MLD-TH-MX-VAL        Alpha 20                                    MX10.1
To Matrix Value      The ending value in a range of values.

                         MXLISTDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MLDSET1   OBJ-TYPE                                               AC105   AC110
          MATRIX-LIST                                            AC112   AC115
          OR-GROUP                                               AC120   AC123
          MATRIX-CAT                                             AC13.3  AC13.4
          SEQ-NUMBER                                             AC13.5  AC130
                                                                 AC14.1  AC160
                                                                 AC165   AC170
                                                                 AC190   AC191
                                                                 AC196   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC203
                                                                 AC206   AC207
                                                                 AC210   AC214
                                                                 AC215   AC216
                                                                 AC240   AC265
                                                                 ...

MLDSET2   OBJ-TYPE      KeyChange                                AC13.1  AC13.2
          MATRIX-CAT                                             AM23.1  AM23.2
          MATRIX-LIST                                            GL20.1  IFLU.1
          OR-GROUP                                               MX00.2  MX00.3
          SEQ-NUMBER

                         MXLISTDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Matrix Cat     MXOBJCAT     Required

                            MLD-OBJ-TYPE       -> MOC-OBJ-TYPE
                            MLD-MATRIX-CAT     -> MOC-MATRIX-CAT

Mxlisthdr      MXLISTHDR    Required

                            MLD-OBJ-TYPE       -> MLH-OBJ-TYPE
                            MLD-MATRIX-LIST    -> MLH-MATRIX-LIST