MLJELOG – Multi Ledger Journal Entry Log

System: Multi-Ledger (ML)
Prefix: MJL
Primary key: LEDGER, COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE, LINE-NBR, LOG-SEQ-NBR
Fields: 22
Updated by: 14 programs
Referenced by: 3 programs

MLJELOG is the Multi Ledger Journal Entry Log table in Lawson Multi-Ledger (prefix MJL). It is indexed by LEDGER, COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE, LINE-NBR, LOG-SEQ-NBR (MJLSET1); alternate indexes: MJLSET2 and MJLSET3. It is updated by ML110, ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3 and 6 more and referenced by ML145, ML42.1 and MLJR.1. The table has 22 fields, 3 indexes and 0 documented relations.

About MLJELOG

This file contains journal entry log information including the system code, control group, and sequence number.

Fields (22)

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

Field / column	Type	Description & values	Updated by
`MJL-LEDGER` PK LEDGER	Alpha 15	The ledger being posted to.	ML110, ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3 +6 more
`MJL-COMPANY` PK COMPANY	Numeric 4	This is the company the ledger is linked to.	ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
`MJL-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	This is the current fiscal year. This field is updated by Ledger Period Closing (ML199).	ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
`MJL-ACCT-PERIOD` PK ACCT_PERIOD	Numeric 2	This is the current accounting period. This field is updated by Ledger Period Closing (ML199).	ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
`MJL-SYSTEM` PK SYSTEM	Alpha 2	A two-character code representing an application used within the Lawson system. (For example, GL = General Ledger, AP = Accounts Payable, and so on.)	ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
`MJL-JE-TYPE` PK JE_TYPE	Alpha 1	The type of journal entry. Valid values are Normal and Intercompany.	ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
`MJL-CONTROL-GROUP` PK CONTROL_GROUP	Numeric 8	This field contains the journal entry number used for process control of the journal entry detail.	ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
`MJL-JE-SEQUENCE` PK JE_SEQUENCE	Numeric 2	The journal entry sequence number.	ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
`MJL-LINE-NBR` PK LINE_NBR	Numeric 6	This field contains the journal entry line number.	ML146, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7 +4 more
`MJL-LOG-SEQ-NBR` PK LOG_SEQ_NBR	Numeric 6	The journal entry log sequence number.	ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
`MJL-ERROR-CAT` ERROR_CAT	Alpha 5	The journal entry error category.	ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
`MJL-MSG-NBR` MSG_NBR	Numeric 3	The journal entry error message number.	ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
`MJL-ERR-INF-FLAG` ERR_INF_FLAG	Alpha 1	The journal entry error flag.	ML190, MLIT.1
`MJL-PROGRAM` PROGRAM	Alpha 5	This field designates the program that created this record.	ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
`MJL-RUN-DATE` RUN_DATE	Numeric 8 (yyyymmdd)	The date a transaction was posted to the ledger.	ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
`MJL-RUN-TIME` RUN_TIME	Numeric 6 (hhmmss)	The time a transaction was posted to the ledger.	ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
`MJL-ERR-VAR1` ERR_VAR1	Alpha 20	—	MLIT.1
`MJL-ERR-VAR2` ERR_VAR2	Alpha 20	—	MLIT.1
`MJL-ERR-VAR3` ERR_VAR3	Alpha 20	—	MLIT.1
`MJL-ERR-VAR4` ERR_VAR4	Alpha 20	—	MLIT.1
`MJL-ERR-VAR5` ERR_VAR5	Alpha 20	—	MLIT.1
`MJL-OPERATOR` OPERATOR	Alpha 10 (Lower Case)	—	ML146, ML190, ML191, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7 +4 more

Indexes (3)

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

Index	Keys	Flags	Condition	Used in
`MJLSET1`	`LEDGER`, `COMPANY`, `FISCAL-YEAR`, `ACCT-PERIOD`, `SYSTEM`, `JE-TYPE`, `CONTROL-GROUP`, `JE-SEQUENCE`, `LINE-NBR`, `LOG-SEQ-NBR`	Primary		ML110, ML145, ML146, ML190, ML191, ML40.1, ML40.2, ML40.3 +8 more
`MJLSET2`	`LEDGER`, `COMPANY`, `RUN-DATE`, `RUN-TIME`, `PROGRAM`, `FISCAL-YEAR`, `ACCT-PERIOD`, `SYSTEM`, `JE-TYPE`, `CONTROL-GROUP`, `JE-SEQUENCE`, `LINE-NBR`, `LOG-SEQ-NBR`	KeyChange		ML42.1
`MJLSET3`	`RUN-DATE`, `RUN-TIME`, `PROGRAM`, `LEDGER`, `COMPANY`, `FISCAL-YEAR`, `ACCT-PERIOD`, `SYSTEM`, `JE-TYPE`, `CONTROL-GROUP`, `JE-SEQUENCE`, `LOG-SEQ-NBR`	KeyChange, Subset	Where LINE-NBR = Zeroes And LOG-SEQ-NBR = 1	MLJR.1

Programs

Updated by (14)

ML110 Ledger Company Copy Delete
ML146 Batch Ledger Journal Control
ML190 Ledger Journal Posting
ML191 Ledger Currency Revaluation
ML199 Ledger Period Closing
ML40.1 Ledger Journal Entry
ML40.2 Define Ledger Journal
ML40.3 Ledger Speed Entry
ML40.6 Ledger Journal Copy
ML40.7 Ledger Totals
ML40.8 Ledger Journal Entry
ML44.1 Ledger Report Currency Entry
ML45.1 Ledger Journal Control
MLIT.1 General Ledger Account Edit

Referenced by (3)

ML145 Ledger Journal Hold Release
ML42.1 Ledger Journal Entry Log
MLJR.1 Interface JE Report