MLRJTRANS

ML Recurring Transactions

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

REFERENCED BY
ML270


UPDATED BY
ML110 ML170 ML70.1 ML70.2 ML70.3 ML70.5
ML70.6 ML75.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MRT-LEDGER
Element: Ledger
Alpha 15
The ledger being posted to.
ML110 ML70.1
ML70.2 ML70.3
ML70.6
MRT-COMPANY
Element: 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
Element: Rec Group
Numeric 8
The recurring journal entry number.
ML70.1 ML70.2
ML70.3 ML70.6
MRT-JE-TYPE
Element: Je Type
Alpha 1
The recurring journal entry type (Normal or Intercompany).
ML70.1 ML70.2
ML70.3 ML70.6
MRT-LINE-NBR
Element: Line Nbr
Numeric 6
The recurring journal entry line number.
ML70.1 ML70.2
ML70.3 ML70.6
MRT-ACCT-UNIT
Element: 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
Element: Account
Numeric 6
The account to which the recurring journal entry is posted.
ML70.1 ML70.2
ML70.3 ML70.6
MRT-SUB-ACCOUNT
Element: Sub Acct
Numeric 4
The subaccount to which the recurring journal entry is posted.
ML70.1 ML70.2
ML70.3 ML70.6
MRT-SOURCE-CODE
Element: 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
Element: Reference
Alpha 10 (Lower Case)
The reference number associated with the transaction.
ML70.1 ML70.2
ML70.3 ML70.6
MRT-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The recurring journal entry description.
ML70.1 ML70.2
ML70.3 ML70.6
MRT-BASE-AMOUNT
Element: Intl Amt
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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Intl Amt
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
Element: Acct 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
Element: 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
Element: 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
Element: Acct Nd
Numeric 1
This is the number of decimal positions in the volume field.
ML70.1 ML70.2
ML70.3 ML70.6


MLRJTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MRTSET1 LEDGER
COMPANY
REC-GROUP
JE-TYPE
LINE-NBR
ML110 ML170
ML270 ML70.1
ML70.2 ML70.3
ML70.5 ML70.6
ML75.1


MLRJTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


MLRJTRANS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


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

Home
Contact Us



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