GL Balance Conversion

The General Ledger Period Balance Interface (GLMASTREL) file contains the information needed to create period balances in the Lawson General Ledger system when converting from another system in GL67.1 (Balance Interface Maintenance).
UPDATED BY

GL167

GL67.1

GL267

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
GMR-COMPANY Element: Company	Numeric 4 The company number as defined in GL10.1 (Company).	GL67.1
GMR-FISCAL-YEAR Element: Fiscal Year	Numeric 4 Contains the fiscal year for the data stored on this record.	GL67.1
GMR-OLD-COMPANY Element: Old Company	Alpha 35 The old company structure associated with the Lawson Company and Accounting Unit.	GL67.1
GMR-OLD-CPY-SHORT Old Company Short Desc	Derived The old company short description.
GMR-OLD-ACCT-NBR Element: Old Account Number	Alpha 25 This is the old account structure to be associated with the new account/subaccount within the Lawson system.	GL67.1
GMR-OLD-ACCT-SHORT Old Account Short Desc	Derived The old account short description.
GMR-ACTIVE-STATUS Element: Active Status	Alpha 1 The status of the account. If Inactive, no posting can be done to the account. A = Active I = Inactive	GL167 GL67.1
GMR-OPTION-FLD-1 Element: Option Field	Alpha 2 (Lower Case) Free-form field used to store any information relevant to an account. This field is used only for reporting purposes.	GL67.1
GMR-OPTION-FLD-2 Element: Option Field	Alpha 7 (Lower Case) Free-form field used to store information relevant to an account. This field is used only for reporting purposes.	GL67.1
GMR-OPTION-FLD-3 Element: Option Field	Alpha 12 (Lower Case) This is the level description.	GL67.1
GMR-PERIOD-AMOUNT Element: Period Amount	Signed 18.2 Occurs 13 Times The net period amount.	GL67.1
GMR-PERIOD-UNITS Element: Period Units	Signed 15.2 Occurs 13 Times The net period units amount.	GL67.1
GMR-TRAN-CURR Element: Currency Code	Alpha 5 The transaction currency code.	GL167 GL67.1
GMR-TRAN-AMOUNT Element: Intl Amt	Signed 18.2 Occurs 13 Times	GL167 GL67.1
GMR-TRAN-BEG-BAL Element: Intl Amt	Signed 18.2 The transaction currency beginning balance amount.	GL167 GL67.1
GMR-BEGIN-BAL Element: Begin Balance	Signed 18.2 If prior year balances are converted, then this field needs the beginning balance for balance sheet accounts for the prior year.	GL67.1
GMR-BEGIN-UNIT-BAL Element: Begin Unit Balance	Signed 15.2 The beginning unit balance for balance sheet accounts for the prior year.	GL67.1
GMR-ACCT-ND Account Number of Decimals	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.
GMR-RPT-PER-AMT-1 Element: Intl Amt	Signed 18.2 Occurs 13 Times	GL67.1
GMR-RPT-PER-AMT-2 Element: Intl Amt	Signed 18.2 Occurs 13 Times	GL67.1
GMR-RPT-BEG-BAL-1 Element: Intl Amt	Signed 18.2	GL67.1
GMR-RPT-BEG-BAL-2 Element: Intl Amt	Signed 18.2	GL67.1

GLMASTREL FILE INDEX

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