MXLISTMBR – Attribute List

System
General Ledger Setup (IF)
Prefix
MLM
Primary key
OBJ-TYPE, MATRIX-LIST, SEQ-NUMBER
Fields
4
Updated by
528 programs
Referenced by
232 programs

MXLISTMBR is the Attribute List table in Lawson General Ledger Setup (prefix MLM). It is indexed by OBJ-TYPE, MATRIX-LIST, SEQ-NUMBER (MLMSET1); alternate indexes: MLMSET2. It is related 1:1 to ACACTGRP, ACACTIVITY, GLCHARTDTL, GLNAMES, AMASSET, SLSEGVALUE, APVENMAST, BUYER and 7 more and 1:M to ACCATSUM and ACCATSUMX. It is updated by AC00.1, AC01.1, AC105, AC112, AC113, AC120, AC121, AC123 and 520 more and referenced by AC10.1, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5, AC305, AC37.1 and 224 more. The table has 4 fields, 2 indexes and 17 documented relations.

About MXLISTMBR

This file stores list member records, including the object type, sequence number, and object ID. This information is used to perform queries on accounting units, and accounts.

Fields (4)

Column = COBOL field name without the MLM- 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
#MLM-OBJ-TYPE PK
OBJ_TYPE
Alpha 5This field determines the type of object used by the Attribute. These values are not user maintainable.AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +52 more (list truncated in source)
#MLM-MATRIX-LIST PK
MATRIX_LIST
Alpha 12Attribute categories are selection parameters used to build a list of objects (accounting units). Attribute categories and values are the basis of the selection and sorting. A attribute list can then be used for reporting on and processing "objects."AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +52 more (list truncated in source)
#MLM-SEQ-NUMBER PK
SEQ_NUMBER
Numeric 6A unique number assigned to each transaction transferred into the Lawson system.AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +52 more (list truncated in source)
#MLM-OBJ-ID SET2
OBJ_ID
Numeric 12The unique object identifier.AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +52 more (list truncated in source)

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
MLMSET1
  1. OBJ-TYPE
  2. MATRIX-LIST
  3. SEQ-NUMBER
PrimaryAC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +22 more (list truncated in source)
MLMSET2
  1. OBJ-TYPE
  2. OBJ-ID
  3. MATRIX-LIST
AC00.1, AC10.1, AC112, AC113, AC121, AC123, AC128, AC13.1 +22 more (list truncated in source)

Relations

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

One to one (15) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPRequired
MLM-OBJ-ID→AGP-OBJ-ID
AcactivityACACTIVITYNot Required
MLM-OBJ-ID→ACV-OBJ-ID
AccountGLCHARTDTLNot Required
MLM-OBJ-ID→GDT-OBJ-ID
Acct UnitGLNAMESNot RequiredValid When (MLM-OBJ-TYPE = "ACCTU")
MLM-OBJ-ID→GLN-OBJ-ID
AmassetAMASSETNot Required
MLM-OBJ-ID→AST-OBJ-ID
AnalysisSLSEGVALUENot Required
MLM-OBJ-ID→SVL-OBJ-ID
ApvenmastAPVENMASTRequired
MLM-OBJ-ID→VEN-AP-OBJ-ID
BuyerBUYERRequired
MLM-OBJ-ID→BUY-BUY-OBJ-ID
CashcodeCBCPYCASHNot RequiredValid When MLM-OBJ-TYPE = "CSHCD"
MLM-OBJ-ID→CBY-OBJ-ID
GmgrantGMGRANTRequired
MLM-OBJ-ID→GRN-OBJ-ID
IclocationICLOCATIONRequired
MLM-OBJ-ID→ICL-ICL-OBJ-ID
ItemmastITEMMASTRequired
MLM-OBJ-ID→ITE-IC-OBJ-ID
LeaseLMLEASENot Required
MLM-OBJ-ID→LSE-OBJ-ID
MxlisthdrMXLISTHDRRequired
MLM-OBJ-TYPE→MLH-OBJ-TYPE
MLM-MATRIX-LIST→MLH-MATRIX-LIST
RqlocRQLOCRequired
MLM-OBJ-ID→RQL-RQL-OBJ-ID

One to many (2) — child tables

RelationTableRulesConditionField map
AccatsumACCATSUM
MLM-OBJ-ID→SRS-OBJ-ID
—→SRS-STRUCTURE
—→SRS-SUM-ACCT-CAT
AccatsumxACCATSUMX
MLM-OBJ-ID→SRX-OBJ-ID
—→SRX-STRUCTURE
—→SRX-ACCT-CATEGORY

Programs

Updated by (528)

Referenced by (232)