MLTRANS

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.

REFERENCED BY
ML12.1 ML145 ML170 ML241 ML41.1 ML41.3
ML290 ML325 ML327


UPDATED BY
GL120 GL310 ML10.1 ML110 ML146 ML167
ML190 ML191 ML196 ML199 ML240 ML300
ML40.1 ML40.2 ML40.3 ML40.5 ML40.6 ML40.7
ML40.8 ML44.1 ML45.1 ML90.4 MLIT.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLT-LEDGER
Element: Ledger		Alpha 15
The ledger to which journal entries are posted.
ML110 ML146
ML167 ML190
ML191 ML196
ML199 ML290
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-COMPANY
Element: Company		Numeric 4
The company to which journal entries are posted. It must be defined as a ledger company on Ledger Setup (ML10.1).
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-FISCAL-YEAR
Element: Year		Numeric 4
The year for which the journal entry is posted.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-ACCT-PERIOD
Element: Acct Period		Numeric 2
The period for which the journal entry is posted.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-CONTROL-GROUP
Element: Control Group		Numeric 8
This field contains the journal entry number used for process control of the journal entry detail.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-SYSTEM
Element: System		Alpha 2
The system code associated with the journal entry.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-JE-TYPE
Element: Je Type		Alpha 1
The journal entry type (Normal or Intercompany).
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-JE-TYPE-1
Element: Je Type 1		Derived
The derived journal entry type.
MLT-JE-SEQUENCE
Element: Je Sequence		Numeric 2
The journal entry sequence number.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-LINE-NBR
Element: Line Nbr		Numeric 6
The journal entry line number.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-OBJ-ID
Element: Obj Id		Numeric 12
Contains the object ID sequence number for the transaction.
ML110 ML146
ML167 ML190
ML191 ML196
ML199 ML290
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-STATUS
Element: Status		Numeric 1
This field displays the status of the transaction.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-VAR-LEVELS
Element: Var Levels		Alpha 30
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.
GL120 ML146
ML167 ML190
ML191 ML196
ML199 ML290
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-ACCT-UNIT
Element: Acct Unit		Alpha 15
The accounting unit to which the journal entry is posted.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-ACCOUNT
Element: Account		Numeric 6
The account to which the journal entry is posted.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-SUB-ACCOUNT
Element: Sub Acct		Numeric 4
The subaccount to which the journal entry is posted.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-SOURCE-CODE
Element: Source Code		Alpha 2
A two-character code assigned to a transaction to identify where the transaction was created (for example, ME).
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-DATE
Element: Date		Numeric 8 (yyyymmdd)
Contains the system creation date.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-REFERENCE
Element: Reference		Alpha 10 (Lower Case)
Displays the reference number associated with the transaction.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
Displays the transaction description.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-SHORT-DESC
Element: Short Desc		Derived
Contains the transaction short description.
MLT-BASE-AMOUNT
Element: Intl Amt		Signed 18.2
Displays the transaction amount in base currency.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.5 ML40.6
ML40.7 ML40.8
ML41.3 ML44.1
ML45.1 ML90.1
ML90.2 ML90.4
MLIT.1
MLT-BASE-ND
Element: Base Nd		Numeric 1
Indicates the number of positions defined for the company base currency.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-UNITS-AMOUNT
Element: Units Amount		Signed 15.2
Displays the units amount associated with the transaction.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.5 ML40.6
ML40.7 ML40.8
ML41.3 ML44.1
ML45.1 ML90.1
ML90.2 ML90.5
MLIT.1
MLT-AUTO-REV
Element: Auto Rev		Alpha 1
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.
ML146 ML167
ML190 ML191
ML199 ML290
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-TO-COMPANY
Element: Company		Numeric 4
The company number to which the transaction line is posted.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-BASE-ZONE
Element: Zone		Alpha 15
The zone within the Lawson General Ledger application where the transaction originated.
ML146 ML167
ML190 ML191
ML290 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-POSTING-DATE
Element: Posting Date		Numeric 8 (yyyymmdd)
The date assigned to the journal entry for posting.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-CURRENCY-CODE
Element: Transaction Currency		Alpha 5
This field displays the transaction currency code used for the journal entry.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-BASERATE
Element: Curr Rate		Signed 14.7
This field displays the exchange rate from the transaction currency to the company base currency.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-TRAN-AMOUNT
Transaction
Currency Amount		Signed 18.2
This field displays the amount in transaction currency to be posted.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.5 ML40.6
ML40.7 ML40.8
ML41.3 ML44.1
ML45.1 ML90.1
ML90.2 ML90.4
ML90.5 MLIT.1
MLT-TRAN-ND
Element: Acct Nd		Numeric 1
Indicates the number of positions defined for the transaction currency.
ML146 ML167
ML190 ML191
ML196 ML199
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-ACCT-CURRENCY
Element: Currency Code		Alpha 5
This is the account currency, if applicable.
ML146 ML167
ML190 ML191
ML196 ML290
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-ACCT-RATE
Element: Curr Rate		Signed 14.7
This is the exchange rate from the transaction currency to the account currency.
ML146 ML167
ML190 ML191
ML196 ML290
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-ACCT-AMOUNT
Element: Intl Amt		Signed 18.2
The transaction amount in account currency.
ML146 ML167
ML190 ML191
ML196 ML290
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
ML90.1 ML90.2
MLIT.1
MLT-ACCT-ND
Element: Acct Nd		Numeric 1
Indicates the number of positions defined for the account currency.
ML146 ML167
ML190 ML191
ML196 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-ORIG-COMPANY
Element: Company		Numeric 4
The originating company number.
ML146 ML167
ML190 ML191
ML196 ML199
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-ORIG-PROGRAM
Element: Program		Alpha 5
The originating program number.
ML146 ML167
ML191 ML196
ML290 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-OPERATOR
Element: Operator		Alpha 10
This field is used to store the login ID of the person who entered the record.
ML146 ML167
ML190 ML191
ML196 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-TO-BASE-AMT
Element: Intl Amt		Signed 18.2
To company base amount
ML146 ML40.1
ML40.2 ML40.3
ML40.5 ML40.6
ML40.7 ML40.8
ML41.3 ML44.1
ML45.1 ML90.2
MLIT.1
MLT-TO-BASE-ND
Element: Acct Nd		Numeric 1
To company base number of decimals.
ML146 ML240
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-TO-BASERATE
Element: Curr Rate		Signed 14.7
To company base currency exchange rate.
ML146 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-TO-BASE-CURR
Element: Currency Code		Alpha 5
To company base currency.
ML146 ML167
ML190 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-RECONCILE
Element: Reconcile		Alpha 2
Indicates the reconciliation transactions.
ML290 ML90.4
MLT-NEGATIVE-ADJ
Element: Negative Adj		Alpha 1
Indicates a negative adjustment.
ML146 ML167
ML190 ML196
ML290 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-UPDATE-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field contains the date the record was posted.
ML146 ML190
ML199 ML290
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1
MLT-SEQ-TRNS-NBR
Element: Seq Trns Nbr		Numeric 10
Contains the journal entry transaction sequence number.
ML146 ML190
ML199 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLT-JBK-TRNS-NBR
Element: Jbk Trns Nbr		Numeric 10
Contains the journal book transaction sequence number.
ML146 ML190
ML199 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLT-RPT-AMOUNT-1
Element: Intl Amt		Signed 18.2
The transaction amount for Report Currency 1.
GL310 ML146
ML167 ML190
ML191 ML196
ML199 ML290
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
ML90.1 ML90.2
ML90.4 MLIT.1
MLT-RPT-RATE-1
Element: Curr Rate		Signed 14.7
The exchange rate to convert the transaction to report currency 1.
GL310 ML146
ML167 ML190
ML191 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-RPT-ND-1
Element: Acct Nd		Numeric 1
The number of decimal positions for Report Currency 1.
GL310 ML146
ML167 ML190
ML191 ML196
ML199 ML290
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1
MLT-RPT-AMOUNT-2
Element: Intl Amt		Signed 18.2
The transaction amount for Report Currency 2.
GL310 ML146
ML167 ML190
ML191 ML196
ML199 ML290
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
ML90.1 ML90.2
ML90.4 MLIT.1
MLT-RPT-RATE-2
Element: Curr Rate		Signed 14.7
The exchange rate to convert the transaction to report currency 2.
GL310 ML146
ML167 ML190
ML191 ML199
ML290 ML40.1
ML40.2 ML40.3
ML40.6 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLT-RPT-ND-2
Element: Acct Nd		Numeric 1
The number of decimal positions for Report Currency 2.
GL310 ML146
ML167 ML190
ML191 ML196
ML199 ML290
ML40.1 ML40.2
ML40.3 ML40.6
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1


MLTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLTSET1 OBJ-ID
ML146 ML190
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1 MLIT.1
MLTSET2 LEDGER
COMPANY
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
LINE-NBR
OBJ-ID
KeyChange
GL310 ML10.1
ML110 ML12.1
ML145 ML146
ML170 ML190
ML191 ML199
ML240 ML241
ML300 ML40.1
ML40.2 ML40.3
ML40.5 ML40.6
ML40.7 ML40.8
ML41.1 ML41.3
ML44.1 ML45.1
ML90.4 MLIT.1
MLTSET3 LEDGER
TO-COMPANY
FISCAL-YEAR
ACCT-PERIOD
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
OBJ-ID
KeyChange, Subset
WhereSTATUS !=8
GL120 ML199
ML290 ML325
ML327
MLTSET4 LEDGER
TO-COMPANY
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
FISCAL-YEAR
ACCT-PERIOD
OBJ-ID
KeyChange, Subset
WhereSTATUS !=8
GL120 ML90.1
ML90.2 ML90.4
ML90.5
MLTSET7 LEDGER
TO-COMPANY
FISCAL-YEAR
ACCT-PERIOD
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
OBJ-ID
KeyChange, Subset
WhereSTATUS !=8
ML290


MLTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Required
MLT-TO-COMPANY->GLM-COMPANY
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
Mlcontrol MLCONTROL Required
MLT-LEDGER->MLC-LEDGER
MLT-COMPANY->MLC-COMPANY
MLT-FISCAL-YEAR->MLC-FISCAL-YEAR
MLT-ACCT-PERIOD->MLC-ACCT-PERIOD
MLT-SYSTEM->MLC-SYSTEM
MLT-JE-TYPE->MLC-JE-TYPE
MLT-CONTROL-GROUP->MLC-CONTROL-GROUP
MLT-JE-SEQUENCE->MLC-JE-SEQUENCE
Mlrjcntrl MLRJCNTRL Not Required
MLT-LEDGER->MRC-LEDGER
MLT-COMPANY->MRC-COMPANY
MLT-JE-TYPE->MRC-JE-TYPE
MLT-CONTROL-GROUP->MRC-REC-GROUP


MLTRANS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Mlmxvalue MLMXVALUE Delete Cascades
MLT-OBJ-ID->MLV-OBJ-ID
  MLV-MATRIX-CAT
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

File created: Thu Jun 09 11:21:17 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.