Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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

AC01.1    AC105     AC112     AC120     AC121     AC123
AC135     AC160     AC165     AC190     AC191     AC196
AC198     AC203     AC206     AC207     AC210     AC213
AC218     AC220     AC240     AC258     AC261     AC265
AC290     AC295     AC297     AC298     AC30.3    AC310
AC32.1    AC34.1    AC35.1    AC36.1    AC400     AC401
AC410     AC412     AC420     AC421     AC440     AC460
AC471     AC472     AC473     AC480     AC490     AC493
AC494     AC530     AC55.1    AC90.1    AC92.1    AC93.1
AC94.1    AC95.1    AC97.1    ACBA.1    ACVW.1    DA233
DA240     GR240     SE90.1    AM120     AM214     AM220
AM221     AM222     AM223     AM224     AM225     AM230
AM235     AM240     AM245     AM25.2    AM250     AM255
AM260     AM265     AM267     AM270     AM275     AM277
AM278     AM280     AM281     AM282     AM285     AM287
AM290     AM292     AM295     AM320     AM35.1    AM45.1
AM70.4    AM88.1    AMBL.1    AR250     AR251     AR30.5
BR120     BR121     BR130     BR131     BR142     BR165
BR200     BR202     BR204     BR205     BR210     BR220
BR265     BR400     BR405     BR420     BR430     BR450
BRCC.1    CA10.1    CA10.7    GL191     RW80.1    GLAC.1
GLBL.1    MX123     MX210     MX500     SLBL.1    GL00.1
GL00.3    GL124     GL20.1    IFLU.1    MX00.2    MX00.3

UPDATED BY

AC13.4    AC13.5    AM23.5    AM23.4    GL21.2    GL22.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 32                                    MX10.1
From Matrix Value    The beginning value in a range of
                     values.


MLD-TH-MX-VAL        Alpha 32                                    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                                               AC01.1  AC105
          MATRIX-LIST                                            AC112   AC120
          OR-GROUP                                               AC121   AC123
          MATRIX-CAT                                             AC13.3  AC13.4
          SEQ-NUMBER                                             AC13.5  AC135
                                                                 AC160   AC165
                                                                 AC190   AC191
                                                                 AC196   AC198
                                                                 AC203   AC206
                                                                 AC207   AC210
                                                                 AC213   AC218
                                                                 AC220   AC240
                                                                 AC258   AC261
                                                                 AC265   AC290
                                                                 AC295   AC297
                                                                 ...

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

                         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

Mxvalidate     MXVALIDATE   Not Required

                            MLD-MATRIX-CAT     -> MVL-MATRIX-CAT
                            MLD-TH-MX-VAL      -> MVL-TH-MX-VAL