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     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    FB145
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    GL90.5    HCGL.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    BR41.4    CB10.1
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     AP125     AP126     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    API1.1    API2.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    MA41.2
MA41.7    MA43.2    MA61.1    MAI1.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GLM-COMPANY            Numeric 4                                 AC191   AP125
Element: Company       The company number.                       AP126   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 API1.1  API2.1
                                                                 FB45.1  GL110
                                                                 GL121   GL124
                                                                 GL135   GL167
                                                                 GL190   GL195
                                                                 GL196   GL199
                                                                 GL20.2  GL20.4
                                                                 GL330   GL45.1
                                                                 GL500   IC222
                                                                 IFAC.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1
                                                                 RW100

GLM-VAR-LEVELS         Alpha 30                                  AC191   AP125
Element: Variable LevelRequired. The variable level number is    AP126   AP20.1
                       tied directly to the accounting unit. It  AP20.2  AP20.3
                       is used to indicate an accounting unit's  AP20.4  AP20.5
                       position within the company hierarchy,    AP20.7  AP23.1
                       establishing its consolidation            AP25.1  AP25.2
                       relationship with other units. Must be    AP26.1  AP27.1
                       defined in the GLNAMES file as a posting  API1.1  API2.1
                       level.                                    FB45.1  GL120
                                                                 GL121   GL124
                                                                 GL135   GL167
                                                                 GL190   GL195
                                                                 GL196   GL199
                                                                 GL20.2  GL20.4
                                                                 GL330   GL45.1
                                                                 GL500   IC222
                                                                 IFAC.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

GLM-ACCT-UNIT          Alpha 15                                  AC191   AP125
Element: Accounting UniThe accounting unit is a shorthand        AP126   AP20.1
                       notation representing the variable level  AP20.2  AP20.3
                       number.                                   AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 API1.1  API2.1
                                                                 FB45.1  GL121
                                                                 GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IC222   IFAC.1
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1

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

GLM-ACCOUNT            Numeric 6                                 AC191   AP125
Element: Account       This field along with the accounting      AP126   AP20.1
                       unit and subaccount make up the location  AP20.2  AP20.3
                       (account) where amounts and other         AP20.4  AP20.5
                       account information is stored.            AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 API1.1  API2.1
                                                                 FB45.1  GL121
                                                                 GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IC02.1  IC222
                                                                 IFAC.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1
                                                                 RW100

GLM-SUB-ACCOUNT        Numeric 4                                 AC191   AP125
Element: Subaccount    This field along with the accounting      AP126   AP20.1
                       unit and account make up the location     AP20.2  AP20.3
                       (account) where amounts and other         AP20.4  AP20.5
                       account information are stored.           AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 API1.1  API2.1
                                                                 FB45.1  GL121
                                                                 GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IC02.1  IC222
                                                                 IFAC.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.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   AP125
Account Number of      Account amount decimal positions.         AP126   AP20.1
Decimals                                                         AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 API1.1  API2.1
                                                                 FB45.1  GL110
                                                                 GL121   GL124
                                                                 GL135   GL167
                                                                 GL190   GL195
                                                                 GL196   GL199
                                                                 GL20.2  GL20.4
                                                                 GL330   GL45.1
                                                                 GL500   IC222
                                                                 IFAC.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.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                                   GL40.8  GL44.1
                       N = No                                    GL45.1
                       O = Only Units

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  GL110
Element: Intercompany SNot 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
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                                   FB195   GL121
Element:               Contains the translation code.            GL122   GL124
                                                                 GL135   GL167
                                                                 GL191   GL195
                                                                 GL196   GL20.2

GLM-CURRENCY-CODE      Alpha 5                                   AC191   AP125
Element: Currency Code The company base currency code.           AP126   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 API1.1  API2.1
                                                                 FB45.1  GL110
                                                                 GL121   GL122
                                                                 GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IC222   IFAC.1
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.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   AP125
Element: Date Entered  Date used to document account changes.    AP126   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 API1.1  API2.1
                                                                 FB45.1  GL121
                                                                 GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IC222   IFAC.1
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1

GLM-CHART-NAME         Alpha 12                                  AC191   AP125
Element: Chart Name    This is the name assigned to the chart    AP126   AP20.1
                       of accounts when you defined your         AP20.2  AP20.3
                       company structure in the Lawson General   AP20.4  AP20.5
                       Ledger system.                            AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 API1.1  API2.1
                                                                 FB45.1  GL121
                                                                 GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IC02.1  IC222
                                                                 IFAC.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

GLM-BASE-CURRENCY      Alpha 5                                   AC191   AP125
Element: Base Currency                                           AP126   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 API1.1  API2.1
                                                                 FB45.1  GL110
                                                                 GL121   GL124
                                                                 GL135   GL167
                                                                 GL190   GL195
                                                                 GL196   GL199
                                                                 GL20.2  GL20.4
                                                                 GL330   GL45.1
                                                                 GL500   IC222
                                                                 IFAC.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.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.

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
                                                                 FB195   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB95.1
                                                                 FB95.2  FB95.3
                                                                 FB95.4  FB95.5
                                                                 ...

GLMSET2   COMPANY       This path is used to retrieve chart of   AC191   AP125
          ACCT-UNIT     accounts records by accounting unit      AP126   AP20.1
          ACCOUNT       without regard to variable level.        AP20.2  AP20.3
          SUB-ACCOUNT                                            AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 API1.1  API2.1
                                                                 CA10.1  CA10.7
                                                                 CA110   FB11.1
                                                                 FB111   FB145
                                                                 FB190   FB195
                                                                 FB20.4  FB211
                                                                 FB296   FB40.1
                                                                 FB40.2  FB40.3
                                                                 ...

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        FB211   FB296
          SUB-ACCOUNT   accounting units.                        FB95.1  FB95.2
          ACCT-UNIT                                              FB95.3  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
                                                                 ...

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 FB211   FB296
          VAR-LEVELS    and subaccount.                          FB95.1  FB95.2
          COMPANY                                                FB95.3  FB95.4
          ACCT-UNIT                                              FB95.5  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
                                                                 ...

GLMSET8   CHART-NAME    KeyChange                                AC191   AC40.4
          ACCOUNT                                                AC41.4  AC42.1
          SUB-ACCOUNT                                            AP125   AP126
          COMPANY                                                AP20.1  AP20.2
          ACCT-UNIT                                              AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR41.4
                                                                 CB10.1  CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   CA110
                                                                 ...

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