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 |
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. |
|
||||||||
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). |
|
||||||||
MRT-REC-GROUP Element: Rec Group | Numeric 8 The recurring journal entry number. |
|
||||||||
MRT-JE-TYPE Element: Je Type | Alpha 1 The recurring journal entry type (Normal or Intercompany). |
|
||||||||
MRT-LINE-NBR Element: Line Nbr | Numeric 6 The recurring journal entry line number. |
|
||||||||
MRT-ACCT-UNIT Element: Acct Unit | Alpha 15 The accounting unit to which the recurring journal entry is posted. |
|
||||||||
MRT-ACCOUNT Element: Account | Numeric 6 The account to which the recurring journal entry is posted. |
|
||||||||
MRT-SUB-ACCOUNT Element: Sub Acct | Numeric 4 The subaccount to which the recurring journal entry is posted. |
|
||||||||
MRT-SOURCE-CODE Element: Source Code | Alpha 2 The source code representing the application where the journal entry transaction originated. |
|
||||||||
MRT-REFERENCE Element: Reference | Alpha 10 (Lower Case) The reference number associated with the transaction. |
|
||||||||
MRT-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The recurring journal entry description. |
|
||||||||
MRT-BASE-AMOUNT Element: Intl Amt | Signed 18.2 The base amount to be posted to the Multi Book Ledger. |
|
||||||||
MRT-BASE-ND Element: Base Nd | Numeric 1 The number of decimal positions for the base currency. |
|
||||||||
MRT-UNITS-AMOUNT Element: Units Amount | Signed 15.2 This is the units amount for the recurring journal entry. |
|
||||||||
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. |
|
||||||||
MRT-TO-COMPANY Element: Company | Numeric 4 This is the company number to which the recurring journal entry line is to be posted. |
|
||||||||
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. |
|
||||||||
MRT-TRAN-ND Element: Acct Nd | Numeric 1 The number of decimal positions defined for the transaction currency. |
|
||||||||
MRT-VOLUME Element: Volume | Signed 16.5 This is the value will be multiplied by the volume-rate field to determine the transaction amount. |
|
||||||||
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. |
|
||||||||
MRT-VOLUME-ND Element: Acct Nd | Numeric 1 This is the number of decimal positions in the volume field. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MRTSET1 |
LEDGER COMPANY REC-GROUP JE-TYPE LINE-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | GLSYSTEM |
Required
| ||||||||||||
Mlcoledger | MLCOLEDGER |
Required
| ||||||||||||
Mlrjcntrl | MLRJCNTRL |
Required
| ||||||||||||
Source | GLSRCCODE |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Mlrjmxval | MLRJMXVAL |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.