MXLISTDTL – Attribute List Detail

System
General Ledger Setup (IF)
Prefix
MLD
Primary key
OBJ-TYPE, MATRIX-LIST, OR-GROUP, MATRIX-CAT, SEQ-NUMBER
Fields
7
Updated by
21 programs
Referenced by
533 programs

MXLISTDTL is the Attribute List Detail table in Lawson General Ledger Setup (prefix MLD). It is indexed by OBJ-TYPE, MATRIX-LIST, OR-GROUP, MATRIX-CAT, SEQ-NUMBER (MLDSET1); alternate indexes: MLDSET2. It is related 1:1 to MXOBJCAT, MXLISTHDR and MXVALIDATE and 1:M to MXLSTDTLAU. It is updated by AC13.4, AC13.5, AC14.4, AC14.5, AC16.4, AC16.5, AM23.4, AM23.5 and 13 more and referenced by AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 and 525 more. The table has 7 fields, 2 indexes and 4 documented relations.

About MXLISTDTL

This file consists of attribute list detail records which are used to define and access accounting unit detail information.

Fields (7)

Column = COBOL field name without the MLD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#MLD-OBJ-TYPE PK
OBJ_TYPE		Alpha 5Determines the type of object to be used by the Attribute. These values are not user maintainable.MX10.1
#MLD-MATRIX-LIST PK
MATRIX_LIST		Alpha 12Attributes 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 list can then be used for reporting on and processing "objects."AC13.5, AC14.5, AC16.5, AM23.5, AR23.5, MX10.1, MX10.3
#MLD-OR-GROUP PK
OR_GROUP		Alpha 1A 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."MX10.1
#MLD-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.MX10.1
#MLD-MATRIX-CAT PK
MATRIX_CAT		Alpha 12Attribute 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.MX10.1
#MLD-FR-MX-VAL
FR_MX_VAL		Alpha 32The beginning value in a range of values.MX10.1
#MLD-TH-MX-VAL
TH_MX_VAL		Alpha 32The ending value in a range of values.MX10.1

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MLDSET1
  1. OBJ-TYPE
  2. MATRIX-LIST
  3. OR-GROUP
  4. MATRIX-CAT
  5. SEQ-NUMBER
PrimaryAC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +22 more (list truncated in source)
MLDSET2
  1. OBJ-TYPE
  2. MATRIX-CAT
  3. MATRIX-LIST
  4. OR-GROUP
  5. SEQ-NUMBER
KeyChangeAC13.1, AC13.2, AC14.1, AC14.2, AC16.1, AC16.2, AM23.1, AM23.2 +18 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
MXOBJCATMXLISTHDRMXVALIDATEMXLSTDTLAUMXLISTDTL

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Matrix CatMXOBJCATRequired
MLD-OBJ-TYPE→MOC-OBJ-TYPE
MLD-MATRIX-CAT→MOC-MATRIX-CAT
MxlisthdrMXLISTHDRRequired
MLD-OBJ-TYPE→MLH-OBJ-TYPE
MLD-MATRIX-LIST→MLH-MATRIX-LIST
MxvalidateMXVALIDATENot Required
MLD-MATRIX-CAT→MVL-MATRIX-CAT
MLD-TH-MX-VAL→MVL-TH-MX-VAL

One to many (1) — child tables

RelationTableRulesConditionField map
MxlstdtlauMXLSTDTLAU
MLD-OBJ-TYPE→LDA-OBJ-TYPE
MLD-MATRIX-LIST→LDA-MATRIX-LIST
MLD-OR-GROUP→LDA-OR-GROUP
MLD-MATRIX-CAT→LDA-MATRIX-CAT
MLD-SEQ-NUMBER→LDA-SEQ-NUMBER
—→LDA-ACTION
—→LDA-DATE
—→LDA-TIME
—→LDA-UNIQUE-I-D

Programs

Updated by (21)

Referenced by (533)