MLMASTREL – ML Balance Interface

System
Multi-Ledger (ML)
Prefix
MMR
Primary key
LEDGER, COMPANY, FISCAL-YEAR, OLD-COMPANY, OLD-ACCT-NBR, TRAN-CURR
Fields
23
Updated by
2 programs
Referenced by
1 program

MLMASTREL is the ML Balance Interface table in Lawson Multi-Ledger (prefix MMR). It is indexed by LEDGER, COMPANY, FISCAL-YEAR, OLD-COMPANY, OLD-ACCT-NBR, TRAN-CURR (MMRSET1). It is updated by ML167 and ML67.1 and referenced by ML267. The table has 23 fields, 1 index and 0 documented relations.

About MLMASTREL

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.

Fields (23)

Column = COBOL field name without the MMR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MMR-LEDGER PK
LEDGER		Alpha 15The name assigned to the ledger. The ledger is established in ledger Setup (Ml10).ML67.1
MMR-COMPANY PK
COMPANY		Numeric 4The company for which balances are posted. It must be linked to the ledger on Ledger Setup (ML10.1).ML67.1
MMR-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4The fiscal year for the posting.ML67.1
MMR-OLD-COMPANY PK
OLD_COMPANY		Alpha 35The old company structure associated with the Lawson Company and Accounting Unit.ML67.1
MMR-OLD-CPY-SHORT
OLD_CPY_SHORT		DerivedThe old company short description.—
MMR-OLD-ACCT-NBR PK
OLD_ACCT_NBR		Alpha 25This is the old account structure to be associated with the new account/subaccount within the Lawson system.ML67.1
MMR-OLD-ACCT-SHORT
OLD_ACCT_SHORT		DerivedThe old account short description.—
MMR-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of the account. If Inactive no posting can be done to the account.ML167, ML67.1
MMR-OPTION-FLD-1
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
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
OPTION_FLD_3		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
PERIOD_AMOUNT		Signed 18.2 Occurs 13 Times ×13The net period amount.ML67.1
MMR-PERIOD-UNITS
PERIOD_UNITS		Signed 15.2 Occurs 13 Times ×13The net period units amount.ML67.1
MMR-TRAN-CURR PK
TRAN_CURR		Alpha 5The transaction currency of the interfaced transaction.ML167, ML67.1
MMR-TRAN-AMOUNT
TRAN_AMOUNT		Signed 18.2 Occurs 13 Times ×13—ML167, ML67.1
MMR-TRAN-BEG-BAL
TRAN_BEG_BAL		Signed 18.2The transaction currency beginning balance.ML167, ML67.1
MMR-BEGIN-BAL
BEGIN_BAL		Signed 18.2The beginning balance for the fiscal year specified.ML67.1
MMR-BEGIN-UNIT-BAL
BEGIN_UNIT_BAL		Signed 15.2The beginning unit balance for the fiscal year specified.ML67.1
MMR-ACCT-ND
ACCT_ND		Numeric 1The number of decimal used for currency amounts in the account.—
MMR-RPT-PER-AMT-1
RPT_PER_AMT_1		Signed 18.2 Occurs 13 Times ×13The period balance for report currency 1.ML67.1
MMR-RPT-PER-AMT-2
RPT_PER_AMT_2		Signed 18.2 Occurs 13 Times ×13The period balance for report currency 2.ML67.1
MMR-RPT-BEG-BAL-1
RPT_BEG_BAL_1		Signed 18.2The beginning balance for report currency 1.ML67.1
MMR-RPT-BEG-BAL-2
RPT_BEG_BAL_2		Signed 18.2The beginning balance for report currency 2.ML67.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MMRSET1LEDGER, COMPANY, FISCAL-YEAR, OLD-COMPANY, OLD-ACCT-NBR, TRAN-CURRPrimaryML167, ML267, ML67.1

Programs

Updated by (2)

Referenced by (1)