|
|
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 GL950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMR-COMPANY Numeric 4 GL67.1 GL950
Company The company number as defined in GL10.1
(Company).
GMR-FISCAL-YEAR Numeric 4 GL67.1 GL950
Fiscal Year This is the current fiscal year. This
field is updated by GL199 (Period
Closing).
GMR-OLD-COMPANY Alpha 35 GL67.1 GL950
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 GL950
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, GL950
no posting can be done to the account.
A = Active
I = Inactive
GMR-OPTION-FLD-1 Alpha 2 (Lower Case) GL67.1 GL950
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 GL950
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 GL950
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 GL950
Period Amount The net period amount.
GMR-PERIOD-UNITS Signed 15.2 Occurs 13 Times GL67.1 GL950
Period Units The net period units amount.
GMR-BEGIN-BAL Signed 15.2 GL67.1 GL950
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 GL950
Begin Unit Balance The beginning unit balance for balance
sheet accounts for the prior year.
GMR-ACCT-ND Numeric 1 GL950
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
Report Currency The net period amount for Report
Amount Currency 1.
GMR-RPT-PER-AMT-2 Signed 15.2 Occurs 13 Times GL67.1
Report Currency The net period amount for Report
Amount Currency 2.
GMR-RPT-BEG-BAL-1 Signed 15.2 GL67.1
Report Currency The beginning balance amount for
Beginning Bal balance sheet accounts for Report
Currency 1.
GMR-RPT-BEG-BAL-2 Signed 15.2 GL67.1
Report Currency The beginning balance amount for
Beginning Bal 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
|