Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXLISTHDR


                             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

AC20.1    AC20.2    AC20.3    AC20.4    AC20.5    AC255
AC256     AC300     AC37.1    AC52.1    AC581     AC62.1
AM180     CA110     FB100     FB11.1    FB111     FB160
FB20.1    FB20.6    FB20.7    FB21.1    FB211     FB296
FB60.1    FB95.1    FB95.2    FB95.3    FB95.4    FB95.5
FB95.6    GL100     GL256     GL298     GL55.1    GL90.6
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    IFBO.1    IFOS.1    JB00.1    MX00.3
MX20.1    MX202     MX210     MX223     SLVW.1

UPDATED BY

AC00.1    AC01.1    AC03.7    AC10.1    AC10.3    AC105
AC110     AC112     AC113     AC12.1    AC120     AC121
AC123     AC13.1    AC13.2    AC13.3    AC13.4    AC13.5
AC130     AC135     AC14.1    AC14.2    AC14.3    AC14.4
AC14.5    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     AC500     AC510     AC520
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    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     AM310     AM320     AM35.1    AM45.1    AM500
AM501     AM51.1    AM551     AM70.4    AM88.1    AM96.1
AM97.1    AM98.1    AMBL.1    AP03.3    AP03.4    AP211
AP510     API3.1    API4.1    AR09.1    AR10.1    AR112
AR115     AR12.1    AR12.2    AR124     AR129     AR13.1
AR13.2    AR130     AR131     AR135     AR137     AR17.1
AR170     AR180     AR190     AR194     AR20.1    AR21.1
AR21.2    AR21.3    AR210     AR211     AR222     AR23.1
AR23.2    AR23.3    AR23.4    AR23.5    AR232     AR235
AR24.1    AR250     AR251     AR253     AR271     AR275
AR28.1    AR29.1    AR29.2    AR29.3    AR290     AR293
AR294     AR30.1    AR30.5    AR30.8    AR301     AR31.6
AR33.1    AR33.2    AR33.3    AR33.6    AR34.1    AR35.1
AR35.2    AR37.1    AR37.2    AR37.3    AR37.4    AR37.5
AR37.6    AR37.7    AR42.1    AR42.2    AR42.6    AR42.7
AR43.1    AR44.3    AR45.1    AR48.3    AR501     AR502
AR505     AR506     AR515     AR550     AR560     AR570
AR575     AR580     AR70.2    AR80.1    AR80.2    AR82.1
ARLL.1    BL02.1    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL232     BL29.1    BL29.2
BL520     BL820     BL92.1    BR10.1    BR10.4    BR10.8
BR120     BR121     BR13.1    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    CB01.6    CB01.7    CB191     DT150     DT155
DT160     DT165     DT166     DT180     DT181     DT30.1
DT30.2    DT40.1    DT45.1    DT520     DT60.1    DT60.2
DT70.1    DT70.3    DT80.1    DT85.1    DT85.2    DT90.1
DT92.1    CA10.1    CA10.7    GL110     GL120     GL191
RW80.1    IC840     GL21.2    GL22.2    GLAC.1    GLBL.1
IFLU.1    MX10.1    MX10.2    MX10.3    MX123     MX135
MX500     OE10.1    OE10.2    OE10.3    OE10.4    OE10.5
OE10.6    OE10.7    OE10.8    OE11.1    OE11.4    OE11.8
OE11.9    OE110     OE111     OE113     OE114     OE129
OE13.2    OE13.3    OE13.5    OE14.4    OE280     OE285
OE290     OE30.1    OE30.2    OE30.3    OE30.4    OE30.5
OE30.6    OE30.7    OE30.9    OE510     OE530     OE810
OE830     PR05.1    PR05.3    PR226     PR247     PR26.1
PR47.1    UK47.1    SLBL.1    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MLH-OBJ-TYPE           Alpha 5                                   AC00.1  AC03.7
Element: 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
                                                                 AC135   AC14.1
                                                                 AC14.2  AC500
                                                                 AC510   AC520
                                                                 AM115   AM117
                                                                 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  AR09.1
                                                                 AR10.1  AR112
                                                                 AR115   AR12.1
                                                                 AR12.2  AR124
                                                                 AR129   AR13.1
                                                                 AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR17.1
                                                                 AR170   AR180
                                                                 AR190   AR194
                                                                 ...

MLH-MATRIX-LIST        Alpha 12                                  AC00.1  AC03.7
Element: 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  AC135
                       then be used for reporting on and         AC14.1  AC14.2
                       processing "objects."                     AC14.5  AC500
                                                                 AC510   AC520
                                                                 AM115   AM117
                                                                 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
                                                                 AR09.1  AR10.1
                                                                 AR112   AR115
                                                                 AR12.1  AR12.2
                                                                 AR124   AR129
                                                                 AR13.1  AR13.2
                                                                 AR130   AR131
                                                                 AR135   AR137
                                                                 AR17.1  AR170
                                                                 ...

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

MLH-SHORT-DESC         Derived
Element: Short DescriptThe short description.

MLH-SORT-MX-CAT        Alpha 12 Occurs 8 Times                   AP03.4  CB01.6
Element: Sort Matrix CaConsists of up to eight attribute         GL21.2  GL22.2
                       categories for sorting the selected       MX10.2
                       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  AC14.5
Element: Creator       User identification of the person         AM23.5  AR23.5
                       creating the record.                      MX10.2  MX10.3


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

                       A = Automatic
                       M = Manual

MLH-LAST-MAINT-DT      Numeric 8  (yyyymmdd)                     AC00.1  AC03.7
Element: Last MaintaineThe last date that the list was           AC10.1  AC10.3
                       maintained.                               AC110   AC112
                                                                 AC12.1  AC120
                                                                 AC13.1  AC13.2
                                                                 AC13.5  AC135
                                                                 AC14.1  AC14.2
                                                                 AC14.5  AC500
                                                                 AC510   AC520
                                                                 AM115   AM117
                                                                 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
                                                                 AR09.1  AR10.1
                                                                 AR112   AR115
                                                                 AR12.1  AR12.2
                                                                 AR124   AR129
                                                                 AR13.1  AR13.2
                                                                 AR130   AR131
                                                                 AR135   AR137
                                                                 AR17.1  AR170
                                                                 ...

MLH-LAST-MAINT-TM      Numeric 6  (hhmmss)                       AC00.1  AC03.7
Element: Last MaintaineThe last time that the list was           AC10.1  AC10.3
                       maintained.                               AC110   AC112
                                                                 AC12.1  AC120
                                                                 AC13.1  AC13.2
                                                                 AC13.5  AC135
                                                                 AC14.1  AC14.2
                                                                 AC14.5  AC500
                                                                 AC510   AC520
                                                                 AM115   AM117
                                                                 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
                                                                 AR09.1  AR10.1
                                                                 AR112   AR115
                                                                 AR12.1  AR12.2
                                                                 AR124   AR129
                                                                 AR13.1  AR13.2
                                                                 AR130   AR131
                                                                 AR135   AR137
                                                                 AR17.1  AR170
                                                                 ...

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

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

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

MLH-UPDATE-FLAG        Alpha 1                                   MX10.2
Element: 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
Element: 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
Element: Array1        Used for Drill Around purposes.

MLH-ARRAY2             Derived
Element: Array2        Used for Drill Around purposes.

MLH-ARRAY3             Derived
Element: Array3        Used for Drill Around purposes.

MLH-ARRAY4             Derived
Element: Array4        Used for Drill Around purposes.

MLH-ARRAY5             Derived
Element: Array5        Used for Drill Around purposes.

MLH-ARRAY6             Derived
Element: Array6        Used for Drill Around purposes.

MLH-ARRAY7             Derived
Element: Array7        Used for Drill Around purposes.

MLH-ARRAY8             Derived
Element: Array8        Used for Drill Around purposes.

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


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

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

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

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

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

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

MLH-SORT-MX-CAT-8      Derived
Element: Sort Category 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.7  AC10.1
                                                                 AC10.3  AC105
                                                                 AC110   AC112
                                                                 AC113   AC12.1
                                                                 AC120   AC121
                                                                 AC123   AC13.1
                                                                 AC13.2  AC13.3
                                                                 AC13.4  AC13.5
                                                                 AC130   AC135
                                                                 AC14.1  AC14.2
                                                                 AC14.3  AC14.4
                                                                 AC14.5  AC145
                                                                 AC160   AC165
                                                                 AC190   AC191
                                                                 ...

                         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