MLGRPDTL – Multi Ledger Group Detail

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

MLGRPDTL is the Multi Ledger Group Detail table in Lawson Multi-Ledger (prefix MGD). It is indexed by LEDGER-GROUP, LEDGER (MGDSET1); alternate indexes: MGDSET2. It is related 1:1 to MLGROUP and MLLEDGER. It is updated by ML10.1, ML11.1 and ML110 and referenced by GL20.2, ML210 and ML211. The table has 2 fields, 2 indexes and 2 documented relations.

About MLGRPDTL

The Multi Book Ledger Group Detail file (MLGRPDTL) stores detail information for the ledger group records.

Fields (2)

Column = COBOL field name without the MGD- 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
#MGD-LEDGER-GROUP PK
LEDGER_GROUP		Alpha 15The name assigned to the ledger group.ML11.1
#MGD-LEDGER PK
LEDGER		Alpha 15This field keeps track of the ledger or ledgers that comprise the ledger group.ML11.1, ML110

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
MGDSET1
  1. LEDGER-GROUP
  2. LEDGER
PrimaryGL20.2, ML11.1, ML11.2, ML110, ML210, ML211
MGDSET2
  1. LEDGER
  2. LEDGER-GROUP
ML10.1, ML110

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
MlgroupMLGROUPRequired
MGD-LEDGER-GROUP→MLG-LEDGER-GROUP
MlledgerMLLEDGERRequired
MGD-LEDGER→MLL-LEDGER

Programs

Updated by (3)

Referenced by (3)