MLLEDGER – Multi Book Ledger

System
Multi-Ledger (ML)
Prefix
MLL
Primary key
LEDGER
Fields
3
Updated by
2 programs
Referenced by
109 programs

MLLEDGER is the Multi Book Ledger table in Lawson Multi-Ledger (prefix MLL). It is indexed by LEDGER (MLLSET1). It is related 1:M to MLCOLEDGER and MLGRPDTL. It is updated by ML10.1 and ML110 and referenced by GL165, GL65.1, ML11.1, ML111, ML12.1, ML12.2, ML145, ML146 and 101 more. The table has 3 fields, 1 index and 2 documented relations.

About MLLEDGER

The Multi Book Ledger Ledger file stores ledger header information, including the name, description, and status.

Fields (3)

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

Field / columnTypeDescription & valuesUpdated by
MLL-LEDGER PK
LEDGER		Alpha 15The name assigned to the ledger. This is established in Ledger Setup (ML10).ML10.1, ML110, RW100
MLL-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of the ledger.ML10.1, ML110, RW100
MLL-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status field is used to display the current status of a ledger.
  • A Active
  • I Inactive
ML10.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
MLLSET1LEDGERPrimaryGL165, GL65.1, RW00.1, RW100, RW70.1, ML10.1, ML11.1, ML110 +22 more (list truncated in source)

Relations

One to many (2) — child tables

RelationTableRulesConditionField map
MlcoledgerMLCOLEDGERDelete CascadesMLL-LEDGER → MLE-LEDGER, → MLE-COMPANY
MlgrpdtlMLGRPDTLDelete CascadesMLL-LEDGER → MGD-LEDGER, → MGD-LEDGER-GROUP

Programs

Updated by (2)

Referenced by (109)