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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MLDSET1OBJ-TYPE, MATRIX-LIST, OR-GROUP, MATRIX-CAT, SEQ-NUMBERPrimaryAC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +22 more (list truncated in source)
MLDSET2OBJ-TYPE, MATRIX-CAT, MATRIX-LIST, OR-GROUP, SEQ-NUMBERKeyChangeAC13.1, AC13.2, AC14.1, AC14.2, AC16.1, AC16.2, AM23.1, AM23.2 +18 more

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Matrix CatMXOBJCATRequiredMLD-OBJ-TYPE → MOC-OBJ-TYPE, MLD-MATRIX-CAT → MOC-MATRIX-CAT
MxlisthdrMXLISTHDRRequiredMLD-OBJ-TYPE → MLH-OBJ-TYPE, MLD-MATRIX-LIST → MLH-MATRIX-LIST
MxvalidateMXVALIDATENot RequiredMLD-MATRIX-CAT → MVL-MATRIX-CAT, MLD-TH-MX-VAL → MVL-TH-MX-VAL

One to many (1) — child tables

RelationTableRulesConditionField map
MxlstdtlauMXLSTDTLAUMLD-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)