MLGROUP – ML Group

System
Multi-Ledger (ML)
Prefix
MLG
Primary key
LEDGER-GROUP
Fields
3
Updated by
2 programs
Referenced by
12 programs

MLGROUP is the ML Group table in Lawson Multi-Ledger (prefix MLG). It is indexed by LEDGER-GROUP (MLGSET1). It is related 1:M to MLGRPDTL. It is updated by ML11.1 and ML11.2 and referenced by GL00.1, GL02.1, GL02.2, GL02.3, GL100, GL122, GL13.1, GL160 and 4 more. The table has 3 fields, 1 index and 1 documented relation.

About MLGROUP

The Multi Book Ledger Group file (MLGROUP) stores header information for the ledger group records.

Fields (3)

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

Field / columnTypeDescription & valuesUpdated by
MLG-LEDGER-GROUP PK
LEDGER_GROUP		Alpha 15The name assigned to the ledger group.ML11.2
MLG-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The ledger group description.ML11.2
MLG-LST-LGR-ORDER
LST_LGR_ORDER		Numeric 2The last ledger order number. This is used for sequencing the next ledger order number.ML11.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
MLGSET1LEDGER-GROUPPrimaryGL100, GL122, GL00.1, GL02.1, GL02.2, GL02.3, GL13.1, GL160 +6 more

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
MlgrpdtlMLGRPDTLDelete CascadesMLG-LEDGER-GROUP → MGD-LEDGER-GROUP, → MGD-LEDGER

Programs

Updated by (2)

Referenced by (12)