MLCONTROL

Multi Book Ledger Control

The Multi Book Ledger Control file contains journal entry control information. This information is used to process the journal entry detail records.

REFERENCED BY
ML240 ML241 ML245 ML270 ML290 ML90.1
ML90.2 MLCC.1 MLJR.1


UPDATED BY
ML110 ML145 ML146 ML167 ML170 ML190
ML191 ML196 ML199 ML300 ML40.1 ML40.2
ML40.3 ML40.6 ML40.7 ML40.8 ML41.4 ML44.1
ML45.1 ML75.1 MLIT.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLC-LEDGER
Element: Ledger		Alpha 15
The ledger into which the transactions are to be interfaced.
ML110 ML167
ML191 ML196
ML199 ML40.2
ML40.6 ML41.4
ML45.1 MLCC.1
MLIT.1
MLC-COMPANY
Element: Company		Numeric 4
The company into which the transactions are to be interfaced.
ML167 ML191
ML196 ML199
ML40.2 ML40.6
ML41.4 ML45.1
MLCC.1 MLIT.1
MLC-FISCAL-YEAR
Element: Year		Numeric 4
This is the current fiscal year. This field is updated by Ledger Period Closing (ML199).
ML167 ML191
ML196 ML199
ML40.2 ML40.6
ML41.4 ML45.1
MLCC.1 MLIT.1
MLC-ACCT-PERIOD
Element: Acct Period		Numeric 2
This is the current accounting period. This field is updated by Ledger Period Closing (ML199).
ML167 ML191
ML196 ML199
ML40.2 ML40.6
ML41.4 ML45.1
MLCC.1 MLIT.1
MLC-CONTROL-GROUP
Element: Control Group		Numeric 8
This field displays the journal entry number used for process control of the journal entry detail.
ML167 ML191
ML196 ML199
ML40.2 ML40.6
ML41.4 ML45.1
MLCC.1 MLIT.1
MLC-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)
ML167 ML191
ML196 ML199
ML40.2 ML40.6
ML41.4 ML45.1
MLCC.1 MLIT.1
MLC-JE-TYPE
Element: Je Type		Alpha 1
The journal entry type.(Normal or Intercompany).
ML167 ML191
ML196 ML199
ML40.2 ML40.6
ML41.4 ML45.1
MLCC.1 MLIT.1
MLC-JE-TYPE-1
Element: Je Type 1		Derived
Displays the derived journal entry type.
MLC-JE-SEQUENCE
Element: Je Sequence		Numeric 2
Displays the derived journal type.
ML146 ML167
ML190 ML191
ML196 ML199
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML41.4 ML44.1
ML45.1 MLCC.1
MLIT.1
MLC-STATUS
Element: Status		Numeric 1
This contains the processing cycle status of the assigned journal entry.
0 = Unreleased
1 = Released
2 = Post In Progress
3 = Load In Process
4 = Quick Posted
5 = Posted
9 = History
ML146 ML167
ML190 ML191
ML196 ML199
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLC-STATUS-1
Element: Status 1		Derived
This field displays the journal entry status.
MLC-CNTRL-AMOUNT
Element: Intl Amt		Signed 18.2
Displays the total journal entry amount.
ML146 ML190
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1
MLC-ENTRY-DB
Element: Intl Amt		Signed 18.2
Displays the total journal entry debit amount.
ML146 ML167
ML190 ML191
ML199 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-ENTRY-CR
Element: Intl Amt		Signed 18.2
Displays the total journal entry credit amount.
ML146 ML167
ML190 ML191
ML199 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-TRAN-ND
Element: Acct Nd		Numeric 1
The number of decimal positions defined for the transaction currency.
ML167 ML191
ML196 ML199
ML40.2 ML40.5
ML41.3 ML45.1
MLIT.1
MLC-UNIT-CNTRL-DB
Element: Auto Debits		Signed 15.2
The journal entry total for positive detail unit balances.
ML190
MLC-UNIT-CNTRL-CR
Element: Auto Credits		Signed 15.2
The journal entry total for negative detail unit balances.
ML190
MLC-UNIT-ENTRY-DB
Element: Auto Debits		Signed 15.2
Displays the total debit units for the journal entry.
ML146 ML167
ML190 ML191
ML199 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-UNIT-ENTRY-CR
Element: Auto Credits		Signed 15.2
Displays the total credit units for the journal entry.
ML146 ML167
ML190 ML191
ML199 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-AUTO-UNIT-DB
Element: Auto Debits		Signed 15.2
The total positive detail auto reversing units amounts.
ML146 ML190
ML191 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-AUTO-UNIT-CR
Element: Auto Credits		Signed 15.2
The total negative detail auto reversing units amounts.
ML146 ML190
ML191 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when the journal entry record was created.
ML167 ML191
ML196 ML199
ML40.2 ML40.6
ML45.1 MLIT.1
MLC-LINE-NBR
Element: Line Nbr		Numeric 6
This field contains the journal entry line number.
ML146 ML167
ML190 ML191
ML196 ML199
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-NBR-LINES
Element: Nbr Lines		Numeric 6
This field contains the number of detail lines for the journal entry.
ML146 ML167
ML190 ML191
ML199 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLC-OPERATOR
Element: Operator		Alpha 10
This field is used to store the user ID of the person who created the journal entry.
ML146 ML167
ML191 ML196
ML199 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-REL-OPERATOR
Element: Operator		Alpha 10
This field is used to store the user ID of the person who released the journal entry.
ML199 ML40.6
MLIT.1
MLC-RELEASED-FLAG
Element: Released Flag		Alpha 1
This flag is set to Yes when a journal entry is released. If the journal entry is unreleased, this flag will not be reset; instead it serves as an indicator that the journal entry has been released at one-time.
ML190 ML199
ML40.6 MLIT.1
MLC-HOLD-CODE
Element: Hold Code		Alpha 4
This field displays the journal hold code defined using Journal Hold Code (GL12.1). If a hold code exists for a journal entry, the journal entry cannot be posted until the hold code is removed.
ML145 ML146
ML199 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLC-PER-DATE-FLAG
Element: Per Date Flag		Alpha 1
This field indicates whether the period or date is derived. Valid entries are: P = Period D = Date
ML40.2 ML40.6
ML45.1 MLIT.1
MLC-POSTING-DATE
Element: Posting Date		Numeric 8 (yyyymmdd)
This field displays the date assigned to the journal entry for posting.
ML146 ML167
ML191 ML196
ML199 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-LAST-CMT-SEQ
Element: Last Cmt Seq		Numeric 4
The sequence number for the last comment for the journal entry.
ML190 ML199
MLC-LAST-LOG-SEQ
Element: Seq Number		Numeric 6
The last sequence control number.
ML146 ML190
ML191 ML199
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLC-BASE-ZONE
Element: Zone		Alpha 15
The base zone as assigned for interzone balance processing.
ML146 ML167
ML191 ML196
ML199 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-BASE-DEBITS
Element: Intl Amt		Signed 18.2
The total positive detail amount in the company base currency.
ML146 ML167
ML190 ML191
ML199 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-BASE-CREDITS
Element: Intl Amt		Signed 18.2
The total negative detail amount in the company base currency.
ML146 ML167
ML190 ML191
ML199 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-BASE-AUTO-DB
Element: Intl Amt		Signed 18.2
The total positive detail auto reversing amount in the company base currency.
ML146 ML190
ML191 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-BASE-AUTO-CR
Element: Intl Amt		Signed 18.2
The total negative detail auto reversing amount in the company base currency.
ML146 ML190
ML191 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-BASE-ND
Element: Base Nd		Numeric 1
The number of decimal positions defined for the company base currency.
ML167 ML191
ML196 ML199
ML40.2 ML40.6
ML45.1 MLIT.1
MLC-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field displays the transaction currency code. The company base currency code established in Company (GL10.1) defaults.
ML167 ML191
ML196 ML199
ML40.2 ML45.1
MLIT.1
MLC-BASERATE
Element: Curr Rate		Signed 14.7
The exchange rate to convert the transaction currency to the base currency.
ML167 ML191
ML196 ML199
ML40.2 ML40.6
ML45.1 MLIT.1
MLC-NET-BASE-AMT
Element: Net Base Amt		Derived
The net amount in the base currency.
MLC-NET-BASE-AREV
Element: Net Base Arev		Derived
The net reversed in the base currency.
MLC-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
The journal entry description.
ML146 ML167
ML191 ML196
ML199 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-AUTO-REV
Element: Auto Rev		Alpha 1
Auto reversal is the process of reversing the transaction. If you select auto reverse, the Ledger Period Closing (ML199) creates a reversing journal entry in the next period for this transaction.
ML146 ML199
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLC-SOURCE-CODE
Element: Source Code		Alpha 2
A two-character code assigned to a transaction to identify where the transaction was created.
ML146 ML196
ML199 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLC-REFERENCE
Element: Reference		Alpha 10 (Lower Case)
The reference you enter for this journal entry appears on inquiries and reports.
ML146 ML167
ML191 ML196
ML199 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-DOCUMENT-NBR
Element: Document Nbr		Alpha 27
The document number assigned to the journal entry.
ML146 ML199
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
The actual date of the transaction.
ML199 ML40.2
MLC-JRNL-BOOK-NBR
Element: Jrnl Book Nbr		Alpha 12
If the company uses journal books, this field displays the journal book assigned to the transaction.
ML146 ML190
ML199 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-JBK-SEQ-NBR
Element: Jbk Seq Nbr		Numeric 10
The journal book sequence number The number assigned to a journal book when it is added or interfaced to the ML system. Used only when Auto Journal Book Seq Nbr is set to Yes on Company (GL10.1).
ML40.2 ML40.6
MLIT.1
MLC-TRAN-DESC-DFLT
Element: Tran Desc Dflt		Alpha 1
The transaction description default. Indicates if the new journal entry is a journal entry header or prior transaction line. Valid values are: J = Journal Entry P = Prior Transaction Line
ML146 ML199
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1
MLC-MX-VALUE
Element: Mx Value		Alpha 32 Occurs 3 Times
Valid transaction attributes display in this field
ML199 ML40.2
MLC-MX-CATEGORY-1
Element: Mx Category 1		Derived
The first attribute category associated with the transaction.
MLC-MX-CATEGORY-2
Element: Mx Category 2		Derived
The second attribute category associated with the transaction.
MLC-MX-CATEGORY-3
Element: Mx Category 3		Derived
The third attribute category associated with the transaction.
MLC-MX-DESC-1
Element: Mx Desc 1		Derived
The description for the first attribute
MLC-MX-DESC-2
Element: Mx Desc 2		Derived
The description for the second attribute
MLC-MX-DESC-3
Element: Mx Desc 3		Derived
The description for the third attribute
MLC-CLOSE-SEQ
Element: Message Seq		Numeric 2
Contains the closing sequence number.
ML146 ML191
ML199 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-JE-APPROVE-FLG
Element: Account Flag		Alpha 1
This field indicates if the journal entry is released.
ML146 ML170
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML41.4
ML44.1 ML45.1
ML75.1
MLC-WF-JE-CTRL-NBR
Element: Wf Je Ctrl Nbr		Derived
The workflow journal entry number.
MLC-AUTO-REV-PD
Element: Auto Rev Pd		Numeric 2
The period auto-reverse flag.
ML146 ML199
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLC-REVERSE
Element: Reverse		Alpha 1
ML190
MLC-HOLD-REM-OPER
Element: Operator		Alpha 10
This field is used to store the login id of the person who entered the record.
ML145 ML40.2
ML45.1
MLC-BLANK
Element: Blankam		Derived
This field consists of blank spaces. It is used to provide column headings on Drill Arounds.


MLCONTROL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLCSET1 LEDGER
COMPANY
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
...
ML110 ML146
ML167 ML170
ML190 ML191
ML196 ML199
ML240 ML241
ML245 ML270
ML290 ML300
ML40.1 ML40.2
ML40.3 ML40.5
ML40.6 ML40.7
ML40.8 ML41.1
ML41.3 ML41.4
ML44.1 ML45.1
ML75.1 ML90.1
ML90.2 MLCC.1
MLCSET2 LEDGER
COMPANY
FISCAL-YEAR
ACCT-PERIOD
STATUS
SYSTEM
CONTROL-GROUP
JE-TYPE
JE-SEQUENCE
KeyChange
ML110 ML146
ML199 ML240
ML45.1
MLCSET3 LEDGER
COMPANY
SYSTEM
FISCAL-YEAR
ACCT-PERIOD
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
KeyChange, Subset
WhereSTATUS =3
ML167
MLCSET4 LEDGER
COMPANY
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
Subset
WhereSTATUS =Zeroes
ML240 ML40.1
ML40.2
MLCSET5 LEDGER
COMPANY
HOLD-CODE
FISCAL-YEAR
ACCT-PERIOD
STATUS
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
KeyChange, Subset
WhereHOLD-CODE !=Spaces
ML145 ML45.1
MLCSET6 LEDGER
COMPANY
FISCAL-YEAR
ACCT-PERIOD
CLOSE-SEQ
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
KeyChange
ML199


MLCONTROL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
MLC-COMPANY->GLS-COMPANY
Glsccat 1 GLSCCAT Not Required
MLC-SOURCE-CODE->GSC-SOURCE-CODE
1->GSC-SEQ-NBR
Glsccat 2 GLSCCAT Not Required
MLC-SOURCE-CODE->GSC-SOURCE-CODE
2->GSC-SEQ-NBR
Glsccat 3 GLSCCAT Not Required
MLC-SOURCE-CODE->GSC-SOURCE-CODE
3->GSC-SEQ-NBR
Glsrccode GLSRCCODE Not Required
MLC-SOURCE-CODE->GSR-SOURCE-CODE
Ledger MLLEDGER Required
MLC-LEDGER->MLL-LEDGER
Mlcalmap MLCALMAP Required
MLC-LEDGER->MCM-LEDGER
MLC-COMPANY->MCM-COMPANY
MLC-FISCAL-YEAR->MCM-FISCAL-YEAR
Mlcucntrl One MLCUCNTRL Not Required
MLC-LEDGER->MCC-LEDGER
MLC-COMPANY->MCC-COMPANY
MLC-FISCAL-YEAR->MCC-FISCAL-YEAR
MLC-ACCT-PERIOD->MCC-ACCT-PERIOD
MLC-SYSTEM->MCC-SYSTEM
MLC-JE-TYPE->MCC-JE-TYPE
MLC-CONTROL-GROUP->MCC-CONTROL-GROUP
MLC-JE-SEQUENCE->MCC-JE-SEQUENCE
1->MCC-AMT-TYPE
GLS-CURR-CODE-1->MCC-CURRENCY-CODE
Mlcucntrl Two MLCUCNTRL Not Required
MLC-LEDGER->MCC-LEDGER
MLC-COMPANY->MCC-COMPANY
MLC-FISCAL-YEAR->MCC-FISCAL-YEAR
MLC-ACCT-PERIOD->MCC-ACCT-PERIOD
MLC-SYSTEM->MCC-SYSTEM
MLC-JE-TYPE->MCC-JE-TYPE
MLC-CONTROL-GROUP->MCC-CONTROL-GROUP
MLC-JE-SEQUENCE->MCC-JE-SEQUENCE
2->MCC-AMT-TYPE
GLS-CURR-CODE-2->MCC-CURRENCY-CODE
Mxcatdef 1 MXCATDEF Required
GSC-MATRIX-CAT->MXC-MATRIX-CAT
Mxcatdef 2 MXCATDEF Not Required
GSC-MATRIX-CAT->MXC-MATRIX-CAT
Mxcatdef 3 MXCATDEF Not Required
GSC-MATRIX-CAT->MXC-MATRIX-CAT
System GLCODES Not Required
MLC-COMPANY->GCD-COMPANY
MLC-SYSTEM->GCD-SYSTEM


MLCONTROL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Mljelog MLJELOG
MLC-LEDGER->MJL-LEDGER
MLC-COMPANY->MJL-COMPANY
MLC-FISCAL-YEAR->MJL-FISCAL-YEAR
MLC-ACCT-PERIOD->MJL-ACCT-PERIOD
MLC-SYSTEM->MJL-SYSTEM
MLC-JE-TYPE->MJL-JE-TYPE
MLC-CONTROL-GROUP->MJL-CONTROL-GROUP
MLC-JE-SEQUENCE->MJL-JE-SEQUENCE
  MJL-LINE-NBR
  MJL-LOG-SEQ-NBR
Mljelog Cntrl MLJELOG
MLC-LEDGER->MJL-LEDGER
MLC-COMPANY->MJL-COMPANY
MLC-FISCAL-YEAR->MJL-FISCAL-YEAR
MLC-ACCT-PERIOD->MJL-ACCT-PERIOD
MLC-SYSTEM->MJL-SYSTEM
MLC-JE-TYPE->MJL-JE-TYPE
MLC-CONTROL-GROUP->MJL-CONTROL-GROUP
MLC-JE-SEQUENCE->MJL-JE-SEQUENCE
Zeroes->MJL-LINE-NBR
  MJL-LOG-SEQ-NBR
Mljelog Line MLJELOG
MLC-LEDGER->MJL-LEDGER
MLC-COMPANY->MJL-COMPANY
MLC-FISCAL-YEAR->MJL-FISCAL-YEAR
MLC-ACCT-PERIOD->MJL-ACCT-PERIOD
MLC-SYSTEM->MJL-SYSTEM
MLC-JE-TYPE->MJL-JE-TYPE
MLC-CONTROL-GROUP->MJL-CONTROL-GROUP
MLC-JE-SEQUENCE->MJL-JE-SEQUENCE
  MJL-LINE-NBR
  MJL-LOG-SEQ-NBR
Mltrans MLTRANS Delete Cascades
MLC-LEDGER->MLT-LEDGER
MLC-COMPANY->MLT-COMPANY
MLC-FISCAL-YEAR->MLT-FISCAL-YEAR
MLC-ACCT-PERIOD->MLT-ACCT-PERIOD
MLC-SYSTEM->MLT-SYSTEM
MLC-JE-TYPE->MLT-JE-TYPE
MLC-CONTROL-GROUP->MLT-CONTROL-GROUP
MLC-JE-SEQUENCE->MLT-JE-SEQUENCE
  MLT-LINE-NBR
  MLT-OBJ-ID

File created: Thu Jun 09 02:23:54 2016

Home
Contact Us



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