Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             GLMASTER FILE

                     General Ledger Account Master

This file contains the chart of accounts. All Lawson subsystems verify the
existence of accounts against this file. The Chart of Accounts, Level
Reorganization, Mass Account Addition, and Mass Account Change Delete are the
primary programs that create and maintain information in the file.


REFERENCED BY

AC121     AC123     AC130     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC32.1    AC490     ACVW.1    AM180
CA10.5    CA10.1    CA10.7    CA110     FB100     FB11.1
FB195     FB20.1    FB20.6    FB20.7    FB20.4    FB20.3
FB21.1    FB211     FB296     FB95.1    FB95.2    FB95.3
FB95.4    FB95.5    FB95.6    GL191     GL298     GL94.1
GL94.2    GL94.3    GL94.4    GL94.5    GL94.6    GL94.7
GL95.1    GL95.2    GL95.3    GL95.4    GL95.5    GL95.6
GL95.7    GL95.8    GL95.9    GL96.1    GL96.2    GL96.3
GL96.4    GL96.5    GL97.1    GL97.2    GL97.3    GL97.4
GL97.5    GL97.6    GL97.7    GL97.8    GL97.9    GL98.1
GL98.2    GL98.3    GL98.4    GL98.5    GL99.1    GL99.2
GL99.3    GL99.4    GL99.5    GL99.6    RW100     RW230
RW270     RW30.1    RW70.1    GL222     GLAV.1    GLCV.1
GLRV.1    GLVW.1    SLVW.1    CA195     DA290     FB190
FB40.1    FB40.2    FB40.3    GL130     GL141     GL170
GL288     GL35.1    GL70.2    GL70.5    GL75.1    GL90.1
GL90.2    GL90.4    HCGL.1    HGLM.1    IC02.1    GL10.1
GL14.8    GL221     GL38.1    MX135     SLSE.1    GL50.4
FB120     GL281     GL291     GL100     GL00.3    GL00.7
GL00.2    GL02.1    GL02.2    AP125     AP126     AP25.1
AP25.2    AP26.1    AP27.1    CB10.1    CB191     CB20.1
CB30.1    CB500     EE135     EE35.1    EE35.2    EE520
GL165     GL65.1    POIM.1

UPDATED BY

AC191     FB45.1    GL110     GL120     GL122     GL135
GL146     GL167     GL190     GL195     GL196     GL197
GL199     GL30.1    GL330     GL40.1    GL40.2    GL40.3
GL40.7    GL40.8    GL44.1    GL45.1    GL500     IC222
CU03.1    GL03.6    GL121     GL124     GL20.2    GL20.4
GL25.1    IFAC.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

GLM-COMPANY          Numeric 4                                   AC191   FB45.1
Company              The company number.                         GL110   GL121
                                                                 GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IC222   IFAC.1
                                                                 RW100

GLM-VAR-LEVELS       Alpha 30                                    AC191   FB45.1
Variable Levels      Required. The variable level number is      GL120   GL121
                     tied directly to the accounting unit. It    GL124   GL135
                     is used to indicate an accounting unit's    GL167   GL190
                     position within the company hierarchy,      GL195   GL196
                     establishing its consolidation              GL199   GL20.2
                     relationship with other units. Must be      GL20.4  GL330
                     defined in the GLNAMES file as a posting    GL45.1  GL500
                     level.                                      IC222   IFAC.1


GLM-ACCT-UNIT        Alpha 15                                    AC191   FB45.1
Accounting Unit      The accounting unit is a shorthand          GL121   GL124
                     notation representing the variable level    GL135   GL167
                     number.                                     GL190   GL195
                                                                 GL196   GL199
                                                                 GL20.2  GL20.4
                                                                 GL330   GL45.1
                                                                 GL500   IC222
                                                                 IFAC.1

GLM-OLD-COMPANY-D    Derived
Old Company          Contains the old company derived.

GLM-ACCOUNT          Numeric 6                                   AC191   FB45.1
Account              This field along with the accounting        GL121   GL124
                     unit and subaccount make up the location    GL135   GL167
                     (account) where amounts and other           GL190   GL195
                     account information is stored.              GL196   GL199
                                                                 GL20.2  GL20.4
                                                                 GL330   GL45.1
                                                                 GL500   IC02.1
                                                                 IC222   IFAC.1
                                                                 RW100

GLM-SUB-ACCOUNT      Numeric 4                                   AC191   FB45.1
Subaccount           This field along with the accounting        GL121   GL124
                     unit and account make up the location       GL135   GL167
                     (account) where amounts and other           GL190   GL195
                     account information are stored.             GL196   GL199
                                                                 GL20.2  GL20.4
                                                                 GL330   GL45.1
                                                                 GL500   IC02.1
                                                                 IC222   IFAC.1

GLM-OLD-ACCT-NBR-D   Derived
Old Account Number   Contains the derived old account
                     number.


GLM-ACTIVE-STATUS    Alpha 1                                     GL121   GL122
Active Status        Required field if a detail-type             GL124   GL167
                     account, otherwise this field should be     GL20.2
                     blank. Indicates if a detail account is
                     either active or inactive. Inactive
                     accounts cannot be used for posting.

                     " " = Default
                     I = Inactive

GLM-STATUS-DERIVED   Derived
Status               Contains the derived status.

GLM-ACCT-ND          Numeric 1                                   AC191   FB45.1
Account Number of    Account amount decimal positions.           GL110   GL121
Decimals                                                         GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IC222   IFAC.1

GLM-UNITS-CODE       Alpha 1                                     GL121   GL122
Units Code           Required if a detail-type account. This     GL124   GL146
                     field indicates if units are allowed,       GL167   GL190
                     not allowed, or only allowed.               GL197   GL20.2
                                                                 GL40.1  GL40.2
                     " " = Default                               GL40.3  GL40.7
                     Y = Yes                                     GL40.8  GL44.1
                     N = No                                      GL45.1
                     O = Only Units

GLM-UNITS-DERIVED    Derived
Units                Contains the derived units.

GLM-AVG-DAILY-BAL    Alpha 1                                     GL121   GL122
Average Daily        Yes value indicates the account is used     GL20.2
Balance              for calculating average daily balance.

                     " " = No
                     N = No
                     Y = Yes
                     I = Inactive

GLM-ACTIVITY-REQ     Alpha 1                                     GL121   GL122
Activity Required    Indicates if an Activity code is            GL124   GL20.2
                     required.

                     Y = Yes
                     N = No
                     " " = Default

GLM-GLINTCO-STAT     Numeric 3                                   CU03.1  GL110
Intercompany Status  Not required. This field is used to         GL121   GL20.4
                     count the number of intercompany or         GL25.1  GL30.1
                     interzone relationships using this
                     account number. Accounts cannot be
                     deleted if this field is greater than
                     zero.


GLM-POSTING-LEVEL    Alpha 1                                     GL121   GL122
Posting Level        Required if a detail-type account. This     GL124   GL20.2
                     field is used to determine whether
                     interface transactions should be
                     combined when creating GLTRANS records.

                     " " = Default
                     D = Detail
                     S = Summary

GLM-OPTION-FLD-1     Alpha 2  (Lower Case)                       GL121   GL122
                     Free-form field used to store any           GL124   GL167
                     information relevant to an account. This    GL20.2  RW100
                     field is used for reporting purposes.


GLM-OPTION-FLD-2     Alpha 7  (Lower Case)                       GL121   GL122
                     Free-form field used to store               GL124   GL167
                     information relevant to an account. This    GL20.2  RW100
                     field is used for reporting purposes.


GLM-OPTION-FLD-3     Alpha 12  (Lower Case)                      GL121   GL122
                     Free-form field used to store any           GL124   GL167
                     information relevant to an account. This    GL20.2  RW100
                     field is used for reporting purposes.


GLM-TRANSL-CODE      Alpha 2                                     FB195   GL121
                     Contains the translation code.              GL122   GL124
                                                                 GL135   GL167
                                                                 GL191   GL195
                                                                 GL196   GL20.2

GLM-CURRENCY-CODE    Alpha 5                                     AC191   FB45.1
Currency Code        The company base currency code.             GL110   GL121
                                                                 GL122   GL124
                                                                 GL135   GL167
                                                                 GL190   GL195
                                                                 GL196   GL199
                                                                 GL20.2  GL20.4
                                                                 GL330   GL45.1
                                                                 GL500   IC222
                                                                 IFAC.1

GLM-CURR-CONTROL     Alpha 1                                     GL121   GL122
Currency Control     Flag used to allow posting                  GL124   GL20.2
                     to the account in currencies other than

                     the account currency.
                     " " = Default
                     0 = No
                     1 = Yes

GLM-REVALUE          Alpha 1                                     GL121   GL122
Revalue              Determines whether or not this account      GL124   GL20.2
                     will participate in the revaluation
                     process.
                     " " = Default
                     0 = No
                     1 = Yes

GLM-DATE-ENTERED     Numeric 8  (yyyymmdd)                       AC191   FB45.1
Date Entered         Date used to document account changes.      GL121   GL124
                                                                 GL135   GL167
                                                                 GL190   GL195
                                                                 GL196   GL199
                                                                 GL20.2  GL20.4
                                                                 GL330   GL45.1
                                                                 GL500   IC222
                                                                 IFAC.1

GLM-CHART-NAME       Alpha 12                                    AC191   FB45.1
Chart Name           This is the name assigned to the chart      GL121   GL124
                     of accounts when you defined your           GL135   GL167
                     company structure in the Lawson General     GL190   GL195
                     Ledger system.                              GL196   GL199
                                                                 GL20.2  GL20.4
                                                                 GL330   GL45.1
                                                                 GL500   IC02.1
                                                                 IC222   IFAC.1

GLM-BASE-CURRENCY    Alpha 5                                     AC191   FB45.1
Base Currency        The company base currency.                  GL110   GL121
                                                                 GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IC222   IFAC.1

GLM-RESTRICT-SYS     Alpha 1                                     GL03.6  GL121
Restrict System      Indicates if system codes are validated     GL122   GL124
                     each time the account is used by a          GL20.2
                     system.

                     Y = Yes
                     N = No
                     " " = Default

GLM-ACCT-CATEGORY    Alpha 5                                     GL121   GL122
Account Category     Account categories are groupings of         GL124   GL20.2
                     costs, revenues, or a combination of
                     both used for reporting and inquiries
                     for activities in the Activity
                     Management system. All transactions are
                     posted to an account category within an
                     activity. You can assign a specific
                     General Ledger account or range of
                     accounts (company, accounting unit,
                     account, and subaccount) that make up
                     the transactions posted to an account
                     category using AC07.1 (Account
                     Assignment).

                     Period-to-date, year-to-date, and
                     life-to-date balances are maintained by
                     account category for activities. Account
                     categories must be assigned to
                     activities before you do any budgeting
                     or transaction processing.



GLM-DER-X-SYS        Derived
Der X Sys            Indicates if system restrictions exist
                     for an account.


GLM-SUMM-ACCT-ID     Derived
Summary Account ID   The summary account ID.

GLM-ACCT-DESC        Derived
Account Description  This is the account description.

GLM-BLANK            Derived
Blank                This derived field is always blank. It
                     is used in the Drill Around feature for
                     column headings.

GLM-CUCODE-DESC      Derived
Cucode Desc          This is the currency code description.

GLM-SL-ACCT-FLAG     Alpha 1                                     GL122   GL20.2
Strategic Ledger     This flag determines whether user
                     analysis values can be assigned to a
                     specific account. You can select Yes,
                     No, or use the Summary Account
                     selection.

                     Y = Yes
                     N = No
                     " " = Default

GLM-RELATION         Alpha 15                                    GL122   GL20.2
User Analysis        The user analysis value relation
Relation             assigned to the detail or summary
                     account.

                     The relation must exist in SL02.1 (User
                     Analysis Value Relation).

GLM-LEDGER-GROUP     Alpha 15                                    GL122   GL20.2
Ledger Group

GLM-GL-BUD-FL        Alpha 1                                     GL122   GL20.2
Gl Bud Fl            N = No Edit
                     Y = Yes
                     " " = Default

                         GLMASTER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GLMSET1   COMPANY       This path is used to retrieve chart of   AC121   AC123
          ACCOUNT       accounts records by variable level then  AC130   AC20.1
          SUB-ACCOUNT   accounting unit.                         AC20.2  AC20.3
          VAR-LEVELS                                             AC20.4  AC20.5
          ACCT-UNIT                                              AC32.1  AC490
                                                                 ACVW.1  AM180
                                                                 CA10.5  CA110
                                                                 FB100   FB11.1
                                                                 FB195   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB95.1
                                                                 FB95.2  FB95.3
                                                                 FB95.4  FB95.5
                                                                 FB95.6  GL110
                                                                 ...

GLMSET2   COMPANY       This path is used to retrieve chart of   AC191   CA10.1
          ACCT-UNIT     accounts records by accounting unit      CA10.7  CA110
          ACCOUNT       without regard to variable level.        CA195   DA290
          SUB-ACCOUNT                                            FB11.1  FB190
                                                                 FB195   FB20.4
                                                                 FB211   FB296
                                                                 FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL110   GL120
                                                                 GL122   GL130
                                                                 GL135   GL141
                                                                 GL146   GL167
                                                                 ...

GLMSET3   COMPANY       This path is used to retrieve chart of   DA290   FB20.3
          ACCOUNT       accounts records by account without      GL50.4  RW100
          SUB-ACCOUNT   regard to accounting unit.               GL121   GL20.4
          ACCT-UNIT                                              GL222

GLMSET5   COMPANY       This path is used to retrieve only       CA110   FB11.1
          VAR-LEVELS    Detail Type chart of accounts records by FB120   FB211
          ACCOUNT       variable level without regard for        FB296   FB95.1
          SUB-ACCOUNT   accounting units.                        FB95.2  FB95.3
          ACCT-UNIT                                              FB95.4  FB95.5
                                                                 FB95.6  GL281
                                                                 GL291   GL298
                                                                 GL94.1  GL94.2
                                                                 GL94.3  GL94.4
                                                                 GL94.5  GL94.6
                                                                 GL94.7  GL95.1
                                                                 GL95.2  GL95.3
                                                                 GL95.4  GL95.5
                                                                 GL95.6  GL95.7
                                                                 GL95.8  GL95.9
                                                                 ...

GLMSET6   VAR-LEVELS    This path is used to retrieve only       GLRV.1
          ACCOUNT       Detail Type chart of accounts records by
          SUB-ACCOUNT   variable levels and account.
          COMPANY
          ACCT-UNIT

GLMSET7   ACCOUNT       This path is used to retrieve only       FB11.1  FB211
          SUB-ACCOUNT   Detail Type chart of accounts by account FB296   FB95.1
          VAR-LEVELS    and subaccount.                          FB95.2  FB95.3
          COMPANY                                                FB95.4  FB95.5
          ACCT-UNIT                                              FB95.6  GL100
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 ...

GLMSET8   CHART-NAME                                             AC191   AP125
          ACCOUNT                                                AP126   AP25.1
          SUB-ACCOUNT                                            AP25.2  AP26.1
          COMPANY                                                AP27.1  CB10.1
          ACCT-UNIT                                              CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 CA110   FB190
                                                                 FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 GL100   GL146
                                                                 GL165   GL170
                                                                 GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 ...

GLMSET9   LEDGER-GROUP  KeyChange, Subset
          COMPANY       Where LEDGER-GROUP != Spaces
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          ACCT-UNIT

                         GLMASTER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accountunit    GLNAMES      Required

                            GLM-COMPANY          -> GLN-COMPANY  (GLNSET1)
                            GLM-ACCT-UNIT        -> GLN-ACCT-UNIT

Acct Unit      GLNAMES      Required

                            GLM-COMPANY          -> GLN-COMPANY
                            GLM-ACCT-UNIT        -> GLN-ACCT-UNIT

Budget 1       FBDETAIL     Not Required

                            GLM-COMPANY          -> FBD-COMPANY
                            GLS-FISCAL-YEAR      -> FBD-FISCAL-YEAR
                            1                    -> FBD-BUDGET-NBR
                            GLM-ACCT-UNIT        -> FBD-ACCT-UNIT
                            GLM-ACCOUNT          -> FBD-ACCOUNT
                            GLM-SUB-ACCOUNT      -> FBD-SUB-ACCOUNT

Chart Detail   GLCHARTDTL   Required

                            GLM-CHART-NAME       -> GDT-CHART-NAME
                            GLM-ACCOUNT          -> GDT-ACCOUNT
                            GLM-SUB-ACCOUNT      -> GDT-SUB-ACCOUNT

Company        GLSYSTEM     Required

                            GLM-COMPANY          -> GLS-COMPANY

Consol         GLCONSOL     Not Required

                            GLS-FISCAL-YEAR      -> GCN-FISCAL-YEAR
                            Zeroes               -> GCN-LEVEL-DEPTH
                            Zeroes               -> GCN-BUDGET-NBR
                            "A"                  -> GCN-TRANS-TYPE
                            GLM-COMPANY          -> GCN-COMPANY
                            Spaces               -> GCN-VAR-LEVELS
                            GLM-ACCOUNT          -> GCN-ACCOUNT
                            GLM-SUB-ACCOUNT      -> GCN-SUB-ACCOUNT
                            Spaces               -> GCN-CURRENCY-CODE

Cucodes        CUCODES      Required

                            GLM-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Summary Acct   GLCHARTSUM   Required

                            GLM-CHART-NAME       -> GCS-CHART-NAME
                            GDT-SUMRY-ACCT-ID    -> GCS-SUMRY-ACCT-ID

Trcodes        TRCODES      Required
                            When GLM-TRANSL-CODE = Spaces

                            GLM-TRANSL-CODE      -> TRC-TRANSL-CODE

Var Levels     GLNAMES      Required

                            GLM-COMPANY          -> GLN-COMPANY
                            GLM-VAR-LEVELS       -> GLN-VAR-LEVELS
                            GLM-ACCT-UNIT        -> GLN-ACCT-UNIT

Variablelevel  GLNAMES      Required

                            GLM-COMPANY          -> GLN-COMPANY
                            GLM-VAR-LEVELS       -> GLN-VAR-LEVELS
                            GLM-ACCT-UNIT        -> GLN-ACCT-UNIT

                         GLMASTER FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amounts        GLAMOUNTS    Delete Restricted

                            GLM-COMPANY          -> GAM-COMPANY
                            GLM-ACCT-UNIT        -> GAM-ACCT-UNIT
                            GLM-ACCOUNT          -> GAM-ACCOUNT
                            GLM-SUB-ACCOUNT      -> GAM-SUB-ACCOUNT
                                                    GAM-FISCAL-YEAR

Budget All     FBDETAIL     Delete Restricted

                            GLM-COMPANY          -> FBD-COMPANY
                            GLM-ACCT-UNIT        -> FBD-ACCT-UNIT
                            GLM-ACCOUNT          -> FBD-ACCOUNT
                            GLM-SUB-ACCOUNT      -> FBD-SUB-ACCOUNT
                                                    FBD-BUDGET-NBR
                                                    FBD-FISCAL-YEAR

Budgets        FBDETAIL     Delete Restricted

                            GLM-COMPANY          -> FBD-COMPANY
                            GLM-ACCT-UNIT        -> FBD-ACCT-UNIT
                            GLM-ACCOUNT          -> FBD-ACCOUNT
                            GLM-SUB-ACCOUNT      -> FBD-SUB-ACCOUNT
                                                    FBD-BUDGET-NBR
                                                    FBD-FISCAL-YEAR

Cuamount1      CUAMOUNT     Delete Cascades

                            GLM-COMPANY          -> CAM-COMPANY
                            GLM-ACCT-UNIT        -> CAM-ACCT-UNIT
                            GLM-ACCOUNT          -> CAM-ACCOUNT
                            GLM-SUB-ACCOUNT      -> CAM-SUB-ACCOUNT
                            1                    -> CAM-AMT-TYPE
                            GLM-CURRENCY-CODE    -> CAM-CURRENCY-CODE
                                                    CAM-FISCAL-YEAR
                                                    CAM-VAR-LEVELS

Cuamount2      CUAMOUNT     Delete Cascades

                            GLM-COMPANY          -> CAM-COMPANY
                            GLM-ACCT-UNIT        -> CAM-ACCT-UNIT
                            GLM-ACCOUNT          -> CAM-ACCOUNT
                            GLM-SUB-ACCOUNT      -> CAM-SUB-ACCOUNT
                            2                    -> CAM-AMT-TYPE
                                                    CAM-CURRENCY-CODE
                                                    CAM-FISCAL-YEAR
                                                    CAM-VAR-LEVELS

Cuamount3      CUAMOUNT     Delete Cascades

                            GLM-COMPANY          -> CAM-COMPANY
                            GLM-ACCT-UNIT        -> CAM-ACCT-UNIT
                            GLM-ACCOUNT          -> CAM-ACCOUNT
                            GLM-SUB-ACCOUNT      -> CAM-SUB-ACCOUNT
                            3                    -> CAM-AMT-TYPE
                            GLS-CURR-CODE-1      -> CAM-CURRENCY-CODE
                                                    CAM-FISCAL-YEAR
                                                    CAM-VAR-LEVELS

Cuamount4      CUAMOUNT     Delete Cascades

                            GLM-COMPANY          -> CAM-COMPANY
                            GLM-ACCT-UNIT        -> CAM-ACCT-UNIT
                            GLM-ACCOUNT          -> CAM-ACCOUNT
                            GLM-SUB-ACCOUNT      -> CAM-SUB-ACCOUNT
                            4                    -> CAM-AMT-TYPE
                            GLS-CURR-CODE-2      -> CAM-CURRENCY-CODE
                                                    CAM-FISCAL-YEAR
                                                    CAM-VAR-LEVELS

Cuamountx 3    CUAMOUNTX

                            GLM-COMPANY          -> CAX-COMPANY
                            3                    -> CAX-AMT-TYPE
                            GLM-ACCT-UNIT        -> CAX-ACCT-UNIT
                            GLM-ACCOUNT          -> CAX-ACCOUNT
                            GLM-SUB-ACCOUNT      -> CAX-SUB-ACCOUNT
                                                    CAX-DATE

Cuamountx 4    CUAMOUNTX

                            GLM-COMPANY          -> CAX-COMPANY
                            4                    -> CAX-AMT-TYPE
                            GLM-ACCT-UNIT        -> CAX-ACCT-UNIT
                            GLM-ACCOUNT          -> CAX-ACCOUNT
                            GLM-SUB-ACCOUNT      -> CAX-SUB-ACCOUNT
                                                    CAX-DATE

Dailytrans     GLAMOUNTSX

                            GLM-COMPANY          -> GAX-COMPANY
                            GLM-ACCT-UNIT        -> GAX-ACCT-UNIT
                            GLM-ACCOUNT          -> GAX-ACCOUNT
                            GLM-SUB-ACCOUNT      -> GAX-SUB-ACCOUNT
                                                    GAX-DATE

Glacctvld Gcs  GLACCTVLD

                            "S"                  -> VLD-RECORD-TYPE
                            GLS-CHART-NAME       -> VLD-CHART-NAME
                            GDT-SUMRY-ACCT-ID    -> VLD-SUMRY-ACCT-ID
                            Zeroes               -> VLD-ACCOUNT
                            Zeroes               -> VLD-SUB-ACCOUNT
                            Zeroes               -> VLD-COMPANY
                            Spaces               -> VLD-ACCT-UNIT
                                                    VLD-SYSTEM

Glacctvld Gdt  GLACCTVLD

                            GLS-CHART-NAME       -> VLD-CHART-NAME
                            GLM-ACCOUNT          -> VLD-ACCOUNT
                            GLM-SUB-ACCOUNT      -> VLD-SUB-ACCOUNT
                                                    VLD-SYSTEM

Glacctvld Glm  GLACCTVLD

                            GLM-COMPANY          -> VLD-COMPANY
                            GLM-ACCT-UNIT        -> VLD-ACCT-UNIT
                            GLM-ACCOUNT          -> VLD-ACCOUNT
                            GLM-SUB-ACCOUNT      -> VLD-SUB-ACCOUNT
                                                    VLD-SYSTEM

Glacctvld Sys  GLACCTVLD

                            "M"                  -> VLD-RECORD-TYPE
                            GLM-CHART-NAME       -> VLD-CHART-NAME
                            GDT-SUMRY-ACCT-ID    -> VLD-SUMRY-ACCT-ID
                            GLM-ACCOUNT          -> VLD-ACCOUNT
                            GLM-SUB-ACCOUNT      -> VLD-SUB-ACCOUNT
                            GLM-COMPANY          -> VLD-COMPANY
                            GLM-ACCT-UNIT        -> VLD-ACCT-UNIT
                                                    VLD-SYSTEM

Othr Acct Unit GLMASTER

                            GLM-COMPANY          -> GLM-COMPANY
                            GLM-ACCOUNT          -> GLM-ACCOUNT
                            GLM-SUB-ACCOUNT      -> GLM-SUB-ACCOUNT
                                                    GLM-VAR-LEVELS
                                                    GLM-ACCT-UNIT

Trans All Prds GLTRANS

                            GLM-COMPANY          -> GLT-TO-COMPANY
                            GLM-ACCOUNT          -> GLT-ACCOUNT
                            GLM-SUB-ACCOUNT      -> GLT-SUB-ACCOUNT
                            GLM-ACCT-UNIT        -> GLT-ACCT-UNIT
                            GLS-FISCAL-YEAR      -> GLT-FISCAL-YEAR
                                                    GLT-ACCT-PERIOD
                                                    GLT-SYSTEM
                                                    GLT-CONTROL-GROUP
                                                    GLT-JE-TYPE
                                                    GLT-JE-SEQUENCE
                                                    GLT-LINE-NBR
                                                    GLT-COMPANY

Transactions   GLTRANS

                            GLM-COMPANY          -> GLT-TO-COMPANY
                            GLS-FISCAL-YEAR      -> GLT-FISCAL-YEAR
                            GLS-ACCT-PERIOD      -> GLT-ACCT-PERIOD
                            GLM-ACCT-UNIT        -> GLT-ACCT-UNIT
                            GLM-ACCOUNT          -> GLT-ACCOUNT
                            GLM-SUB-ACCOUNT      -> GLT-SUB-ACCOUNT
                                                    GLT-POSTING-DATE
                                                    GLT-SYSTEM
                                                    GLT-CONTROL-GROUP
                                                    GLT-JE-TYPE
                                                    GLT-LINE-NBR
                                                    GLT-COMPANY
                                                    GLT-JE-SEQUENCE

Units          GLUNITS      Delete Restricted

                            GLM-COMPANY          -> GLU-COMPANY
                            GLM-ACCOUNT          -> GLU-ACCOUNT
                            GLM-SUB-ACCOUNT      -> GLU-SUB-ACCOUNT
                            GLM-VAR-LEVELS       -> GLU-VAR-LEVELS
                            GLM-ACCT-UNIT        -> GLU-ACCT-UNIT
                                                    GLU-FISCAL-YEAR