Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MLTRANS


                              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
Element: Ledger        The ledger to which journal entries are
                       posted.

MLT-COMPANY            Numeric 4
Element: 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
Element: Last Closed YeThe year for which the journal entry is
                       posted.

MLT-ACCT-PERIOD        Numeric 2
Element: Current PeriodThe period for which the journal entry
                       is posted.

MLT-CONTROL-GROUP      Numeric 8
Element: Control GroupsThis field contains the journal entry
                       number used for process control of the
                       journal entry detail.

MLT-SYSTEM             Alpha 2
Element: System Code   The system code associated with the
                       journal entry.

MLT-JE-TYPE            Alpha 1
Element: Journal Entry The journal entry type (Normal or
                       Intercompany).

MLT-JE-TYPE-1          Derived
Element: Journal Entry The derived journal entry type.

MLT-JE-SEQUENCE        Numeric 2
Journal Entry          The journal entry sequence number.
Sequence Number

MLT-LINE-NBR           Numeric 6
Element: Line Number   The journal entry line number.

MLT-OBJ-ID             Numeric 12
Object                 Contains the object ID sequence number
Identification         for the transaction.

MLT-STATUS             Numeric 1
Element: Status        This field displays the status of the
                       transaction.

MLT-VAR-LEVELS         Alpha 30                                  GL120
Element: New 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
Element: Accounting UniThe accounting unit to which the
                       journal entry is posted.

MLT-ACCOUNT            Numeric 6
Element: Account       The account to which the journal entry
                       is posted.

MLT-SUB-ACCOUNT        Numeric 4
Element: Subaccount    The subaccount to which the journal
                       entry is posted.

MLT-SOURCE-CODE        Alpha 2
Element: 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)
Element: Date          Contains the system creation date.

MLT-REFERENCE          Alpha 10  (Lower Case)
Element: Requester     Displays the reference number
                       associated with the transaction.

MLT-DESCRIPTION        Alpha 30  (Lower Case)
Element: Description   Displays the transaction description.

MLT-SHORT-DESC         Derived
Element: Short Desc    Contains the transaction short
                       description.

MLT-BASE-AMOUNT        Signed 15.2
Element: Adj Amt       Displays the transaction amount in base
                       currency.

MLT-BASE-ND            Numeric 1
Account Currency       Indicates the number of positions
Code                   defined for the company base currency.

MLT-UNITS-AMOUNT       Signed 15.2
Element: Adj Amt       Displays the units amount associated
                       with the transaction.

MLT-AUTO-REV           Alpha 1
Element: 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
Element: Company       The company number to which the
                       transaction line is posted.

MLT-BASE-ZONE          Alpha 15
Element: Zone          The zone within the Lawson General
                       Ledger application where the transaction
                       originated.

MLT-POSTING-DATE       Numeric 8  (yyyymmdd)
Element: Date          The date assigned to the journal entry
                       for posting.

MLT-CURRENCY-CODE      Alpha 5
Element: Transaction CuThis field displays the transaction
                       currency code used for the journal
                       entry.

MLT-BASERATE           Signed 12.6
Element: Account 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
Account Currency       Indicates the number of positions
Code                   defined for the transaction currency.

MLT-ACCT-CURRENCY      Alpha 5
Element: Account CurrenThis is the account currency, if
                       applicable.

MLT-ACCT-RATE          Signed 12.6
Element: Account Rate  This is the exchange rate from the
                       transaction currency to the account
                       currency.

MLT-ACCT-AMOUNT        Signed 15.2
Element: Adj Amt       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
Element: Company       The originating company number.

MLT-ORIG-PROGRAM       Alpha 5
Element: Program       The originating program number.

MLT-OPERATOR           Alpha 10
Element: 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
Element: Adj Amt       To company base amount

MLT-TO-BASE-ND         Numeric 1
Account Currency       To company base number of decimals.
Code

MLT-TO-BASERATE        Signed 12.6
Element: Account 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
Element: Reconcile     Indicates the reconciliation
                       transactions.

MLT-NEGATIVE-ADJ       Alpha 1
Element: Negative AdjusIndicates a negative adjustment.

MLT-UPDATE-DATE        Numeric 8  (yyyymmdd)
Element: Date          This field contains the date the record
                       was posted.

MLT-SEQ-TRNS-NBR       Numeric 10
Element: Seq Trns Nbr  Contains the journal entry transaction
                       sequence number.

MLT-JBK-TRNS-NBR       Numeric 10
Element: Seq Trns Nbr  Contains the journal book transaction
                       sequence number.

MLT-CT-FR-COMPANY      Numeric 4
Element: Ct Fr Company Not used.

MLT-RPT-AMOUNT-1       Signed 15.2                               GL310
Element: Adj Amt       The transaction amount for Report
                       Currency 1.

MLT-RPT-RATE-1         Signed 12.6                               GL310
Element: Rpt Rate 1    The exchange rate to convert the
                       transaction to report currency 1.

MLT-RPT-ND-1           Numeric 1                                 GL310
Account Currency       The number of decimal positions for
Code                   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
Element: Rpt Rate 1    The exchange rate to convert the
                       transaction to report currency 2.

MLT-RPT-ND-2           Numeric 1                                 GL310
Element: 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        KeyChange                                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        KeyChange, Subset                        GL120
          TO-COMPANY    Where STATUS != 8
          ACCOUNT
          SUB-ACCOUNT
          ACCT-UNIT
          FISCAL-YEAR
          ACCT-PERIOD
          OBJ-ID

MLTSET7   LEDGER        KeyChange, 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