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