MLTRANS FILE
The Multi Book Ledger Transaction file contains the journal entry detail
information to be posted to the Lawson Multi Book Ledger application. The
transactions are not deleted when posted and Multi Ledger History Delete
(ML300) should be run to clear out information no longer needed.
UPDATED BY
GL120 GL310
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLT-LEDGER Alpha 15
Ledger The ledger to which journal entries are
posted.
MLT-COMPANY Numeric 4
Company The company to which journal entries
are posted. It must be defined as a
ledger company on Ledger Setup (ML10.1).
MLT-FISCAL-YEAR Numeric 4
Fiscal Year The year for which the journal entry is
posted.
MLT-ACCT-PERIOD Numeric 2
Account Period The period for which the journal entry
is posted.
MLT-CONTROL-GROUP Numeric 8
Control Groups This field contains the journal entry
number used for process control of the
journal entry detail.
MLT-SYSTEM Alpha 2
System Code The system code associated with the
journal entry.
MLT-JE-TYPE Alpha 1
Journal Entry Type The journal entry type (Normal or
Intercompany).
MLT-JE-TYPE-1 Derived
Journal Entry Type The derived journal entry type.
MLT-JE-SEQUENCE Numeric 2
Journal Entry The journal entry sequence number.
Sequence Number
MLT-LINE-NBR Numeric 6
Line Number The journal entry line number.
MLT-OBJ-ID Numeric 12
Object Contains the object ID sequence
Identification number. Ensures that the subsystem
transaction is sent to the Lawson Multi
Book Ledger application.
MLT-STATUS Numeric 1
Status This field displays the status of the
transaction.
MLT-VAR-LEVELS Alpha 30 GL120
Variable Levels The variable level to which the journal
entry is posted. A level represents the
location of an accounting unit in an
organization's level structure.
MLT-ACCT-UNIT Alpha 15
Accounting Unit The accounting unit to which the
journal entry is posted.
MLT-ACCOUNT Numeric 6
Account The account to which the journal entry
is posted.
MLT-SUB-ACCOUNT Numeric 4
Subaccount The subaccount to which the journal
entry is posted.
MLT-SOURCE-CODE Alpha 2
Source Code A two-character code assigned to a
transaction to identify where the
transaction was created (for example,
ME).
MLT-DATE Numeric 8 (yyyymmdd)
Date Contains the system creation date.
MLT-REFERENCE Alpha 10 (Lower Case)
Reference Displays the reference number
associated with the transaction.
MLT-DESCRIPTION Alpha 30 (Lower Case)
Description Displays the transaction description.
MLT-SHORT-DESC Derived
Short Desc Contains the transaction short
description.
MLT-BASE-AMOUNT Signed 15.2
Base Amount Displays the transaction amount in base
currency.
MLT-BASE-ND Numeric 1
Base Number Of Indicates the number of positions
Decimals defined for the company base currency.
MLT-UNITS-AMOUNT Signed 15.2
Units Amount Displays the units amount associated
with the transaction.
MLT-AUTO-REV Alpha 1
Auto Reverse When the Auto Reversal field is set to
Yes, the Ledger Period Closing (ML199)
creates an opposite entry for this
transaction in the next period.
MLT-TO-COMPANY Numeric 4
To Company The company number to which the
transaction line is posted.
MLT-BASE-ZONE Alpha 15
Base Zone The zone within the Lawson General
Ledger application where the transaction
originated.
MLT-POSTING-DATE Numeric 8 (yyyymmdd)
Posting Date The date assigned to the journal entry
for posting.
MLT-CURRENCY-CODE Alpha 5
Transaction Currency This field displays the transaction
currency code used for the journal
entry.
MLT-BASERATE Signed 12.6
Exchange Rate This field displays the exchange rate
from the transaction currency to the
company base currency.
MLT-TRAN-AMOUNT Signed 15.2
Transaction This field displays the amount in
Currency Amount transaction currency to be posted.
MLT-TRAN-ND Numeric 1
Transaction Number Indicates the number of positions
of Decimals defined for the transaction currency.
MLT-ACCT-CURRENCY Alpha 5
Account Currency This is the account currency, if
applicable.
MLT-ACCT-RATE Signed 12.6
Account Rate This is the exchange rate from the
transaction currency to the account
currency.
MLT-ACCT-AMOUNT Signed 15.2
Account Amount The transaction amount in account
currency.
MLT-ACCT-ND Numeric 1
Account Currency Indicates the number of positions
Code defined for the account currency.
MLT-ORIG-COMPANY Numeric 4
Orig Company The originating company number.
MLT-ORIG-PROGRAM Alpha 5
Program of Origin The originating program number.
MLT-OPERATOR Alpha 10
Operator Code This field is used to store the login
ID of the person who entered the record.
MLT-TO-BASE-AMT Signed 15.2
To Company Base To company base amount
Amount
MLT-TO-BASE-ND Numeric 1
To Base Number Of To company base number of decimals.
Decimals
MLT-TO-BASERATE Signed 12.6
Exchange Rate To company base currency exchange rate.
MLT-TO-BASE-CURR Alpha 5
To Company Base To company base currency.
Currency
MLT-RECONCILE Alpha 2
Reconcile Indicates the reconciliation
transactions.
MLT-NEGATIVE-ADJ Alpha 1
Negative Adjustment Indicates a negative adjustment.
MLT-UPDATE-DATE Numeric 8 (yyyymmdd)
Update Date This field contains the date the record
was posted. Used by Average Daily
Balance to track day-to-day activity
changes.
MLT-SEQ-TRNS-NBR Numeric 10
Seq Trns Nbr Contains the journal entry transaction
sequence number.
MLT-JBK-TRNS-NBR Numeric 10
JB Transaction Contains the journal book transaction
Number sequence number.
MLT-CT-FR-COMPANY Numeric 4
Ct Fr Company This is the company whose currency was
converted using Intercompany Chart Map
Posting (GL135).
MLT-RPT-AMOUNT-1 Signed 15.2 GL310
Report Currency 1 The transaction amount for Report
Amount Currency 1.
MLT-RPT-RATE-1 Signed 12.6 GL310
Rpt Rate 1 The exchange rate to convert the
transaction to report currency 1.
MLT-RPT-ND-1 Numeric 1 GL310
Rpt Nd 1 The number of decimal positions for
Report Currency 1.
MLT-RPT-AMOUNT-2 Signed 15.2 GL310
Report Currency 2 The transaction amount for Report
Amount Currency 2.
MLT-RPT-RATE-2 Signed 12.6 GL310
Rpt Rate 2 The exchange rate to convert the
transaction to report currency 2.
MLT-RPT-ND-2 Numeric 1 GL310
Rpt Nd 2 The number of decimal positions for
Report Currency 2.
MLTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLTSET1 OBJ-ID
MLTSET2 LEDGER GL310
COMPANY
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
LINE-NBR
OBJ-ID
MLTSET3 LEDGER KeyChange, Subset
TO-COMPANY Where STATUS != 8
FISCAL-YEAR
ACCT-PERIOD
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
OBJ-ID
MLTSET4 LEDGER Subset GL120
TO-COMPANY Where STATUS != 8
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
FISCAL-YEAR
ACCT-PERIOD
OBJ-ID
MLTSET7 LEDGER Subset
TO-COMPANY Where STATUS != 8
FISCAL-YEAR
ACCT-PERIOD
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
OBJ-ID
MLTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Required
MLT-TO-COMPANY -> GLM-COMPANY (GLMSET2)
MLT-ACCT-UNIT -> GLM-ACCT-UNIT
MLT-ACCOUNT -> GLM-ACCOUNT
MLT-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
Company GLSYSTEM Required
MLT-COMPANY -> GLS-COMPANY
Glsrccode GLSRCCODE Required
MLT-SOURCE-CODE -> GSR-SOURCE-CODE
Glsystem GLSYSTEM Required
MLT-COMPANY -> GLS-COMPANY
Mlcoledger MLCOLEDGER Required
MLT-LEDGER -> MLE-LEDGER
MLT-COMPANY -> MLE-COMPANY
MLTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mltrans MLTRANS
MLT-LEDGER -> MLT-LEDGER
MLT-COMPANY -> MLT-COMPANY
MLT-FISCAL-YEAR -> MLT-FISCAL-YEAR
MLT-ACCT-PERIOD -> MLT-ACCT-PERIOD
MLT-SYSTEM -> MLT-SYSTEM
MLT-JE-TYPE -> MLT-JE-TYPE
MLT-CONTROL-GROUP -> MLT-CONTROL-GROUP
MLT-JE-SEQUENCE -> MLT-JE-SEQUENCE
MLT-LINE-NBR
MLT-OBJ-ID
|
