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     AC145     AC160     AC165
AC190     AC191     AC197     AC198     AC200     AC203
AC206     AC207     AC210     AC213     AC218     AC220
AC240     AC246     AC261     AC265     AC290     AC295
AC298     AC30.3    AC310     AC32.1    AC34.1    AC346
AC35.1    AC36.1    AC400     AC401     AC410     AC412
AC420     AC421     AC440     AC460     AC471     AC472
AC473     AC480     AC490     AC493     AC494     AC55.1
AC580     AC583     AC90.1    AC92.1    AC93.1    AC94.1
AC95.1    ACBA.1    ACDL.1    ACDM.2    ACVW.1    SE90.1
AM115     AM117     AM120     AM15.1    AM15.2    AM15.3
AM15.4    AM20.1    AM20.3    AM21.1    AM21.3    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     AM310     AM320
AM35.1    AM45.1    AM500     AM501     AM51.1    AM551
AM70.4    AM88.1    AM97.1    AMBL.1    AP211     AP510
API3.1    API4.1    AR135     AR170     AR210     AR211
AR222     AR232     AR235     AR250     AR251     AR253
AR271     AR275     AR290     AR293     AR294     AR30.5
AR33.2    BL232     BR120     BR121     BR130     BR131
BR140     BR142     BR145     BR165     BR19.2    BR190
BR20.9    BR200     BR202     BR204     BR205     BR210
BR212     BR215     BR220     BR245     BR265     BR300
BR400     BR405     BR430     BR450     BR521     BR530
BR580     BRCC.1    CA10.1    CA10.7    GL191     RW80.1
IC840     GLAC.1    GLBL.1    MX123     MX210     MX500
OE280     OE285     OE290     PR05.1    PR05.3    PR226
PR247     PR26.1    PR47.1    UK47.1    SLBL.1    AR515
GL00.1    GL00.3    GL124     GL20.1    IFLU.1    MX00.2
MX00.3    MX100

UPDATED BY

AC13.4    AC13.5    AC14.4    AC14.5    AM23.5    AM23.4
AP03.4    AR23.5    AR23.4    CB01.6    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  AC14.5
Element: Matrix List   Attributes are selection parameters       AM23.5  AR23.5
                       used to build a list of objects           MX10.1  MX10.3
                       (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 interfaced 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
                                                                 AC14.3  AC14.4
                                                                 AC14.5  AC145
                                                                 AC160   AC165
                                                                 AC190   AC191
                                                                 AC197   AC198
                                                                 AC200   AC203
                                                                 AC206   AC207
                                                                 AC210   AC213
                                                                 AC218   AC220
                                                                 ...

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

                         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