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 |
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). |
|
||
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). |
|
||
MMR-FISCAL-YEAR Element: Year | Numeric 4 The fiscal year for the posting. |
|
||
MMR-OLD-COMPANY Element: Old Company | Alpha 35 The old company structure associated with the Lawson Company and Accounting Unit. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
MMR-PERIOD-AMOUNT Element: Intl Amt | Signed 18.2 Occurs 13 Times The net period amount. |
|
||
MMR-PERIOD-UNITS Element: Unit | Signed 15.2 Occurs 13 Times The net period units amount. |
|
||
MMR-TRAN-CURR Element: Currency Code | Alpha 5 The transaction currency of the interfaced transaction. |
|
||
MMR-TRAN-AMOUNT Element: Intl Amt | Signed 18.2 Occurs 13 Times |
|
||
MMR-TRAN-BEG-BAL Element: Intl Amt | Signed 18.2 The transaction currency beginning balance. |
|
||
MMR-BEGIN-BAL Element: Intl Amt | Signed 18.2 The beginning balance for the fiscal year specified. |
|
||
MMR-BEGIN-UNIT-BAL Element: Curr Balance | Signed 15.2 The beginning unit balance for the fiscal year specified. |
|
||
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. |
|
||
MMR-RPT-PER-AMT-2 Element: Intl Amt | Signed 18.2 Occurs 13 Times The period balance for report currency 2. |
|
||
MMR-RPT-BEG-BAL-1 Element: Intl Amt | Signed 18.2 The beginning balance for report currency 1. |
|
||
MMR-RPT-BEG-BAL-2 Element: Intl Amt | Signed 18.2 The beginning balance for report currency 2. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MMRSET1 |
LEDGER COMPANY FISCAL-YEAR OLD-COMPANY OLD-ACCT-NBR TRAN-CURR |
|
|
All trademarks and registered trademarks are the property of their
respective owners.