|
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
|