MXLISTHDR – Attribute List Header

System
General Ledger Setup (IF)
Prefix
MLH
Primary key
OBJ-TYPE, MATRIX-LIST
Fields
30
Updated by
571 programs
Referenced by
209 programs

MXLISTHDR is the Attribute List Header table in Lawson General Ledger Setup (prefix MLH). It is indexed by OBJ-TYPE, MATRIX-LIST (MLHSET1). It is related 1:1 to MXOBJCAT and OBJID and 1:M to MXLISTDTL, MXLISTMBR, MXLSTHDRAU and MXVIEWDTL. It is updated by AC00.1, AC01.1, AC03.7, AC10.1, AC10.3, AC105, AC110, AC112 and 563 more and referenced by AC20.1, AC20.2, AC20.3, AC20.4, AC20.5, AC255, AC300, AC305 and 201 more. The table has 30 fields, 1 index and 13 documented relations.

About MXLISTHDR

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.

Fields (30)

Column = COBOL field name without the MLH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MLH-OBJ-TYPE PK
OBJ_TYPE
Alpha 5This field will determine the type of object that is being used by the Attribute. These values are not user maintainable.AC00.1, AC03.7, AC10.1, AC10.3, AC110, AC112, AC12.1, AC120 +52 more (list truncated in source)
MLH-MATRIX-LIST PK
MATRIX_LIST
Alpha 12Attribute categories are selection parameters used to build a list of objects (accounting units). Attributes and values are the basis of the selection and sorting. An attribute can then be used for reporting on and processing "objects."AC00.1, AC03.7, AC10.1, AC10.3, AC110, AC112, AC12.1, AC120 +52 more (list truncated in source)
MLH-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)The attribute description.AC13.5, AC14.5, AC16.5, AM23.5, AR23.5, MX10.2, MX10.3, RW100
MLH-SHORT-DESC
SHORT_DESC
DerivedThe short description.
MLH-SORT-MX-CAT
SORT_MX_CAT
Alpha 12 Occurs 8 Times ×8Consists of up to eight attribute 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.AP03.4, CB01.6, GL21.2, GL22.2, MX10.2
MLH-CREATOR
CREATOR
Alpha 15User identification of the person creating the record.AC13.5, AC14.5, AC16.5, AM23.5, AR23.5, GL21.2, MX10.2, MX10.3
MLH-LIST-TYPE
LIST_TYPE
Alpha 1Determines whether the list of objects was automatically created using parameters, or whether it was manually defined. A manual list will never be rebuilt by the system.
  • A Automatic
  • M Manual
AC13.4, AC14.4, AC16.4, AM23.4, AP03.4, AR23.4, CB01.6, GL21.2 +6 more
MLH-LAST-MAINT-DT
LAST_MAINT_DT
Numeric 8 (yyyymmdd)The last date that the list was maintained.AC00.1, AC03.7, AC10.1, AC10.3, AC110, AC112, AC12.1, AC120 +52 more (list truncated in source)
MLH-LAST-MAINT-TM
LAST_MAINT_TM
Numeric 6 (hhmmss)The last time that the list was maintained.AC00.1, AC03.7, AC10.1, AC10.3, AC110, AC112, AC12.1, AC120 +52 more (list truncated in source)
MLH-LAST-BUILD-DT
LAST_BUILD_DT
Numeric 8 (yyyymmdd)The last build date.AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +52 more (list truncated in source)
MLH-LAST-BUILD-TM
LAST_BUILD_TM
Numeric 6 (hhmmss)The last build time.AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +52 more (list truncated in source)
MLH-LAST-SEQ-NBR
LAST_SEQ_NBR
Numeric 6The last sequence number.AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +52 more (list truncated in source)
MLH-UPDATE-FLAG
UPDATE_FLAG
Alpha 1This 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
MX10.2
MLH-SEGMENT
SEGMENT
Alpha 15The 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.MX10.2
MLH-ARRAY1
ARRAY1
DerivedUsed for Drill Around purposes.
MLH-ARRAY2
ARRAY2
DerivedUsed for Drill Around purposes.
MLH-ARRAY3
ARRAY3
DerivedUsed for Drill Around purposes.
MLH-ARRAY4
ARRAY4
DerivedUsed for Drill Around purposes.
MLH-ARRAY5
ARRAY5
DerivedUsed for Drill Around purposes.
MLH-ARRAY6
ARRAY6
DerivedUsed for Drill Around purposes.
MLH-ARRAY7
ARRAY7
DerivedUsed for Drill Around purposes.
MLH-ARRAY8
ARRAY8
DerivedUsed for Drill Around purposes.
MLH-SORT-MX-CAT-1
SORT_MX_CAT_1
DerivedAttribute sort category 1. Attribute lists can be sorted using up to eight categories.
MLH-SORT-MX-CAT-2
SORT_MX_CAT_2
DerivedAttribute sort category 2.
MLH-SORT-MX-CAT-3
SORT_MX_CAT_3
DerivedAttribute sort category 3.
MLH-SORT-MX-CAT-4
SORT_MX_CAT_4
DerivedAttribute sort category 4.
MLH-SORT-MX-CAT-5
SORT_MX_CAT_5
DerivedAttribute sort category 5.
MLH-SORT-MX-CAT-6
SORT_MX_CAT_6
DerivedAttribute sort category 6.
MLH-SORT-MX-CAT-7
SORT_MX_CAT_7
DerivedAttribute sort category 7.
MLH-SORT-MX-CAT-8
SORT_MX_CAT_8
DerivedAttribute sort category 8.

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MLHSET1OBJ-TYPE, MATRIX-LISTPrimaryAC00.1, AC01.1, AC03.7, AC10.1, AC10.3, AC105, AC110, AC112 +22 more (list truncated in source)

Relations

One to one (9) — lookups and parents

RelationTableRulesConditionField map
Matrix Cat 1MXOBJCATNot RequiredMLH-OBJ-TYPEMOC-OBJ-TYPE, MLH-SORT-MX-CAT-1MOC-MATRIX-CAT
Matrix Cat 2MXOBJCATNot RequiredMLH-OBJ-TYPEMOC-OBJ-TYPE, MLH-SORT-MX-CAT-2MOC-MATRIX-CAT
Matrix Cat 3MXOBJCATNot RequiredMLH-OBJ-TYPEMOC-OBJ-TYPE, MLH-SORT-MX-CAT-3MOC-MATRIX-CAT
Matrix Cat 4MXOBJCATNot RequiredMLH-OBJ-TYPEMOC-OBJ-TYPE, MLH-SORT-MX-CAT-4MOC-MATRIX-CAT
Matrix Cat 5MXOBJCATNot RequiredMLH-OBJ-TYPEMOC-OBJ-TYPE, MLH-SORT-MX-CAT-5MOC-MATRIX-CAT
Matrix Cat 6MXOBJCATNot RequiredMLH-OBJ-TYPEMOC-OBJ-TYPE, MLH-SORT-MX-CAT-6MOC-MATRIX-CAT
Matrix Cat 7MXOBJCATNot RequiredMLH-OBJ-TYPEMOC-OBJ-TYPE, MLH-SORT-MX-CAT-7MOC-MATRIX-CAT
Matrix Cat 8MXOBJCATNot RequiredMLH-OBJ-TYPEMOC-OBJ-TYPE, MLH-SORT-MX-CAT-8MOC-MATRIX-CAT
Object IdOBJIDRequiredMLH-OBJ-TYPEOBI-OBJ-TYPE

One to many (4) — child tables

RelationTableRulesConditionField map
MxlistdtlMXLISTDTLDelete CascadesMLH-OBJ-TYPEMLD-OBJ-TYPE, MLH-MATRIX-LISTMLD-MATRIX-LIST, MLD-OR-GROUP, MLD-MATRIX-CAT, MLD-SEQ-NUMBER
MxlistmbrMXLISTMBRDelete CascadesMLH-OBJ-TYPEMLM-OBJ-TYPE, MLH-MATRIX-LISTMLM-MATRIX-LIST, MLM-SEQ-NUMBER
MxlsthdrauMXLSTHDRAUMLH-OBJ-TYPELHA-OBJ-TYPE, MLH-MATRIX-LISTLHA-MATRIX-LIST, LHA-ACTION, LHA-DATE, LHA-TIME, LHA-UNIQUE-I-D
Used In ViewMXVIEWDTLDelete RestrictedMLH-OBJ-TYPEMVD-OBJ-TYPE, MLH-MATRIX-LISTMVD-SUMMARY-LVL, MVD-OBJ-ID

Programs

Updated by (571)

Referenced by (209)