|
|
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: Last Closed YeThe year for which the journal entry is
posted.
MLT-ACCT-PERIOD Numeric 2
Element: Account 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: Variable LevelThe 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: 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
Base Number Of Indicates the number of positions
Decimals 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 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: 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: Currency 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
Account Currency Indicates the number of positions
Code 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: Currency 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
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 18.2
Element: Intl Amt To company base amount
MLT-TO-BASE-ND Numeric 1
Account Currency To company base number of decimals.
Code
MLT-TO-BASERATE Signed 14.7
Element: Currency 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 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
JB Transaction Contains the journal book transaction
Number 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: Currency Rate 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 18.2 GL310
Element: Intl Amt The transaction amount for Report
Currency 2.
MLT-RPT-RATE-2 Signed 14.7 GL310
Element: Currency Rate The exchange rate to convert the
transaction to report currency 2.
MLT-RPT-ND-2 Numeric 1 GL310
Account Currency The number of decimal positions for
Code 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
|
