Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLMASTREL


                             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