MLJELOG

ML Journal Entry Log

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

REFERENCED BY
ML145 ML42.1 MLJR.1


UPDATED BY
ML110 ML146 ML190 ML191 ML199 ML40.1
ML40.2 ML40.3 ML40.6 ML40.7 ML40.8 ML44.1
ML45.1 MLIT.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MJL-LEDGER
Element: Ledger
Alpha 15
The ledger being posted to.
ML110 ML146
ML190 ML191
ML199 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MJL-COMPANY
Element: Company
Numeric 4
This is the company the ledger is linked to.
ML146 ML190
ML191 ML199
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MJL-FISCAL-YEAR
Element: 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
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MJL-ACCT-PERIOD
Element: 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
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MJL-SYSTEM
Element: 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
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MJL-JE-TYPE
Element: 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
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MJL-CONTROL-GROUP
Element: 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
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MJL-JE-SEQUENCE
Element: Je Sequence
Numeric 2
The journal entry sequence number.
ML146 ML190
ML191 ML199
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MJL-LINE-NBR
Element: 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
ML40.8 ML44.1
ML45.1 MLIT.1
MJL-LOG-SEQ-NBR
Element: Seq Number
Numeric 6
The journal entry log sequence number.
ML146 ML190
ML191 ML199
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MJL-ERROR-CAT
Element: Acct Category
Alpha 5
The journal entry error category.
ML146 ML190
ML191 ML199
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MJL-MSG-NBR
Element: Msg Nbr
Numeric 3
The journal entry error message number.
ML146 ML190
ML191 ML199
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MJL-ERR-INF-FLAG
Element: Account Flag
Alpha 1
The journal entry error flag.
ML190 MLIT.1
MJL-PROGRAM
Element: Program
Alpha 5
This field designates the program that created this record.
ML146 ML190
ML191 ML199
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MJL-RUN-DATE
Element: 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
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MJL-RUN-TIME
Element: Sys 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
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MJL-ERR-VAR1
Element: Error Variable
Alpha 20
MLIT.1
MJL-ERR-VAR2
Element: Error Variable
Alpha 20
MLIT.1
MJL-ERR-VAR3
Element: Error Variable
Alpha 20
MLIT.1
MJL-ERR-VAR4
Element: Error Variable
Alpha 20
MLIT.1
MJL-ERR-VAR5
Element: Error Variable
Alpha 20
MLIT.1


MLJELOG FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MJLSET1 LEDGER
COMPANY
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
LINE-NBR
LOG-SEQ-NBR
ML110 ML145
ML146 ML190
ML191 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML42.1
ML44.1 ML45.1
MLIT.1 MLJR.1
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
WhereLINE-NBR =Zeroes
AndLOG-SEQ-NBR =1
MLJR.1


File created: Thu Jun 09 11:21:15 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.