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
ATVW.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    SNOA.1    SNRA.1    SNSA.1    ET530     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     PR195     PR197
PR82.1    PR85.1    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    AP170
AP193     AP30.2    AP520     BR41.4    CB10.1    CB15.1
CB15.2    CB150     CB191     CB20.1    CB30.1    CB45.1
CB46.1    CB500     CB543     CB544     CB55.1    CB554
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    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    API1.1    API2.1    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     CU03.1
GL03.6    GL121     GL124     GL20.2    GL20.4    GL25.1
IFAC.1    MA41.1    MA41.2    MA41.4    MA41.7    MA43.2
MA61.1    MAI1.1    RQ10.1    RQ10.3    RQ11.1    RQ13.2
RQ35.1    RQ500     RQIB.1    RQIF.1    RQIJ.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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR44.1
                                                                 FB45.1  GL110
                                                                 GL121   GL124
                                                                 GL135   GL167
                                                                 GL190   GL195
                                                                 GL196   GL199
                                                                 GL20.2  GL20.4
                                                                 GL330   GL45.1
                                                                 GL500   IFAC.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ13.2  RQ35.1
                                                                 RQ500   RQIB.1
                                                                 RQIF.1  RQIJ.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  AP21.1
                       establishing its consolidation            AP23.1  AP25.1
                       relationship with other units. Must be    AP25.2  AP26.1
                       defined in the GLNAMES file as a posting  AP27.1  API1.1
                       level.                                    API2.1  BR44.1
                                                                 FB45.1  GL120
                                                                 GL121   GL124
                                                                 GL135   GL167
                                                                 GL190   GL195
                                                                 GL196   GL199
                                                                 GL20.2  GL20.4
                                                                 GL330   GL45.1
                                                                 GL500   IFAC.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ13.2  RQ35.1
                                                                 RQ500   RQIB.1
                                                                 RQIF.1  RQIJ.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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR44.1
                                                                 FB45.1  GL121
                                                                 GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IFAC.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQIJ.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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR44.1
                                                                 FB45.1  GL121
                                                                 GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IC02.1  IFAC.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ13.2  RQ35.1
                                                                 RQ500   RQIB.1
                                                                 RQIF.1  RQIJ.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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR44.1
                                                                 FB45.1  GL121
                                                                 GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IC02.1  IFAC.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ13.2  RQ35.1
                                                                 RQ500   RQIB.1
                                                                 RQIF.1  RQIJ.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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR44.1
                                                                 FB45.1  GL110
                                                                 GL121   GL124
                                                                 GL135   GL167
                                                                 GL190   GL195
                                                                 GL196   GL199
                                                                 GL20.2  GL20.4
                                                                 GL330   GL45.1
                                                                 GL500   IFAC.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ13.2  RQ35.1
                                                                 RQ500   RQIB.1
                                                                 RQIF.1  RQIJ.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   AP125
Element: Currency Code The company base currency code.           AP126   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR44.1
                                                                 FB45.1  GL110
                                                                 GL121   GL122
                                                                 GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IFAC.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQIJ.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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR44.1
                                                                 FB45.1  GL121
                                                                 GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IFAC.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQIJ.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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR44.1
                                                                 FB45.1  GL121
                                                                 GL124   GL135
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.2
                                                                 GL20.4  GL330
                                                                 GL45.1  GL500
                                                                 IC02.1  IFAC.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ13.2  RQ35.1
                                                                 RQ500   RQIB.1
                                                                 RQIF.1  RQIJ.1

GLM-BASE-CURRENCY      Alpha 5                                   AC191   AP125
Element: Base Currency This field contains the company base      AP126   AP20.1
                       currency code established in Company      AP20.2  AP20.3
                       (GL10.1 ).                                AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR44.1
                                                                 FB45.1  GL110
                                                                 GL121   GL124
                                                                 GL135   GL167
                                                                 GL190   GL195
                                                                 GL196   GL199
                                                                 GL20.2  GL20.4
                                                                 GL330   GL45.1
                                                                 GL500   IFAC.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ13.2  RQ35.1
                                                                 RQ500   RQIB.1
                                                                 RQIF.1  RQIJ.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: Sl Acct Flag  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
Element: Relation      The user analysis value 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                                                AC121   AC123
          ACCOUNT                                                AC130   AC20.1
          SUB-ACCOUNT                                            AC20.2  AC20.3
          VAR-LEVELS                                             AC20.4  AC20.5
          ACCT-UNIT                                              AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 ATVW.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
                                                                 ...

GLMSET2   COMPANY                                                AC191   AP125
          ACCT-UNIT                                              AP126   AP20.1
          ACCOUNT                                                AP20.2  AP20.3
          SUB-ACCOUNT                                            AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR44.1
                                                                 ET530   CA10.1
                                                                 CA10.7  CA110
                                                                 FB11.1  FB111
                                                                 FB145   FB160
                                                                 FB190   FB195
                                                                 FB20.4  FB211
                                                                 ...

GLMSET3   COMPANY                                                FB20.3  GL120
          ACCOUNT                                                GL50.4  RW100
          SUB-ACCOUNT                                            GL121   GL20.4
          ACCT-UNIT                                              GL222

GLMSET5   COMPANY                                                CA110   FB11.1
          VAR-LEVELS                                             FB111   FB120
          ACCOUNT                                                FB160   FB211
          SUB-ACCOUNT                                            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                                             GLRV.1
          ACCOUNT
          SUB-ACCOUNT
          COMPANY
          ACCT-UNIT

GLMSET7   ACCOUNT                                                FB11.1  FB111
          SUB-ACCOUNT                                            FB160   FB211
          VAR-LEVELS                                             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                                                AP170   AP193
          ACCT-UNIT                                              AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP520
                                                                 API1.1  API2.1
                                                                 BR41.4  BR44.1
                                                                 CB10.1  CB15.1
                                                                 CB15.2  CB150
                                                                 ...

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