MLRJCNTRL

ML Recurring Control

This file contains recurring journal entry control information defined in Ledger Recurring Journal (ML70.1). This information is used to process the recurring journal entry detail records.

REFERENCED BY
ML40.1 ML40.3 ML270 ML275 MLCC.1 MLIT.1


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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MRC-LEDGER
Element: Ledger
Alpha 15
The ledger being posted to.
ML110 ML70.2
ML70.6 MLCC.1
MRC-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).
ML70.2 ML70.6
MLCC.1
MRC-JE-TYPE
Element: Je Type
Alpha 1
The type of journal entry. Valid values are Normal and Intercompany.
ML70.2 ML70.6
MLCC.1
MRC-REC-GROUP
Element: Rec Group
Numeric 8
The recurring journal entry number.
ML70.2 ML70.6
MLCC.1
MRC-STATUS
Element: Status
Numeric 1
This field contains the recurring journal entry status.
ML170 ML70.1
ML70.2 ML70.3
ML70.5 ML70.6
ML75.1
MRC-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the recurring journal entry line number.
ML70.1 ML70.2
ML70.3 ML70.6
MRC-NBR-LINES
Element: Nbr Lines
Numeric 6
This field contains the number of detail lines in the recurring journal entry.
ML70.1 ML70.2
ML70.3 ML70.6
MRC-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the recurring journal entry line description.
ML70.2 ML70.6
MRC-AUTO-ZERO
Element: Auto Zero
Alpha 1
This field is used to determine if amounts are to be zeroed out after processing.
ML70.2 ML70.6
MRC-POST-PERIOD
Element: Post Period
Alpha 1 Occurs 13 Times
These fields contain the periods you want the allocation to be processed in.
ML70.2 ML70.6
MRC-LP-PERIOD
Element: Lp Period
Numeric 2
The period the transaction was last processed.
ML170 ML70.1
ML70.2 ML70.3
ML70.5 ML70.6
ML75.1
MRC-LP-YEAR
Element: Year
Numeric 4
The year the transaction was last processed.
ML170 ML70.1
ML70.2 ML70.3
ML70.5 ML70.6
ML75.1
MRC-BEG-PERIOD
Element: Beg Period
Numeric 2
This is the beginning period the transaction is to be posted to.
ML70.2 ML70.6
MRC-BEG-YEAR
Element: Year
Numeric 4
This is the beginning year the transaction is to be posted to.
ML70.2 ML70.6
MRC-END-PERIOD
Element: End Period
Numeric 2
This is the ending period the transaction is to be posted to.
ML70.2 ML70.6
MRC-END-YEAR
Element: End Year
Numeric 4
This is the ending year the transaction is to be posted to.
ML70.2 ML70.6
MRC-ENTRY-DEBITS
Element: Intl Amt
Signed 18.2
The total debit (positive) detail amounts.
ML170 ML70.1
ML70.2 ML70.3
ML70.5 ML70.6
ML75.1
MRC-ENTRY-CREDITS
Element: Intl Amt
Signed 18.2
The total credit (negative) detail amounts.
ML170 ML70.1
ML70.2 ML70.3
ML70.5 ML70.6
ML75.1
MRC-TRAN-ND
Element: Acct Nd
Numeric 1
The number of decimal positions for the transaction currency.
ML70.2 ML70.6
MRC-UNIT-DEBITS
Element: Unit Debits
Signed 15.2
The total debit (positive) detail unit amounts.
ML170 ML70.1
ML70.2 ML70.3
ML70.5 ML70.6
ML75.1
MRC-UNIT-CREDITS
Element: Unit Credits
Signed 15.2
The total credit (negative) detail unit amounts.
ML170 ML70.1
ML70.2 ML70.3
ML70.5 ML70.6
ML75.1
MRC-AUTO-DEBITS
Element: Intl Amt
Signed 18.2
The total debit (positive) detail auto reversing amounts.
ML170 ML70.1
ML70.2 ML70.3
ML70.5 ML70.6
ML75.1
MRC-AUTO-CREDITS
Element: Intl Amt
Signed 18.2
The total credit (negative) detail auto reversing amounts.
ML170 ML70.1
ML70.2 ML70.3
ML70.5 ML70.6
ML75.1
MRC-AUTO-UNIT-DB
Element: Auto Debits
Signed 15.2
The total debit (positive) detail auto reversing unit amounts.
ML70.1 ML70.2
ML70.3 ML70.6
MRC-AUTO-UNIT-CR
Element: Auto Credits
Signed 15.2
The total credit (negative) detail auto reversing unit amounts.
ML70.1 ML70.2
ML70.3 ML70.6
MRC-POSTING-DAY
Element: Posting Day
Numeric 2
This is the day the transaction is to be posted in the Lawson Multi-Ledger application. If this field is left blank, the period end date defaults.
ML70.2 ML70.6
MRC-OPERATOR
Element: Operator
Alpha 10
This field is used to store the user id of the period who entered the record.
ML70.2 ML70.6
MRC-LAST-CMT-SEQ
Element: Last Cmt Seq
Numeric 4
The sequence number of the last comment for the journal entry.
MRC-BASE-ZONE
Element: Zone
Alpha 15
The zone within the Lawson General Ledger application where the transaction is originating.
ML70.2 ML70.6
MRC-BASE-DEBITS
Element: Intl Amt
Signed 18.2
The total debit (positive) detail amount in the company base currency.
ML170 ML70.1
ML70.2 ML70.3
ML70.5 ML70.6
ML75.1
MRC-BASE-CREDITS
Element: Intl Amt
Signed 18.2
The total credit (negative) detail amount in the company base currency.
ML170 ML70.1
ML70.2 ML70.3
ML70.5 ML70.6
ML75.1
MRC-BASE-AUTO-DB
Element: Intl Amt
Signed 18.2
The total debit (positive) detail auto reversing amount in the company base currency.
ML170 ML70.1
ML70.2 ML70.3
ML70.5 ML70.6
ML75.1
MRC-BASE-AUTO-CR
Element: Intl Amt
Signed 18.2
The total credit (negative) detail auto reversing amount in the company base currency.
ML170 ML70.1
ML70.2 ML70.3
ML70.5 ML70.6
ML75.1
MRC-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions for the base currency.
ML70.2 ML70.6
MRC-CURRENCY-CODE
Element: Currency Code
Alpha 5
The transaction currency code.
ML70.2 ML70.6
MRC-BASERATE
Element: Curr Rate
Signed 14.7
This field displays the exchange rate between the transaction currency and the base currency. If this field is left blank, the program retrieves the exchange rate in effect for the transaction date from the applicable exchange rate table.
ML170 ML270
ML70.1 ML70.2
ML70.3 ML70.5
ML70.6 ML75.1
MRC-SOURCE-CODE
Element: Source Code
Alpha 2
A two character code assigned to a transaction to identify where the transaction was created.
ML70.2
MRC-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.2
MRC-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
The reference number associated with the transaction.
ML70.2 ML70.6
MRC-DOCUMENT-NBR
Element: Document Nbr
Alpha 27
The document number associated with the transaction.
ML70.2
MRC-NET-BASE-AMT
Element: Net Base Amt
Derived
The net base amount.
MRC-NET-BASE-AREV
Element: Net Base Arev
Derived
The net base auto-reverse amount.
MRC-JRNL-BOOK-NBR
Element: Jrnl Book Nbr
Alpha 12
The journal book associated with the transaction.
ML70.2
MRC-BRIDGE-FLAG
Element: All Flag
Alpha 1
This field determines the origin of the recurring entry. A No value indicates that the entry was created through Ledger Recurring Journal) ML70.1). A Yes value indicates that the entry originated from another application. Currently, only GL70.1 can create recurring journal entries.
MRC-TRAN-DESC-DFLT
Element: Tran Desc Dflt
Alpha 1
This field determines the default description that appears for each transaction line.
ML70.2
MRC-MX-VALUE
Element: Mx Value
Alpha 32 Occurs 3 Times
This field contains the attribute value (or values) associated with the transaction.
ML70.2
MRC-TRANS-DAY
Element: Day
Numeric 2
This field contains the journal entry transaction day.
ML70.2 ML70.6


MLRJCNTRL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MRCSET1 LEDGER
COMPANY
JE-TYPE
REC-GROUP
ML110 ML170
ML270 ML275
ML40.1 ML40.3
ML70.1 ML70.2
ML70.3 ML70.5
ML70.6 ML75.1
MLCC.1 MLIT.1


MLRJCNTRL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
MRC-COMPANY->GLS-COMPANY
Mlcoledger MLCOLEDGER Required
MRC-LEDGER->MLE-LEDGER
MRC-COMPANY->MLE-COMPANY
Mlrjtrans MLRJTRANS Not Required, Delete Cascades
MRC-LEDGER->MRT-LEDGER
MRC-COMPANY->MRT-COMPANY
MRC-REC-GROUP->MRT-REC-GROUP
MRC-JE-TYPE->MRT-JE-TYPE
MRC-LINE-NBR->MRT-LINE-NBR


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

Home
Contact Us



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