MLRJTRANS – ML Recurring Transactions

System: Multi-Ledger (ML)
Prefix: MRT
Primary key: LEDGER, COMPANY, REC-GROUP, JE-TYPE, LINE-NBR
Fields: 21
Updated by: 8 programs
Referenced by: 1 program

MLRJTRANS is the ML Recurring Transactions table in Lawson Multi-Ledger (prefix MRT). It is indexed by LEDGER, COMPANY, REC-GROUP, JE-TYPE, LINE-NBR (MRTSET1). It is related 1:1 to GLSYSTEM, MLCOLEDGER, MLRJCNTRL and GLSRCCODE and 1:M to MLRJMXVAL. It is updated by ML110, ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6 and ML75.1 and referenced by ML270. The table has 21 fields, 1 index and 5 documented relations.

About MLRJTRANS

This file contains the recurring journal entry detail information to be posted to the Lawson Multi Book Ledger application.

Fields (21)

Column = COBOL field name without the MRT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`MRT-LEDGER` PK LEDGER	Alpha 15	The ledger being posted to.	ML110, ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-COMPANY` PK COMPANY	Numeric 4	The company for which recurring journal entries are posted. It must be linked to the ledger on Ledger Setup (ML10.1).	ML110, ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-REC-GROUP` PK REC_GROUP	Numeric 8	The recurring journal entry number.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-JE-TYPE` PK JE_TYPE	Alpha 1	The recurring journal entry type (Normal or Intercompany).	ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-LINE-NBR` PK LINE_NBR	Numeric 6	The recurring journal entry line number.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-ACCT-UNIT` ACCT_UNIT	Alpha 15	The accounting unit to which the recurring journal entry is posted.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-ACCOUNT` ACCOUNT	Numeric 6	The account to which the recurring journal entry is posted.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-SUB-ACCOUNT` SUB_ACCOUNT	Numeric 4	The subaccount to which the recurring journal entry is posted.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-SOURCE-CODE` SOURCE_CODE	Alpha 2	The source code representing the application where the journal entry transaction originated.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The reference number associated with the transaction.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The recurring journal entry description.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-BASE-AMOUNT` BASE_AMOUNT	Signed 18.2	The base amount to be posted to the Multi Book Ledger.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRT-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions for the base currency.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRT-UNITS-AMOUNT` UNITS_AMOUNT	Signed 15.2	This is the units amount for the recurring journal entry.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRT-AUTO-REV` AUTO_REV	Alpha 1	When the Auto Reversal field is set to Yes, Ledger Period Closing (ML199). creates an opposite entry for this transaction in the next period.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-TO-COMPANY` TO_COMPANY	Numeric 4	This is the company number to which the recurring journal entry line is to be posted.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-TRAN-AMOUNT` TRAN_AMOUNT	Signed 18.2	This is the amount in transaction currency to be posted. This amount creates an MLCUAMOUNT type 1 record.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRT-TRAN-ND` TRAN_ND	Numeric 1	The number of decimal positions defined for the transaction currency.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRT-VOLUME` VOLUME	Signed 16.5	This is the value will be multiplied by the volume-rate field to determine the transaction amount.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-VOLUME-RATE` VOLUME_RATE	Signed 10.5	This is the rate that will be multiplied with the volume field to determine the transaction amount.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRT-VOLUME-ND` VOLUME_ND	Numeric 1	This is the number of decimal positions in the volume field.	ML70.1, ML70.2, ML70.3, ML70.6

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`MRTSET1`	`LEDGER` `COMPANY` `REC-GROUP` `JE-TYPE` `LINE-NBR`	Primary		ML110, ML170, ML270, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6 +1 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (4) — lookups and parents

Relation Table Rules Condition Field map

Company

GLSYSTEM

Required

MRT-COMPANY → GLS-COMPANY

Mlcoledger

MLCOLEDGER

Required

`MRT-LEDGER`	→	`MLE-LEDGER`
`MRT-COMPANY`	→	`MLE-COMPANY`

Mlrjcntrl

MLRJCNTRL

Required

`MRT-LEDGER`	→	`MRC-LEDGER`
`MRT-COMPANY`	→	`MRC-COMPANY`
`MRT-JE-TYPE`	→	`MRC-JE-TYPE`
`MRT-REC-GROUP`	→	`MRC-REC-GROUP`

Source

GLSRCCODE

Required

MRT-SOURCE-CODE → GSR-SOURCE-CODE

One to many (1) — child tables

Relation Table Rules Condition Field map

Mlrjmxval

MLRJMXVAL

Delete Cascades

`MRT-LEDGER`	→	`MRM-LEDGER`
`MRT-COMPANY`	→	`MRM-COMPANY`
`MRT-REC-GROUP`	→	`MRM-REC-GROUP`
`MRT-JE-TYPE`	→	`MRM-JE-TYPE`
`MRT-LINE-NBR`	→	`MRM-LINE-NBR`
—	→	`MRM-MATRIX-CAT`

Programs

Updated by (8)

ML110 Ledger Company Copy Delete
ML170 Ledger Recurring Journal Interface
ML70.1 Ledger Recurring Journal
ML70.2 Define Recurring Journal
ML70.3 Amounts Only
ML70.5 Filter
ML70.6 Ledger Recurring Copy
ML75.1 Ledger Recurring Journal Control

Referenced by (1)

ML270 Ledger Recurring Jrnl Edit Lis

MLRJTRANS – ML Recurring Transactions

About MLRJTRANS

Fields (21) Copy as SQL

Indexes (1)

Relations

One to one (4) — lookups and parents

One to many (1) — child tables

Programs

Updated by (8)

Referenced by (1)

Fields (21)