ML Transactions

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 Element: Ledger	Alpha 15 The ledger to which journal entries are posted.
MLT-COMPANY Element: Company	Numeric 4 The company to which journal entries are posted. It must be defined as a ledger company on Ledger Setup (ML10.1).
MLT-FISCAL-YEAR Element: Year	Numeric 4 The year for which the journal entry is posted.
MLT-ACCT-PERIOD Element: Acct Period	Numeric 2 The period for which the journal entry is posted.
MLT-CONTROL-GROUP Element: Control Group	Numeric 8 This field contains the journal entry number used for process control of the journal entry detail.
MLT-SYSTEM Element: System	Alpha 2 The system code associated with the journal entry.
MLT-JE-TYPE Element: Je Type	Alpha 1 The journal entry type (Normal or Intercompany).
MLT-JE-TYPE-1 Element: Je Type 1	Derived The derived journal entry type.
MLT-JE-SEQUENCE Element: Je Sequence	Numeric 2 The journal entry sequence number.
MLT-LINE-NBR Element: Line Nbr	Numeric 6 The journal entry line number.
MLT-OBJ-ID Element: Obj Id	Numeric 12 Contains the object ID sequence number for the transaction.
MLT-STATUS Element: Status	Numeric 1 This field displays the status of the transaction.
MLT-VAR-LEVELS Element: Var Levels	Alpha 30 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.	GL120
MLT-ACCT-UNIT Element: Acct Unit	Alpha 15 The accounting unit to which the journal entry is posted.
MLT-ACCOUNT Element: Account	Numeric 6 The account to which the journal entry is posted.
MLT-SUB-ACCOUNT Element: Sub Acct	Numeric 4 The subaccount to which the journal entry is posted.
MLT-SOURCE-CODE Element: Source Code	Alpha 2 A two-character code assigned to a transaction to identify where the transaction was created (for example, ME).
MLT-DATE Element: Date	Numeric 8 (yyyymmdd) Contains the system creation date.
MLT-REFERENCE Element: Reference	Alpha 10 (Lower Case) Displays the reference number associated with the transaction.
MLT-DESCRIPTION Element: Description	Alpha 30 (Lower Case) Displays the transaction description.
MLT-SHORT-DESC Element: Short Desc	Derived Contains the transaction short description.
MLT-BASE-AMOUNT Element: Intl Amt	Signed 18.2 Displays the transaction amount in base currency.
MLT-BASE-ND Element: Base Nd	Numeric 1 Indicates the number of positions defined for the company base currency.
MLT-UNITS-AMOUNT Element: Units Amount	Signed 15.2 Displays the units amount associated with the transaction.
MLT-AUTO-REV Element: Auto Rev	Alpha 1 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 Element: Company	Numeric 4 The company number to which the transaction line is posted.
MLT-BASE-ZONE Element: Zone	Alpha 15 The zone within the Lawson General Ledger application where the transaction originated.
MLT-POSTING-DATE Element: Posting Date	Numeric 8 (yyyymmdd) The date assigned to the journal entry for posting.
MLT-CURRENCY-CODE Element: Transaction Currency	Alpha 5 This field displays the transaction currency code used for the journal entry.
MLT-BASERATE Element: Curr Rate	Signed 14.7 This field displays the exchange rate from the transaction currency to the company base currency.
MLT-TRAN-AMOUNT Transaction Currency Amount	Signed 18.2 This field displays the amount in transaction currency to be posted.
MLT-TRAN-ND Element: Acct Nd	Numeric 1 Indicates the number of positions defined for the transaction currency.
MLT-ACCT-CURRENCY Element: Currency Code	Alpha 5 This is the account currency, if applicable.
MLT-ACCT-RATE Element: Curr Rate	Signed 14.7 This is the exchange rate from the transaction currency to the account currency.
MLT-ACCT-AMOUNT Element: Intl Amt	Signed 18.2 The transaction amount in account currency.
MLT-ACCT-ND Element: Acct Nd	Numeric 1 Indicates the number of positions defined for the account currency.
MLT-ORIG-COMPANY Element: Company	Numeric 4 The originating company number.
MLT-ORIG-PROGRAM Element: Program	Alpha 5 The originating program number.
MLT-OPERATOR Element: Operator	Alpha 10 This field is used to store the login ID of the person who entered the record.
MLT-TO-BASE-AMT Element: Intl Amt	Signed 18.2 To company base amount
MLT-TO-BASE-ND Element: Acct Nd	Numeric 1 To company base number of decimals.
MLT-TO-BASERATE Element: Curr Rate	Signed 14.7 To company base currency exchange rate.
MLT-TO-BASE-CURR Element: Currency Code	Alpha 5 To company base currency.
MLT-RECONCILE Element: Reconcile	Alpha 2 Indicates the reconciliation transactions.
MLT-NEGATIVE-ADJ Element: Negative Adj	Alpha 1 Indicates a negative adjustment.
MLT-UPDATE-DATE Element: Date	Numeric 8 (yyyymmdd) This field contains the date the record was posted.
MLT-SEQ-TRNS-NBR Element: Seq Trns Nbr	Numeric 10 Contains the journal entry transaction sequence number.
MLT-JBK-TRNS-NBR Element: Jbk Trns Nbr	Numeric 10 Contains the journal book transaction sequence number.
MLT-RPT-AMOUNT-1 Element: Intl Amt	Signed 18.2 The transaction amount for Report Currency 1.	GL310
MLT-RPT-RATE-1 Element: Curr Rate	Signed 14.7 The exchange rate to convert the transaction to report currency 1.	GL310
MLT-RPT-ND-1 Element: Acct Nd	Numeric 1 The number of decimal positions for Report Currency 1.	GL310
MLT-RPT-AMOUNT-2 Element: Intl Amt	Signed 18.2 The transaction amount for Report Currency 2.	GL310
MLT-RPT-RATE-2 Element: Curr Rate	Signed 14.7 The exchange rate to convert the transaction to report currency 2.	GL310
MLT-RPT-ND-2 Element: Acct Nd	Numeric 1 The number of decimal positions for Report Currency 2.	GL310

MLTRANS FILE INDEX

MLTRANS FILE RELATIONS

ONE TO ONE RELATIONS

MLTRANS FILE RELATIONS

ONE TO MANY RELATIONS

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