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.

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

IndexKeysFlagsConditionUsed in
MGDSET1LEDGER-GROUP, LEDGERPrimaryGL20.2, ML11.1, ML11.2, ML110, ML210, ML211
MGDSET2LEDGER, LEDGER-GROUPML10.1, ML110

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
MlgroupMLGROUPRequiredMGD-LEDGER-GROUPMLG-LEDGER-GROUP
MlledgerMLLEDGERRequiredMGD-LEDGERMLL-LEDGER

Programs

Updated by (3)

Referenced by (3)