Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLMASTER


                             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    AC37.1    AC490     ACVW.1
AM180     CA10.5    CA10.1    CA10.7    CA110     FB100
FB11.1    FB111     FB160     FB195     FB20.1    FB20.6
FB20.7    FB20.4    FB20.3    FB21.1    FB211     FB296
FB60.1    FB95.1    FB95.2    FB95.3    FB95.4    FB95.5
FB95.6    GL191     GL298     GL90.6    GL90.1    GL90.2
GL90.4    GL90.5    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     FB145     FB190     FB40.1    FB40.2    FB40.3
GL130     GL141     GL170     GL288     GL35.1    GL70.1
GL70.2    GL70.3    GL70.5    GL70.6    GL75.1    HGLM.1
IC02.1    GL10.1    GL14.8    GL221     GL38.1    MX135
PR197     SL40.4    SLSE.1    GL50.4    FB120     GL281
GL291     GL100     GL00.3    GL00.7    GL00.2    GL02.1
GL02.2    AC40.4    AC41.4    AC42.1    AP125     AP126
AP25.1    AP25.2    AP26.1    AP27.1    AP30.2    BR41.4
CB10.1    CB15.1    CB15.2    CB191     CB20.1    CB30.1
CB500     EE135     EE35.1    EE35.2    EE520     GL165
GL65.1    PO150     PO25.1    PO25.6    PO25.7    PO536
POIM.1

UPDATED BY

AC191     BR44.1    FB35.1    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   BR44.1
Element: Company       The company number.                       FB45.1  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   BR44.1
Element: Variable LevelRequired. The variable level number is    FB45.1  GL120
                       tied directly to the accounting unit. It  GL121   GL124
                       is used to indicate an accounting unit's  GL135   GL167
                       position within the company hierarchy,    GL190   GL195
                       establishing its consolidation            GL196   GL199
                       relationship with other units. Must be    GL20.2  GL20.4
                       defined in the GLNAMES file as a posting  GL330   GL45.1
                       level.                                    GL500   IC222
                                                                 IFAC.1

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

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

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

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

GLM-OLD-ACCT-NBR-D     Derived
Element: Old Account NuContains the derived old account
                       number.


GLM-ACTIVE-STATUS      Alpha 1                                   GL121   GL122
Element: 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
Element: Status        Contains the derived status.

GLM-ACCT-ND            Numeric 1                                 AC191   BR44.1
Account Number of      Account amount decimal positions.         FB45.1  GL110
Decimals                                                         GL121   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
Element: 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 - Not Required                    GL40.8  GL44.1
                       N = No                                    GL45.1
                       O = Only Units
                       R = Yes - Required

GLM-UNITS-DERIVED      Derived
Element: 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
Element: Activity RequiIndicates if an Activity code is          GL124   GL20.2
                       required.

                       Y = Yes
                       N = No
                       " " = Default

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


GLM-POSTING-LEVEL      Alpha 1                                   GL121   GL122
Element: 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
Element:               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
Element:               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
Element:               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                                   FB145   FB190
Element:               Contains the translation code.            FB195   FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL121
                                                                 GL122   GL124
                                                                 GL135   GL167
                                                                 GL191   GL195
                                                                 GL196   GL197
                                                                 GL20.2

GLM-CURRENCY-CODE      Alpha 5                                   AC191   BR44.1
Element: Currency Code The company base currency code.           FB45.1  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
Element: Currency ContrFlag 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
Element: 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   BR44.1
Element: Date Entered  Date used to document account changes.    FB45.1  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   BR44.1
Element: Chart Name    This is the name assigned to the chart    FB45.1  GL121
                       of accounts when you defined your         GL124   GL135
                       company structure in the Lawson General   GL167   GL190
                       Ledger system.                            GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IC02.1  IC222
                                                                 IFAC.1

GLM-BASE-CURRENCY      Alpha 5                                   AC191   BR44.1
Element: Base Currency The company base currency.                FB45.1  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
Element: Restrict SysteIndicates 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
Element: Account CategoAccount 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.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

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


GLM-SUMM-ACCT-ID       Derived
Element: Summary AccounThe summary account ID.

GLM-ACCT-DESC          Derived
Element: Account DescriThis is the account description.

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

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

GLM-SL-ACCT-FLAG       Alpha 1                                   GL122   GL20.2
Element: Strategic LedgThis 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
Element: Ledger Group

GLM-GL-BUD-FL          Alpha 1                                   GL122   GL20.2
Element: Gl Bud Fl     This is the Yes/No flag for budget
                       editing.
                       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  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB160   FB195
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB60.1  FB95.1
                                                                 FB95.2  FB95.3
                                                                 ...

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

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

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

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  FB111
          SUB-ACCOUNT   Detail Type chart of accounts by account FB160   FB211
          VAR-LEVELS    and subaccount.                          FB296   FB60.1
          COMPANY                                                FB95.1  FB95.2
          ACCT-UNIT                                              FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL100   GL298
                                                                 GL90.6  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
                                                                 ...

GLMSET8   CHART-NAME    KeyChange                                AC191   AC40.4
          ACCOUNT                                                AC41.4  AC42.1
          SUB-ACCOUNT                                            AP125   AP126
          COMPANY                                                AP25.1  AP25.2
          ACCT-UNIT                                              AP26.1  AP27.1
                                                                 AP30.2  BR41.4
                                                                 BR44.1  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 CA110   FB145
                                                                 FB190   FB40.1
                                                                 FB40.2  FB40.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

Glcommit       GLCOMMIT

                            GLM-COMPANY          -> GOT-COMPANY
                            GLM-ACCT-UNIT        -> GOT-ACCT-UNIT
                            GLM-ACCOUNT          -> GOT-ACCOUNT
                            GLM-SUB-ACCOUNT      -> GOT-SUB-ACCOUNT
                                                    GOT-FISCAL-YEAR
                                                    GOT-SYSTEM

Glcommitx      GLCOMMITX

                            GLM-COMPANY          -> GOX-COMPANY
                            GLM-ACCT-UNIT        -> GOX-ACCT-UNIT
                            GLM-ACCOUNT          -> GOX-ACCOUNT
                            GLM-SUB-ACCOUNT      -> GOX-SUB-ACCOUNT
                                                    GOX-FISCAL-YEAR
                                                    GOX-PERIOD
                                                    GOX-SYSTEM
                                                    GOX-CURRENCY-CODE
                                                    GOX-GLT-OBJ-ID

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