GLMASTREL

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).

REFERENCED BY
GL267


UPDATED BY
GL167 GL194 GL67.1

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMRSET1 COMPANY
FISCAL-YEAR
OLD-COMPANY
OLD-ACCT-NBR
TRAN-CURR
GL167 GL194
GL267 GL67.1


File created: Thu Jun 09 11:13:20 2016

Home
Contact Us



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