Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MLTRANS


                              MLTRANS FILE

                            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             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: Year          The year for which the journal entry is
                       posted.

MLT-ACCT-PERIOD        Numeric 2
Element: Acct Period   The period for which the journal entry
                       is posted.

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

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

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

MLT-JE-TYPE-1          Derived
Element: Je Type 1     The derived journal entry type.

MLT-JE-SEQUENCE        Numeric 2
Element: Je Sequence   The journal entry sequence number.

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

MLT-OBJ-ID             Numeric 12
Element: Obj Id        Contains the object ID sequence number
                       for the transaction.

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

MLT-VAR-LEVELS         Alpha 30                                  GL120
Element: Var 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: Acct Unit     The 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: Sub Acct      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: Reference     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 18.2
Element: Intl Amt      Displays the transaction amount in base
                       currency.

MLT-BASE-ND            Numeric 1
Element: Base Nd       Indicates the number of positions
                       defined for the company base currency.

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

MLT-AUTO-REV           Alpha 1
Element: Auto Rev      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: Posting 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 14.7
Element: Curr Rate     This field displays the exchange rate
                       from the transaction currency to the
                       company base currency.

MLT-TRAN-AMOUNT        Signed 18.2
Transaction            This field displays the amount in
Currency Amount        transaction currency to be posted.

MLT-TRAN-ND            Numeric 1
Element: Acct Nd       Indicates the number of positions
                       defined for the transaction currency.

MLT-ACCT-CURRENCY      Alpha 5
Element: Currency Code This is the account currency, if
                       applicable.

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

MLT-ACCT-AMOUNT        Signed 18.2
Element: Intl Amt      The transaction amount in account
                       currency.

MLT-ACCT-ND            Numeric 1
Element: Acct Nd       Indicates the number of positions
                       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      This field is used to store the login
                       ID of the person who entered the record.

MLT-TO-BASE-AMT        Signed 18.2
Element: Intl Amt      To company base amount

MLT-TO-BASE-ND         Numeric 1
Element: Acct Nd       To company base number of decimals.

MLT-TO-BASERATE        Signed 14.7
Element: Curr Rate     To company base currency exchange rate.

MLT-TO-BASE-CURR       Alpha 5
Element: Currency Code To company base currency.

MLT-RECONCILE          Alpha 2
Element: Reconcile     Indicates the reconciliation
                       transactions.

MLT-NEGATIVE-ADJ       Alpha 1
Element: Negative Adj  Indicates 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: Jbk Trns Nbr  Contains the journal book transaction
                       sequence number.

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

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

MLT-RPT-ND-1           Numeric 1                                 GL310
Element: Acct Nd       The number of decimal positions for
                       Report Currency 1.

MLT-RPT-AMOUNT-2       Signed 18.2                               GL310
Element: Intl Amt      The transaction amount for Report
                       Currency 2.

MLT-RPT-RATE-2         Signed 14.7                               GL310
Element: Curr Rate     The exchange rate to convert the
                       transaction to report currency 2.

MLT-RPT-ND-2           Numeric 1                                 GL310
Element: Acct Nd       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                        GL120
          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