Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXLISTDTL


                             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     AC113     AC120     AC121
AC123     AC130     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    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     AM330     AM35.1    AM45.1
AM501     AM70.4    AM88.1    AMBL.1    AR250     AR251
AR30.5    BR120     BR121     BR130     BR131     BR142
BR151     BR152     BR153     BR154     BR155     BR156
BR157     BR165     BR200     BR202     BR204     BR205
BR210     BR215     BR220     BR251     BR252     BR253
BR254     BR265     BR400     BR405     BR420     BR430
BR450     BR521     BR530     BR900     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
Element: 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
Element: 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
Element: 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
Element: Sequence NumbeA unique number assigned to each
                       transaction to be transferred into the
                       Lawson system.

MLD-MATRIX-CAT         Alpha 12                                  MX10.1
Element: Matrix CategorAttribute 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
Element: From Matrix VaThe beginning value in a range of
                       values.


MLD-TH-MX-VAL          Alpha 32                                  MX10.1
Element: To Matrix ValuThe 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   AC113
          OR-GROUP                                               AC120   AC121
          MATRIX-CAT                                             AC123   AC13.3
          SEQ-NUMBER                                             AC13.4  AC13.5
                                                                 AC130   AC135
                                                                 AC160   AC165
                                                                 AC190   AC191
                                                                 AC196   AC198
                                                                 AC203   AC206
                                                                 AC207   AC210
                                                                 AC213   AC218
                                                                 AC220   AC240
                                                                 AC258   AC261
                                                                 AC265   AC290
                                                                 ...

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