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.

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

IndexKeysFlagsConditionUsed in
MLMSET1OBJ-TYPE, MATRIX-LIST, SEQ-NUMBERPrimaryAC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +22 more (list truncated in source)
MLMSET2OBJ-TYPE, OBJ-ID, MATRIX-LISTAC00.1, AC10.1, AC112, AC113, AC121, AC123, AC128, AC13.1 +22 more (list truncated in source)

Relations

One to one (15) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPRequiredMLM-OBJ-IDAGP-OBJ-ID
AcactivityACACTIVITYNot RequiredMLM-OBJ-IDACV-OBJ-ID
AccountGLCHARTDTLNot RequiredMLM-OBJ-IDGDT-OBJ-ID
Acct UnitGLNAMESNot RequiredValid When (MLM-OBJ-TYPE = "ACCTU")MLM-OBJ-IDGLN-OBJ-ID
AmassetAMASSETNot RequiredMLM-OBJ-IDAST-OBJ-ID
AnalysisSLSEGVALUENot RequiredMLM-OBJ-IDSVL-OBJ-ID
ApvenmastAPVENMASTRequiredMLM-OBJ-IDVEN-AP-OBJ-ID
BuyerBUYERRequiredMLM-OBJ-IDBUY-BUY-OBJ-ID
CashcodeCBCPYCASHNot RequiredValid When MLM-OBJ-TYPE = "CSHCD"MLM-OBJ-IDCBY-OBJ-ID
GmgrantGMGRANTRequiredMLM-OBJ-IDGRN-OBJ-ID
IclocationICLOCATIONRequiredMLM-OBJ-IDICL-ICL-OBJ-ID
ItemmastITEMMASTRequiredMLM-OBJ-IDITE-IC-OBJ-ID
LeaseLMLEASENot RequiredMLM-OBJ-IDLSE-OBJ-ID
MxlisthdrMXLISTHDRRequiredMLM-OBJ-TYPEMLH-OBJ-TYPE, MLM-MATRIX-LISTMLH-MATRIX-LIST
RqlocRQLOCRequiredMLM-OBJ-IDRQL-RQL-OBJ-ID

One to many (2) — child tables

RelationTableRulesConditionField map
AccatsumACCATSUMMLM-OBJ-IDSRS-OBJ-ID, SRS-STRUCTURE, SRS-SUM-ACCT-CAT
AccatsumxACCATSUMXMLM-OBJ-IDSRX-OBJ-ID, SRX-STRUCTURE, SRX-ACCT-CATEGORY

Programs

Updated by (528)

Referenced by (232)