GLMASTREL FILE
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 GL67.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMR-COMPANY Numeric 4 GL67.1
Company The company number as defined in GL10.1
(Company).
GMR-FISCAL-YEAR Numeric 4 GL67.1
Fiscal Year This is the current fiscal year. This
field is updated by Period Closing
(GL199).
GMR-OLD-COMPANY Alpha 35 GL67.1
Old Company The old company structure associated
with the Lawson Company and Accounting
Unit.
GMR-OLD-CPY-SHORT Derived
Old Company Short The old company short description.
Desc
GMR-OLD-ACCT-NBR Alpha 25 GL67.1
Old Account Number This is the old account structure to be
associated with the new
account/subaccount within the Lawson
system.
GMR-OLD-ACCT-SHORT Derived
Old Account Short The old account short description.
Desc
GMR-ACTIVE-STATUS Alpha 1 GL167 GL67.1
Active Status The status of the account. If Inactive,
no posting can be done to the account.
A = Active
I = Inactive
GMR-OPTION-FLD-1 Alpha 2 (Lower Case) GL67.1
Option Field Free-form field used to store any
information relevant to an account. This
field is used only for reporting
purposes.
GMR-OPTION-FLD-2 Alpha 7 (Lower Case) GL67.1
Option Field Free-form field used to store
information relevant to an account. This
field is used only for reporting
purposes.
GMR-OPTION-FLD-3 Alpha 12 (Lower Case) GL67.1
Option Field Free-form field used to store any
information relevant to an account. This
field is used only for reporting
purposes.
GMR-PERIOD-AMOUNT Signed 15.2 Occurs 13 Times GL67.1
Period Amount The net period amount.
GMR-PERIOD-UNITS Signed 15.2 Occurs 13 Times GL67.1
Period Units The net period units amount.
GMR-TRAN-CURR Alpha 5 GL167 GL67.1
Tran Curr The transaction currency code.
GMR-TRAN-AMOUNT Signed 15.2 Occurs 13 Times GL67.1
Invoice Amount This is the amount in transaction
currency to be posted. This amount
creates a CUAMOUNT type 1 record.
GMR-TRAN-BEG-BAL Signed 15.2 GL67.1
Tran Beg Bal The transaction currency beginning
balance amount.
GMR-BEGIN-BAL Signed 15.2 GL67.1
Begin Balance If prior year balances are converted,
then this field needs the beginning
balance for balance sheet accounts for
the prior year.
GMR-BEGIN-UNIT-BAL Signed 15.2 GL67.1
Begin Unit Balance The beginning unit balance for balance
sheet accounts for the prior year.
GMR-ACCT-ND Numeric 1
Account Number of The number of decimals assigned to a
Decimals particular account as determined by the
account currency.
GMR-RPT-PER-AMT-1 Signed 15.2 Occurs 13 Times GL67.1
Rpt Per Amt 1 The net period amount for Report
Currency 1.
GMR-RPT-PER-AMT-2 Signed 15.2 Occurs 13 Times GL67.1
Rpt Per Amt 2 The net period amount for Report
Currency 2.
GMR-RPT-BEG-BAL-1 Signed 15.2 GL67.1
Report Curr 1 Begin The beginning balance amount for
Balance balance sheet accounts for Report
Currency 1.
GMR-RPT-BEG-BAL-2 Signed 15.2 GL67.1
Report Curr 2 Begin The beginning balance amount for
Balance balance sheet accounts for Report
Currency 2.
GLMASTREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMRSET1 COMPANY GL167 GL267
FISCAL-YEAR GL67.1
OLD-COMPANY
OLD-ACCT-NBR
TRAN-CURR
|
