MLMASTREL

ML Balance Interface

The Multi Book Ledger Period Balance Interface (MLMASTREL) file contains the information needed to create period balances in the Lawson Multi Book Ledger application when interfacing a non-Lawson file to the Multi Book Ledger application. You can use Balance Interface Maintenance (ML67.1) to view and modify this file.

REFERENCED BY
ML267


UPDATED BY
ML167 ML67.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MMR-LEDGER
Element: Ledger
Alpha 15
The name assigned to the ledger. The ledger is established in ledger Setup (Ml10).
ML67.1
MMR-COMPANY
Element: Company
Numeric 4
The company for which balances are posted. It must be linked to the ledger on Ledger Setup (ML10.1).
ML67.1
MMR-FISCAL-YEAR
Element: Year
Numeric 4
The fiscal year for the posting.
ML67.1
MMR-OLD-COMPANY
Element: Old Company
Alpha 35
The old company structure associated with the Lawson Company and Accounting Unit.
ML67.1
MMR-OLD-CPY-SHORT
Element: Old Cpy Short
Derived
The old company short description.
MMR-OLD-ACCT-NBR
Element: Old Acct Nbr
Alpha 25
This is the old account structure to be associated with the new account/subaccount within the Lawson system.
ML67.1
MMR-OLD-ACCT-SHORT
Element: Old Acct Short
Derived
The old account short description.
MMR-ACTIVE-STATUS
Element: Active Status
Alpha 1
The status of the account. If Inactive no posting can be done to the account.
ML167 ML67.1
MMR-OPTION-FLD-1
Element: Option Fld 1
Alpha 2 (Lower Case)
Free-form field used to store any information relevant to an account. This field is used only for reporting purposes.
ML67.1
MMR-OPTION-FLD-2
Element: Option Fld 2
Alpha 7 (Lower Case)
Free-form field used to store any information relevant to an account. This field is used only for reporting purposes.
ML67.1
MMR-OPTION-FLD-3
Element: Level Desc
Alpha 12 (Lower Case)
Free-form field used to store any information relevant to an account. This field is used only for reporting purposes.
ML67.1
MMR-PERIOD-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
The net period amount.
ML67.1
MMR-PERIOD-UNITS
Element: Unit
Signed 15.2 Occurs 13 Times
The net period units amount.
ML67.1
MMR-TRAN-CURR
Element: Currency Code
Alpha 5
The transaction currency of the interfaced transaction.
ML167 ML67.1
MMR-TRAN-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
ML167 ML67.1
MMR-TRAN-BEG-BAL
Element: Intl Amt
Signed 18.2
The transaction currency beginning balance.
ML167 ML67.1
MMR-BEGIN-BAL
Element: Intl Amt
Signed 18.2
The beginning balance for the fiscal year specified.
ML67.1
MMR-BEGIN-UNIT-BAL
Element: Curr Balance
Signed 15.2
The beginning unit balance for the fiscal year specified.
ML67.1
MMR-ACCT-ND
Element: Acct Nd
Numeric 1
The number of decimal used for currency amounts in the account.
MMR-RPT-PER-AMT-1
Element: Intl Amt
Signed 18.2 Occurs 13 Times
The period balance for report currency 1.
ML67.1
MMR-RPT-PER-AMT-2
Element: Intl Amt
Signed 18.2 Occurs 13 Times
The period balance for report currency 2.
ML67.1
MMR-RPT-BEG-BAL-1
Element: Intl Amt
Signed 18.2
The beginning balance for report currency 1.
ML67.1
MMR-RPT-BEG-BAL-2
Element: Intl Amt
Signed 18.2
The beginning balance for report currency 2.
ML67.1


MLMASTREL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MMRSET1 LEDGER
COMPANY
FISCAL-YEAR
OLD-COMPANY
OLD-ACCT-NBR
TRAN-CURR
ML167 ML267
ML67.1


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

Home
Contact Us



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