Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             MXLISTHDR FILE

                         Attribute List Header

This file contains attribute list header category values that can be sorted
by a maximum of eight categories. The accounting units on the list can be used
individually, or combined into a total.


REFERENCED BY

AC130     AC20.1    AC20.2    AC20.3    AC20.4    AC20.5
AC52.1    AC62.1    AM180     CA110     FB100     FB11.1
FB20.1    FB20.6    FB20.7    FB21.1    FB211     FB296
FB95.1    FB95.2    FB95.3    FB95.4    FB95.5    FB95.6
GL100     GL256     GL298     GL55.1    GL94.1    GL94.2
GL94.3    GL94.4    GL94.5    GL94.6    GL94.7    GL95.1
GL95.2    GL95.3    GL95.4    GL95.5    GL95.6    GL95.7
GL95.8    GL95.9    GL96.1    GL96.2    GL96.3    GL96.4
GL96.5    GL97.1    GL97.2    GL97.3    GL97.4    GL97.5
GL97.6    GL97.7    GL97.8    GL97.9    GL98.1    GL98.2
GL98.3    GL98.4    GL98.5    GL99.1    GL99.2    GL99.3
GL99.4    GL99.5    GL99.6    RW00.1    RW10.2    RW10.3
RW10.4    RW10.6    RW10.7    RW100     RW20.5    RW20.6
RW230     RW270     RW298     RW30.1    RW60.1    RW60.4
RW70.1    GL00.1    GL00.3    GL02.1    GL02.2    GL02.3
GL13.1    GL160     GL60.1    GLAV.1    GLCV.1    GLVW.1
JB00.1    MX20.1    MX202     MX210     MX223     SLVW.1

UPDATED BY

AC00.1    AC01.1    AC03.2    AC10.1    AC10.3    AC105
AC110     AC112     AC12.1    AC120     AC121     AC123
AC13.1    AC13.2    AC13.3    AC13.4    AC13.5    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
AC500     AC510     AC520     AC530     AC55.1    AC90.1
AC92.1    AC93.1    AC94.1    AC95.1    AC97.1    ACBA.1
ACVW.1    DA233     DA240     GR240     SE90.1    AM115
AM120     AM15.1    AM15.2    AM15.3    AM15.4    AM170
AM20.1    AM20.2    AM20.3    AM20.4    AM20.5    AM20.6
AM21.1    AM21.2    AM21.3    AM21.4    AM21.5    AM21.6
AM214     AM220     AM221     AM222     AM223     AM224
AM225     AM23.1    AM23.2    AM23.3    AM23.4    AM23.5
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    AM500     AM551     AM70.4    AM88.1    AM96.1
AM98.1    AMBL.1    AR250     AR251     AR30.5    BR02.2
BR02.3    BR11.1    BR120     BR121     BR130     BR131
BR142     BR165     BR200     BR202     BR204     BR205
BR210     BR220     BR265     BR400     BR405     BR420
BR430     BR450     BRCC.1    CA10.1    CA10.7    GL110
GL120     GL191     RW80.1    GL21.2    GL22.2    GLAC.1
GLBL.1    IFLU.1    MX10.1    MX10.2    MX10.3    MX123
MX500     SLBL.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MLH-OBJ-TYPE         Alpha 5                                     AC00.1  AC03.2
Object Type          This field will determine the type of       AC10.1  AC10.3
                     object that is being used by the            AC110   AC112
                     Attribute. These values are not user        AC12.1  AC120
                     maintainable.                               AC13.1  AC13.2
                                                                 AC500   AC510
                                                                 AC520   AM115
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM23.1
                                                                 AM23.2  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1  BR02.2
                                                                 BR02.3  BR11.1
                                                                 GL110   GL120
                                                                 IFLU.1  MX10.2

MLH-MATRIX-LIST      Alpha 12                                    AC00.1  AC03.2
Matrix List          Attribute categories are selection          AC10.1  AC10.3
                     parameters used to build a list of          AC110   AC112
                     objects (accounting units). Attributes      AC12.1  AC120
                     and values are the basis of the             AC13.1  AC13.2
                     selection and sorting. An attribute can     AC13.5  AC500
                     then be used for reporting on and           AC510   AC520
                     processing "objects."                       AM115   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM23.1  AM23.2
                                                                 AM23.5  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1  BR02.2
                                                                 BR02.3  BR11.1
                                                                 GL110   GL120
                                                                 IFLU.1  MX10.2
                                                                 MX10.3

MLH-DESCRIPTION      Alpha 30  (Lower Case)                      AC13.5  AM23.5
Description          The attribute description.                  MX10.2  MX10.3
                                                                 RW100

MLH-SHORT-DESC       Derived
Short Description    The short description.

MLH-SORT-MX-CAT      Alpha 12 Occurs 8 Times                     GL21.2  GL22.2
Sort Matrix Category Consists of up to eight attribute           MX10.2
                     categories for sorting the selected
                     objects. The attribute category does not
                     have to be a selection category in order
                     to be a sort category. The sort is in
                     ascending  order.


MLH-CREATOR          Alpha 15                                    AC13.5  AM23.5
Creator              User identification of the person           MX10.2  MX10.3
                     creating the record.


MLH-LIST-TYPE        Alpha 1                                     AC13.4  AM23.4
List Type            Determines whether the list of objects      GL21.2  GL22.2
                     was automatically created using             MX10.1
                     parameters, or whether it was manually
                     defined.  A manual list will never be
                     rebuilt by the system.

                     A = Automatic
                     M = Manual

MLH-LAST-MAINT-DT    Numeric 8  (yyyymmdd)                       AC00.1  AC03.2
Last Maintained Date The last date that the list was             AC10.1  AC10.3
                     maintained.                                 AC110   AC112
                                                                 AC12.1  AC120
                                                                 AC13.1  AC13.2
                                                                 AC13.5  AC500
                                                                 AC510   AC520
                                                                 AM115   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM23.1  AM23.2
                                                                 AM23.5  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1  BR02.2
                                                                 BR02.3  BR11.1
                                                                 GL110   GL120
                                                                 IFLU.1  MX10.1
                                                                 MX10.2  MX10.3

MLH-LAST-MAINT-TM    Numeric 6  (hhmmss)                         AC00.1  AC03.2
Last Maintained Time The last time that the list was             AC10.1  AC10.3
                     maintained.                                 AC110   AC112
                                                                 AC12.1  AC120
                                                                 AC13.1  AC13.2
                                                                 AC13.5  AC500
                                                                 AC510   AC520
                                                                 AM115   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM23.1  AM23.2
                                                                 AM23.5  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1  BR02.2
                                                                 BR02.3  BR11.1
                                                                 GL110   GL120
                                                                 IFLU.1  MX10.1
                                                                 MX10.2  MX10.3

MLH-LAST-BUILD-DT    Numeric 8  (yyyymmdd)                       AC01.1  AC105
Last Build Date      The last build date.                        AC112   AC120
                                                                 AC121   AC123
                                                                 AC13.3  AC13.4
                                                                 AC13.5  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
                                                                 ...

MLH-LAST-BUILD-TM    Numeric 6  (hhmmss)                         AC01.1  AC105
Last Build Time      The last build time.                        AC112   AC120
                                                                 AC121   AC123
                                                                 AC13.3  AC13.4
                                                                 AC13.5  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
                                                                 ...

MLH-LAST-SEQ-NBR     Numeric 6                                   AC01.1  AC105
Last Sequence Number The last sequence number.                   AC112   AC120
                                                                 AC121   AC123
                                                                 AC13.3  AC13.4
                                                                 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
                                                                 ...

MLH-UPDATE-FLAG      Alpha 1                                     MX10.2
Update Flag          This field determines how the List will
                     be rebuilt. System option means the
                     programs using the list will rebuilt it.
                     User option means the list will only be
                     rebuilt when done by a user.

                     S = System
                     U = User

MLH-SEGMENT          Alpha 15                                    MX10.2
User Analysis        The name that identifies the user
                     analysis.

                     A user analysis is a flexible,
                     user-defined element, much like an
                     accounting unit, account, or attribute,
                     that stores transaction information you
                     can use for reports and analysis.

                     You can use a user analysis to track
                     multiple elements of business data.




MLH-ARRAY1           Derived
Array1               Used for Drill Around purposes.

MLH-ARRAY2           Derived
Array2               Used for Drill Around purposes.

MLH-ARRAY3           Derived
Array3               Used for Drill Around purposes.

MLH-ARRAY4           Derived
Array4               Used for Drill Around purposes.

MLH-ARRAY5           Derived
Array5               Used for Drill Around purposes.

MLH-ARRAY6           Derived
Array6               Used for Drill Around purposes.

MLH-ARRAY7           Derived
Array7               Used for Drill Around purposes.

MLH-ARRAY8           Derived
Array8               Used for Drill Around purposes.

MLH-SORT-MX-CAT-1    Derived
Sort Category 1      Attribute sort category 1. Attribute
                     lists can be sorted using up to eight
                     categories.


MLH-SORT-MX-CAT-2    Derived
Sort Category 2      Attribute sort category 2.

MLH-SORT-MX-CAT-3    Derived
Sort Category 3      Attribute sort category 3.

MLH-SORT-MX-CAT-4    Derived
Sort Category 4      Attribute sort category 4.

MLH-SORT-MX-CAT-5    Derived
Sort Category 5      Attribute sort category 5.

MLH-SORT-MX-CAT-6    Derived
Sort Category 6      Attribute sort category 6.

MLH-SORT-MX-CAT-7    Derived
Sort Category 7      Attribute sort category 7.

MLH-SORT-MX-CAT-8    Derived
Sort Category 8      Attribute sort category 8.

                         MXLISTHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MLHSET1   OBJ-TYPE                                               AC00.1  AC01.1
          MATRIX-LIST                                            AC03.2  AC10.1
                                                                 AC10.3  AC105
                                                                 AC110   AC112
                                                                 AC12.1  AC120
                                                                 AC121   AC123
                                                                 AC13.1  AC13.2
                                                                 AC13.3  AC13.4
                                                                 AC13.5  AC130
                                                                 AC135   AC160
                                                                 AC165   AC190
                                                                 AC191   AC196
                                                                 AC198   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 ...

                         MXLISTHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Matrix Cat 1   MXOBJCAT     Not Required

                            MLH-OBJ-TYPE         -> MOC-OBJ-TYPE
                            MLH-SORT-MX-CAT-1    -> MOC-MATRIX-CAT

Matrix Cat 2   MXOBJCAT     Not Required

                            MLH-OBJ-TYPE         -> MOC-OBJ-TYPE
                            MLH-SORT-MX-CAT-2    -> MOC-MATRIX-CAT

Matrix Cat 3   MXOBJCAT     Not Required

                            MLH-OBJ-TYPE         -> MOC-OBJ-TYPE
                            MLH-SORT-MX-CAT-3    -> MOC-MATRIX-CAT

Matrix Cat 4   MXOBJCAT     Not Required

                            MLH-OBJ-TYPE         -> MOC-OBJ-TYPE
                            MLH-SORT-MX-CAT-4    -> MOC-MATRIX-CAT

Matrix Cat 5   MXOBJCAT     Not Required

                            MLH-OBJ-TYPE         -> MOC-OBJ-TYPE
                            MLH-SORT-MX-CAT-5    -> MOC-MATRIX-CAT

Matrix Cat 6   MXOBJCAT     Not Required

                            MLH-OBJ-TYPE         -> MOC-OBJ-TYPE
                            MLH-SORT-MX-CAT-6    -> MOC-MATRIX-CAT

Matrix Cat 7   MXOBJCAT     Not Required

                            MLH-OBJ-TYPE         -> MOC-OBJ-TYPE
                            MLH-SORT-MX-CAT-7    -> MOC-MATRIX-CAT

Matrix Cat 8   MXOBJCAT     Not Required

                            MLH-OBJ-TYPE         -> MOC-OBJ-TYPE
                            MLH-SORT-MX-CAT-8    -> MOC-MATRIX-CAT

Object Id      OBJID        Required

                            MLH-OBJ-TYPE         -> OBI-OBJ-TYPE

                         MXLISTHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxlistdtl      MXLISTDTL    Delete Cascades

                            MLH-OBJ-TYPE         -> MLD-OBJ-TYPE
                            MLH-MATRIX-LIST      -> MLD-MATRIX-LIST
                                                    MLD-OR-GROUP
                                                    MLD-MATRIX-CAT
                                                    MLD-SEQ-NUMBER

Mxlistmbr      MXLISTMBR    Delete Cascades

                            MLH-OBJ-TYPE         -> MLM-OBJ-TYPE
                            MLH-MATRIX-LIST      -> MLM-MATRIX-LIST
                                                    MLM-SEQ-NUMBER

Used In View   MXVIEWDTL    Delete Restricted

                            MLH-OBJ-TYPE         -> MVD-OBJ-TYPE
                            MLH-MATRIX-LIST      -> MVD-SUMMARY-LVL
                                                    MVD-OBJ-ID