MLTRANS – ML Transactions

System: Multi-Ledger (ML)
Prefix: MLT
Primary key: OBJ-ID
Fields: 54
Updated by: 20 programs
Referenced by: 11 programs

MLTRANS is the ML Transactions table in Lawson Multi-Ledger (prefix MLT). It is indexed by OBJ-ID (MLTSET1); alternate indexes: MLTSET2, MLTSET3, MLTSET4 and MLTSET7. It is related 1:1 to GLMASTER, GLSYSTEM, GLSRCCODE, MLCOLEDGER, MLCONTROL and MLRJCNTRL and 1:M to MLMXVALUE and MLTRANS. It is updated by GL120, GL310, ML110, ML146, ML167, ML190, ML191, ML196 and 12 more and referenced by ML10.1, ML12.1, ML145, ML170, ML240, ML241, ML290, ML325 and 3 more. The table has 54 fields, 5 indexes and 9 documented relations.

About MLTRANS

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.

Fields (54)

Column = COBOL field name without the MLT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`MLT-LEDGER` LEDGER	Alpha 15	The ledger to which journal entries are posted.	ML110, ML146, ML167, ML190, ML191, ML196, ML199, ML290 +9 more
`MLT-COMPANY` 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 +8 more
`MLT-FISCAL-YEAR` FISCAL_YEAR	Numeric 4	The year for which the journal entry is posted.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
`MLT-ACCT-PERIOD` ACCT_PERIOD	Numeric 2	The period for which the journal entry is posted.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
`MLT-CONTROL-GROUP` 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 +8 more
`MLT-SYSTEM` SYSTEM	Alpha 2	The system code associated with the journal entry.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
`MLT-JE-TYPE` JE_TYPE	Alpha 1	The journal entry type (Normal or Intercompany).	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
`MLT-JE-TYPE-1` JE_TYPE_1	Derived	The derived journal entry type.	—
`MLT-JE-SEQUENCE` JE_SEQUENCE	Numeric 2	The journal entry sequence number.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
`MLT-LINE-NBR` LINE_NBR	Numeric 6	The journal entry line number.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +7 more
`MLT-OBJ-ID` PK OBJ_ID	Numeric 12	Contains the object ID sequence number for the transaction.	ML110, ML146, ML167, ML190, ML191, ML196, ML199, ML290 +9 more
`MLT-STATUS` STATUS	Numeric 1	This field displays the status of the transaction.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
`MLT-VAR-LEVELS` 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 +8 more
`MLT-ACCT-UNIT` ACCT_UNIT	Alpha 15	The accounting unit to which the journal entry is posted.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +7 more
`MLT-ACCOUNT` ACCOUNT	Numeric 6	The account to which the journal entry is posted.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +7 more
`MLT-SUB-ACCOUNT` SUB_ACCOUNT	Numeric 4	The subaccount to which the journal entry is posted.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +7 more
`MLT-SOURCE-CODE` 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 +7 more
`MLT-DATE` DATE	Numeric 8 (yyyymmdd)	Contains the system creation date.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
`MLT-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	Displays the reference number associated with the transaction.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
`MLT-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	Displays the transaction description.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
`MLT-SHORT-DESC` SHORT_DESC	Derived	Contains the transaction short description.	—
`MLT-BASE-AMOUNT` BASE_AMOUNT	Signed 18.2	Displays the transaction amount in base currency.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +13 more
`MLT-BASE-ND` BASE_ND	Numeric 1	Indicates the number of positions defined for the company base currency.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +7 more
`MLT-UNITS-AMOUNT` UNITS_AMOUNT	Signed 15.2	Displays the units amount associated with the transaction.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +13 more
`MLT-AUTO-REV` 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 +6 more
`MLT-TO-COMPANY` TO_COMPANY	Numeric 4	The company number to which the transaction line is posted.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
`MLT-BASE-ZONE` BASE_ZONE	Alpha 15	The zone within the Lawson General Ledger application where the transaction originated.	ML146, ML167, ML190, ML191, ML199, ML290, ML40.1, ML40.2 +6 more
`MLT-POSTING-DATE` POSTING_DATE	Numeric 8 (yyyymmdd)	The date assigned to the journal entry for posting.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
`MLT-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field displays the transaction currency code used for the journal entry.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
`MLT-BASERATE` BASERATE	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 +8 more
`MLT-TRAN-AMOUNT` TRAN_AMOUNT	Signed 18.2	This field displays the amount in transaction currency to be posted.	ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +14 more
`MLT-TRAN-ND` TRAN_ND	Numeric 1	Indicates the number of positions defined for the transaction currency.	ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +6 more
`MLT-ACCT-CURRENCY` ACCT_CURRENCY	Alpha 5	This is the account currency, if applicable.	ML146, ML167, ML190, ML191, ML196, ML290, ML40.1, ML40.2 +7 more
`MLT-ACCT-RATE` ACCT_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 +7 more
`MLT-ACCT-AMOUNT` ACCT_AMOUNT	Signed 18.2	The transaction amount in account currency.	ML146, ML167, ML190, ML191, ML196, ML290, ML40.1, ML40.2 +9 more
`MLT-ACCT-ND` 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 +5 more
`MLT-ORIG-COMPANY` ORIG_COMPANY	Numeric 4	The originating company number.	ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +6 more
`MLT-ORIG-PROGRAM` ORIG_PROGRAM	Alpha 5	The originating program number.	ML146, ML167, ML191, ML196, ML290, ML40.1, ML40.2, ML40.3 +5 more
`MLT-OPERATOR` 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 +8 more
`MLT-TO-BASE-AMT` TO_BASE_AMT	Signed 18.2	To company base amount	ML146, ML40.1, ML40.2, ML40.3, ML40.5, ML40.6, ML40.7, ML40.8 +5 more
`MLT-TO-BASE-ND` TO_BASE_ND	Numeric 1	To company base number of decimals.	ML146, ML240, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7, ML40.8 +3 more
`MLT-TO-BASERATE` TO_BASERATE	Signed 14.7	To company base currency exchange rate.	ML146, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7, ML40.8, ML44.1 +2 more
`MLT-TO-BASE-CURR` TO_BASE_CURR	Alpha 5	To company base currency.	ML146, ML167, ML190, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7 +4 more
`MLT-RECONCILE` RECONCILE	Alpha 2	Indicates the reconciliation transactions.	ML290, ML90.4
`MLT-NEGATIVE-ADJ` NEGATIVE_ADJ	Alpha 1	Indicates a negative adjustment.	ML146, ML167, ML190, ML196, ML290, ML40.1, ML40.2, ML40.3 +5 more
`MLT-UPDATE-DATE` UPDATE_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 +3 more
`MLT-SEQ-TRNS-NBR` 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 +2 more
`MLT-JBK-TRNS-NBR` 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 +2 more
`MLT-RPT-AMOUNT-1` RPT_AMOUNT_1	Signed 18.2	The transaction amount for Report Currency 1.	GL310, ML146, ML167, ML190, ML191, ML196, ML199, ML290 +12 more
`MLT-RPT-RATE-1` RPT_RATE_1	Signed 14.7	The exchange rate to convert the transaction to report currency 1.	GL310, ML146, ML167, ML190, ML191, ML199, ML290, ML40.1 +8 more
`MLT-RPT-ND-1` RPT_ND_1	Numeric 1	The number of decimal positions for Report Currency 1.	GL310, ML146, ML167, ML190, ML191, ML196, ML199, ML290 +9 more
`MLT-RPT-AMOUNT-2` RPT_AMOUNT_2	Signed 18.2	The transaction amount for Report Currency 2.	GL310, ML146, ML167, ML190, ML191, ML196, ML199, ML290 +12 more
`MLT-RPT-RATE-2` RPT_RATE_2	Signed 14.7	The exchange rate to convert the transaction to report currency 2.	GL310, ML146, ML167, ML190, ML191, ML199, ML290, ML40.1 +8 more
`MLT-RPT-ND-2` RPT_ND_2	Numeric 1	The number of decimal positions for Report Currency 2.	GL310, ML146, ML167, ML190, ML191, ML196, ML199, ML290 +9 more

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`MLTSET1`	`OBJ-ID`	Primary		ML146, ML190, ML40.1, ML40.2, ML40.3, ML40.7, ML40.8, ML44.1 +2 more
`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 +18 more
`MLTSET3`	`LEDGER`, `TO-COMPANY`, `FISCAL-YEAR`, `ACCT-PERIOD`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCOUNT`, `OBJ-ID`	KeyChange, Subset	Where STATUS != 8	GL120, ML199, ML290, ML325, ML327
`MLTSET4`	`LEDGER`, `TO-COMPANY`, `ACCOUNT`, `SUB-ACCOUNT`, `ACCT-UNIT`, `FISCAL-YEAR`, `ACCT-PERIOD`, `OBJ-ID`	KeyChange, Subset	Where STATUS != 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	Where STATUS != 8	ML290

Relations

One to one (7) — lookups and parents

Relation	Table	Rules	Field map
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`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (20)

GL120 Level Reorganization
GL310 Report Currency Purge
ML110 Ledger Company Copy Delete
ML146 Batch Ledger Journal Control
ML167 Ledger Balance Interface
ML190 Ledger Journal Posting
ML191 Ledger Currency Revaluation
ML196 Ledger Report Currency Translation
ML199 Ledger Period Closing
ML300 Ledger History Delete
ML40.1 Ledger Journal Entry
ML40.2 Define Ledger Journal
ML40.3 Ledger Speed Entry
ML40.6 Ledger Journal Copy
ML40.7 Ledger Totals
ML40.8 Ledger Journal Entry
ML44.1 Ledger Report Currency Entry
ML45.1 Ledger Journal Control
ML90.4 Reconcile Ledger Transactions
MLIT.1 General Ledger Account Edit

Referenced by (11)

ML10.1 Ledger Setup
ML12.1 Ledger Calendar Map
ML145 Ledger Journal Hold Release
ML170 Ledger Recurring Journal Interface
ML240 Ledger Journal Edit Listing
ML241 Ledger Period Transaction List
ML290 Ledger Report
ML325 Ledger AMOUNTS, UNITS Rebuild
ML327 Ledger Report Currency Rebuild
ML41.1 Ledger Journal Analysis
ML41.3 Filter