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
AC160     AC165     AC190     AC191     AC196     AC198
AC203     AC206     AC207     AC210     AC213     AC218
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    SE90.1    AM120     AM220
AM221     AM222     AM223     AM224     AM225     AM230
AM235     AM240     AM245     AM25.2    AM250     AM255
AM260     AM265     AM270     AM275     AM277     AM278
AM280     AM281     AM282     AM285     AM290     AM292
AM295     AM320     AM35.1    AM45.1    AM70.4    AM88.1
AMBL.1    AR250     AR251     AR30.5    BR120     BR121
BR142     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
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  AC160
                                                                 AC165   AC190
                                                                 AC191   AC196
                                                                 AC198   AC203
                                                                 AC206   AC207
                                                                 AC210   AC213
                                                                 AC218   AC240
                                                                 AC258   AC261
                                                                 AC265   AC290
                                                                 AC295   AC297
                                                                 AC298   AC30.3
                                                                 ...

MLDSET2   OBJ-TYPE      KeyChange                                AC13.1  AC13.2
          MATRIX-CAT                                             AM23.1  AM23.2
          MATRIX-LIST                                            AM23.5  GL124
          OR-GROUP                                               GL20.1  IFLU.1
          SEQ-NUMBER                                             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