|
|
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
Element: Company The company number as defined in GL10.1
(Company).
GMR-FISCAL-YEAR Numeric 4 GL67.1
Element: Fiscal Year This is the current fiscal year. This
field is updated by Period Closing
(GL199).
GMR-OLD-COMPANY Alpha 35 GL67.1
Element: 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
Element: Old Account NuThis 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
Element: 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
Element: 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
Element: 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
Element: 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 18.2 Occurs 13 Times GL67.1
Element: Period Amount The net period amount.
GMR-PERIOD-UNITS Signed 15.2 Occurs 13 Times GL67.1
Element: Period Units The net period units amount.
GMR-TRAN-CURR Alpha 5 GL167 GL67.1
Element: Currency Code The transaction currency code.
GMR-TRAN-AMOUNT Signed 18.2 Occurs 13 Times GL167 GL67.1
Element: Intl Amt This is the amount in transaction
currency to be posted. This amount
creates a CUAMOUNT type 1 record.
GMR-TRAN-BEG-BAL Signed 18.2 GL167 GL67.1
Element: Intl Amt The transaction currency beginning
balance amount.
GMR-BEGIN-BAL Signed 18.2 GL67.1
Element: 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
Element: Begin Unit BalThe 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 18.2 Occurs 13 Times GL67.1
Element: Intl Amt The net period amount for Report
Currency 1.
GMR-RPT-PER-AMT-2 Signed 18.2 Occurs 13 Times GL67.1
Element: Intl Amt The net period amount for Report
Currency 2.
GMR-RPT-BEG-BAL-1 Signed 18.2 GL67.1
Element: Intl Amt The beginning balance amount for
balance sheet accounts for Report
Currency 1.
GMR-RPT-BEG-BAL-2 Signed 18.2 GL67.1
Element: Intl Amt The beginning balance amount for
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
|
