Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLCONSOL


                             GLCONSOL FILE

                      General Ledger Consolidation

This file contains consolidated account balances for the GLAMOUNTS, CUAMOUNT,
GLUNITS, and FBDETAIL files. Consolidated balances are kept for summary level
accounting units. The purpose of this file is for reporting summary balances.

This file also stores consolidated summary level account balances for the
report currencies.

REFERENCED BY

FB195     GL141     GL195     GLSV.1    GLRV.1    GL288
FB141

UPDATED BY

CA195     FB100     FB101     FB120     FB121     FB122
FB145     FB165     FB190     FB20.1    FB20.2    FB20.3
FB20.4    FB20.6    FB20.7    FB21.1    FB30.1    FB31.1
FB40.1    FB40.2    FB40.3    FB45.1    GL110     GL146
GL148     GL167     GL190     GL197     GL199     GL300
GL320     GL40.1    GL40.2    GL40.3    GL40.7    GL40.8
GL44.1    GL45.1    GL500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GCN-FISCAL-YEAR        Numeric 4                                 CA195   FB100
Element: Fiscal Year   Contains the fiscal year for the data     FB101   FB120
                       stored on this record.                    FB121   FB122
                                                                 FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL146
                                                                 GL148   GL167
                                                                 GL190   GL197
                                                                 GL199   GL320
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GCN-LEVEL-DEPTH        Numeric 1                                 CA195   FB100
Element: Level Depth   The summary level depth.                  FB101   FB120
                       "0" = Company level.                      FB121   FB122
                       "1" = Level 1.                            FB145   FB165
                       "2" = Level 2.                            FB190   FB20.1
                       "3" = Level 3.                            FB20.3  FB20.4
                       "4" = Level 4.                            FB20.6  FB20.7
                       0 = Company                               FB21.1  FB30.1
                       1 = Level 1                               FB31.1  FB40.1
                       2 = Level 2                               FB40.2  FB40.3
                       3 = Level 3                               FB45.1  GL146
                       4 = Level 4                               GL148   GL167
                                                                 GL190   GL197
                                                                 GL199   GL320
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GCN-BUDGET-NBR         Numeric 3                                 CA195   FB100
Element: Budget Number The budget number related to this         FB101   FB120
                       record.                                   FB121   FB122
                                                                 FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL146
                                                                 GL148   GL167
                                                                 GL190   GL197
                                                                 GL199   GL320
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GCN-TRANS-TYPE         Alpha 1                                   CA195   FB100
Element: Trans Type    This field designates the type of         FB101   FB120
                       consolidated balance record.              FB121   FB122
                       The values are:                           FB145   FB165
                       A = Amount                                FB190   FB20.1
                       U = Unit                                  FB20.3  FB20.4
                       B = Budget Amount                         FB20.6  FB20.7
                       C = Currency                              FB21.1  FB30.1
                       N = Budget Unit                           FB31.1  FB40.1
                       Y = Currency One                          FB40.2  FB40.3
                       Z = Currency Two                          FB45.1  GL146
                                                                 GL148   GL167
                                                                 GL190   GL197
                                                                 GL199   GL320
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GCN-COMPANY            Numeric 4                                 CA195   FB100
Element: Company       Identifies the AP company if the          FB101   FB120
                       resource type = V.  Identifies the HR     FB121   FB122
                       company if the resource type = E.  It is  FB145   FB165
                       blank for type A, P or Q resources.       FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL110
                                                                 GL146   GL148
                                                                 GL167   GL190
                                                                 GL197   GL199
                                                                 GL320   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GLSV.1

GCN-VAR-LEVELS         Alpha 30                                  CA195   FB100
Element: Variable LevelA level that represents the location of   FB101   FB120
                       an accounting unit in an organization's   FB121   FB122
                       level structure.                          FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL146
                                                                 GL148   GL167
                                                                 GL190   GL197
                                                                 GL199   GL320
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500

GCN-ACCOUNT            Numeric 6                                 CA195   FB100
Element: Account       This field along with the accounting      FB101   FB120
                       unit and subaccount make up the location  FB121   FB122
                       (account) where amounts and other         FB145   FB165
                       account information is stored.            FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL146
                                                                 GL148   GL167
                                                                 GL190   GL197
                                                                 GL199   GL320
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GCN-SUB-ACCOUNT        Numeric 4                                 CA195   FB100
Element: Subaccount    This field along with the accounting      FB101   FB120
                       unit and account make up the location     FB121   FB122
                       (account) where amounts and other         FB145   FB165
                       account information is stored.            FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL146
                                                                 GL148   GL167
                                                                 GL190   GL197
                                                                 GL199   GL320
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GCN-CURRENCY-CODE      Alpha 5                                   CA195   FB165
Element: Currency Code This field contains the company base      GL146   GL148
                       currency code established in Company      GL167   GL190
                       (GL10.1 ).                                GL197   GL199
                                                                 GL320   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GLSV.1

GCN-DB-BEG-BAL         Signed 18.2                               FB120   FB121
Debit Beginning                                                  FB122   FB145
Balance                                                          FB165   FB190
                                                                 FB20.1  FB20.3
                                                                 FB20.4  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB30.1  FB31.1
                                                                 FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 GL110   GL167
                                                                 GL197   GL199
                                                                 GL320   GL500
                                                                 GLSV.1

GCN-CR-BEG-BAL         Signed 18.2                               FB120   FB121
Credit Beginning                                                 FB122   FB145
Balance                                                          FB165   FB190
                                                                 FB20.1  FB20.3
                                                                 FB20.4  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB30.1  FB31.1
                                                                 FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 GL110   GL167
                                                                 GL197   GL199
                                                                 GL320   GL500
                                                                 GLSV.1

GCN-DB-AMOUNT          Signed 18.2 Occurs 13 Times               CA195   FB100
Element: Debit Amount                                            FB101   FB120
                                                                 FB121   FB122
                                                                 FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL110
                                                                 GL146   GL148
                                                                 GL167   GL190
                                                                 GL197   GL320
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GCN-CR-AMOUNT          Signed 18.2 Occurs 13 Times               CA195   FB100
Element: Credit Amount                                           FB101   FB120
                                                                 FB121   FB122
                                                                 FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL110
                                                                 GL146   GL148
                                                                 GL167   GL190
                                                                 GL197   GL320
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GCN-ACCT-ND            Numeric 1                                 CA195   FB100
Account Number of      Number of decimal positions in the        FB101   FB120
Decimals               account amounts                           FB121   FB122
                                                                 FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL146
                                                                 GL148   GL167
                                                                 GL190   GL197
                                                                 GL199   GL320
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500

GCN-CHART-NAME         Alpha 12                                  CA195   FB100
Element: Chart Name    This is the name you assigned to the      FB101   FB120
                       chart of accounts when you defined your   FB121   FB122
                       company structure in the General Ledger   FB145   FB165
                       system.                                   FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL146
                                                                 GL148   GL167
                                                                 GL190   GL197
                                                                 GL199   GL320
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GCN-CPAMT-DR           Derived
Current Period         This is the current period debit
Amount Debit           amount.


GCN-CPAMT-CR           Derived
Current Period         This is the current period credit
Amount Credit          amount.


GCN-CPAMT              Derived
Current Period         This is the total current period
Amount                 amount.


GCN-CYBAMT             Derived
Current Year           This is the total current year
Beginning Amount       beginning balance.


GCN-CUR-PD-SUM-C-D     Derived
Element: Current PeriodThis is the current period summary
                       debit amount.


GCN-CUR-PD-SUM-C-C     Derived
Element: Current PeriodThis is the current period summary
                       credit amount.


GCN-CUR-PD-SUM-C       Derived
Element: Cur Pd Sum C  This is the total current period
                       summary amount.


GCN-CYDAMT             Derived
Current Year to        This is the current year-to-date
Date Amount            amount.


GCN-CPAMT-THOU         Derived
Current Period         This is the current period amount
Amount Thousand        divided by 1,000.


GCN-CYDAMT-THOU        Derived
Curr Year to Date      This is the current year-to-date amount
Amt Thousand           divided by 1,000.


GCN-CPVAR-PCT          Derived
Element: Cpvar Pct     This is the current period variance
                       percent.


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

GCN-CYPAMT1-DR         Derived
Current Period 1       Current year period debit amount
Amount Debit           period 1.

GCN-CYPAMT1-CR         Derived
Current Period 1       Current year period credit amount
Amount Credit          period 1.

GCN-CYPAMT1            Derived
Current Period 1       Current year period amount period 1.
Amount

GCN-CYPYTD1            Derived
Curr Per 1 Year to     Current year period year to date
Date Amount            period 1.

GCN-CYPAMT2-DR         Derived
Current Period 2       Current year period debit amount
Amount Debit           period 2.

GCN-CYPAMT2-CR         Derived
Current Period 2       Current year period credit amount
Amount Credit          period 2.

GCN-CYPAMT2            Derived
Current Period 2       Current year period amount period 2.
Amount

GCN-CYPYTD2            Derived
Curr Per 2 Year To     Current year period year to date
Date Amount            period 2.

GCN-CYPAMT3-DR         Derived
Element: Cypamt3 Dr    Current year period debit amount
                       period 3.

GCN-CYPAMT3-CR         Derived
Element: Cypamt3 Cr    Current year period credit amount
                       period 3.

GCN-CYPAMT3            Derived
Element: Cypamt3       Current year period amount period 3.

GCN-CYPYTD3            Derived
Element: Cypamt3       Current year period year to date
                       period 3.

GCN-CYPAMT4-DR         Derived
Element: Cypamt4 Dr    Current year period debit amount
                       period 4.

GCN-CYPAMT4-CR         Derived
Element: Cypamt4 Cr    Current year period credit amount
                       period 4.

GCN-CYPAMT4            Derived
Element: Cypamt4       Current year period amount period 4.

GCN-CYPYTD4            Derived
Element: Cypamt4       Current year period year to date
                       period 4.

GCN-CYPAMT5-DR         Derived
Element: Cypamt5 Dr    Current year period debit amount
                       period 5.

GCN-CYPAMT5-CR         Derived
Element: Cypamt5 Cr    Current year period credit amount
                       period 5.

GCN-CYPAMT5            Derived
Element: Cypamt5       Current year period amount period 5.

GCN-CYPYTD5            Derived
Element: Cypamt5       Current year period year to date
                       period 5.

GCN-CYPAMT6-DR         Derived
Element: Cypamt6 Dr    Current year period debit amount
                       period 6.

GCN-CYPAMT6-CR         Derived
Element: Cypamt6 Cr    Current year period credit amount
                       period 6.

GCN-CYPAMT6            Derived
Element: Cypamt6       Current year period amount period 6.

GCN-CYPYTD6            Derived
Element: Cypamt6       Current year period year to date
                       period 6.

GCN-CYPAMT7-DR         Derived
Element: Cypamt7 Dr    Current year period debit amount
                       period 7.

GCN-CYPAMT7-CR         Derived
Element: Cypamt7 Cr    Current year period credit amount
                       period 7.

GCN-CYPAMT7            Derived
Element: Cypamt7       Current year period amount period 7.

GCN-CYPYTD7            Derived
Element: Cypamt7       Current year period year to date
                       period 7.

GCN-CYPAMT8-DR         Derived
Element: Cypamt8 Dr    Current year period debit amount
                       period 8.

GCN-CYPAMT8-CR         Derived
Element: Cypamt8 Cr    Current year period credit amount
                       period 8.

GCN-CYPAMT8            Derived
Element: Cypamt8       Current year period amount period 8.

GCN-CYPYTD8            Derived
Element: Cypamt8       Current year period year to date
                       period 8.

GCN-CYPAMT9-DR         Derived
Element: Cypamt9 Dr    Current year period debit amount
                       period 9.

GCN-CYPAMT9-CR         Derived
Element: Cypamt9 Cr    Current year period credit amount
                       period 9.

GCN-CYPAMT9            Derived
Element: Cypamt9       Current year period amount period 9.

GCN-CYPYTD9            Derived
Element: Cypamt9       Current year period year to date
                       period 9.

GCN-CYPAMT10-DR        Derived
Element: Cypamt10 Dr   Current year period debit amount
                       period 10.

GCN-CYPAMT10-CR        Derived
Element: Cypamt10 Cr   Current year period credit amount
                       period 10.

GCN-CYPAMT10           Derived
Element: Cypamt10      Current year period amount period 10.

GCN-CYPYTD10           Derived
Element: Cypamt10      Current year period year to date
                       period 10.

GCN-CYPAMT11-DR        Derived
Element: Cypamt11 Dr   Current year period debit amount
                       period 11.

GCN-CYPAMT11-CR        Derived
Element: Cypamt11 Cr   Current year period credit amount
                       period 11.

GCN-CYPAMT11           Derived
Element: Cypamt11      Current year period amount period 11.

GCN-CYPYTD11           Derived
Element: Cypamt11      Current year period year to date
                       period 11.

GCN-CYPAMT12-DR        Derived
Element: Cypamt12 Dr   Current year period debit amount
                       period 12.

GCN-CYPAMT12-CR        Derived
Element: Cypamt12 Cr   Current year period credit amount
                       period 12.

GCN-CYPAMT12           Derived
Element: Cypamt12      Current year period amount period 12.

GCN-CYPYTD12           Derived
Element: Cypamt12      Current year period year to date
                       period 12.

GCN-CYPAMT13-DR        Derived
Element: Cypamt13 Dr   Current year period debit amount
                       period 13.

GCN-CYPAMT13-CR        Derived
Element: Cypamt13 Cr   Current year period credit amount
                       period 13.

GCN-CYPAMT13           Derived
Element: Cypamt13      Current year period amount period 13.

GCN-CYPYTD13           Derived
Element: Cypamt13      Current year period year to date
                       period 13.

GCN-PARENT-VAR-LEV     Alpha 30                                  CA195   FB100
Element: Parent Var LevThe variable level address of the parent  FB101   FB120
                       accounting unit.                          FB121   FB122
                                                                 FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL146
                                                                 GL148   GL167
                                                                 GL190   GL197
                                                                 GL199   GL320
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500

                         GLCONSOL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GCNSET1   FISCAL-YEAR                                            CA195   FB100
          LEVEL-DEPTH                                            FB101   FB120
          BUDGET-NBR                                             FB121   FB122
          TRANS-TYPE                                             FB145   FB165
          COMPANY                                                FB190   FB195
          VAR-LEVELS                                             FB20.1  FB20.2
          ACCOUNT                                                FB20.3  FB20.4
          SUB-ACCOUNT                                            FB20.6  FB20.7
          CURRENCY-CODE                                          FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL110
                                                                 GL141   GL146
                                                                 GL148   GL167
                                                                 GL190   GL195
                                                                 ...

GCNSET2   FISCAL-YEAR                                            GL141   GL195
          LEVEL-DEPTH                                            GL199   GL288
          BUDGET-NBR                                             GL320   GLSV.1
          TRANS-TYPE                                             GLRV.1
          COMPANY
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          CURRENCY-CODE

GCNSET3   FISCAL-YEAR                                            GLSV.1  GLRV.1
          LEVEL-DEPTH
          BUDGET-NBR
          TRANS-TYPE
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          COMPANY
          CURRENCY-CODE

GCNSET4   FISCAL-YEAR                                            GLSV.1  GLRV.1
          LEVEL-DEPTH
          BUDGET-NBR
          TRANS-TYPE
          VAR-LEVELS
          ACCOUNT
          SUB-ACCOUNT
          COMPANY
          CURRENCY-CODE

GCNSET5   COMPANY                                                FB141   GL110
          TRANS-TYPE                                             GL300
          BUDGET-NBR
          FISCAL-YEAR
          VAR-LEVELS
          ACCOUNT
          SUB-ACCOUNT
          CURRENCY-CODE
          LEVEL-DEPTH

GCNSET8   PARENT-VAR-LEVSubset
          TRANS-TYPE    Where LEVEL-DEPTH > Zeroes
          COMPANY
          ACCOUNT
          SUB-ACCOUNT
          FISCAL-YEAR
          BUDGET-NBR
          LEVEL-DEPTH
          VAR-LEVELS
          CURRENCY-CODE

GCNSET9   VAR-LEVELS
          TRANS-TYPE
          COMPANY
          ACCOUNT
          SUB-ACCOUNT
          FISCAL-YEAR
          BUDGET-NBR
          LEVEL-DEPTH
          CURRENCY-CODE

                         GLCONSOL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Adconsol B     ADCONSOL     Required

                            GCN-FISCAL-YEAR       -> ADO-FISCAL-YEAR  (ADOSET1)
                            GCN-LEVEL-DEPTH       -> ADO-LEVEL-DEPTH
                            "B"                   -> ADO-RECORD-TYPE
                            GCN-COMPANY           -> ADO-COMPANY
                            GCN-VAR-LEVELS        -> ADO-VAR-LEVELS
                            GCN-ACCOUNT           -> ADO-ACCOUNT
                            GCN-SUB-ACCOUNT       -> ADO-SUB-ACCOUNT

Adconsol C     ADCONSOL     Required

                            GCN-FISCAL-YEAR       -> ADO-FISCAL-YEAR
                            GCN-LEVEL-DEPTH       -> ADO-LEVEL-DEPTH
                            "C"                   -> ADO-RECORD-TYPE
                            GCN-COMPANY           -> ADO-COMPANY
                            GCN-VAR-LEVELS        -> ADO-VAR-LEVELS
                            GCN-ACCOUNT           -> ADO-ACCOUNT
                            GCN-SUB-ACCOUNT       -> ADO-SUB-ACCOUNT

Chart Detail   GLCHARTDTL   Required

                            GCN-CHART-NAME        -> GDT-CHART-NAME
                            GCN-ACCOUNT           -> GDT-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GDT-SUB-ACCOUNT

Glconsol Bud 1 GLCONSOL     Not Required

                            GCN-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                            GCN-LEVEL-DEPTH       -> GCN-LEVEL-DEPTH
                            1                     -> GCN-BUDGET-NBR
                            "B"                   -> GCN-TRANS-TYPE
                            GCN-COMPANY           -> GCN-COMPANY
                            GCN-ACCOUNT           -> GCN-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GCN-SUB-ACCOUNT
                            GCN-VAR-LEVELS        -> GCN-VAR-LEVELS
                            GCN-CURRENCY-CODE     -> GCN-CURRENCY-CODE

Glsystem       GLSYSTEM     Required

                            GCN-COMPANY           -> GLS-COMPANY

                         GLCONSOL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Base           GLCONSOL

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

Cam Children 1 CUAMOUNT

                            GCN-VAR-LEVELS        -> CAM-PARENT-VAR-LEV
                            3                     -> CAM-AMT-TYPE
                            GCN-COMPANY           -> CAM-COMPANY
                            GCN-ACCOUNT           -> CAM-ACCOUNT
                            GCN-SUB-ACCOUNT       -> CAM-SUB-ACCOUNT
                            GCN-FISCAL-YEAR       -> CAM-FISCAL-YEAR
                                                     CAM-ACCT-UNIT
                                                     CAM-VAR-LEVELS
                                                     CAM-CURRENCY-CODE

Cam Children 2 CUAMOUNT

                            GCN-VAR-LEVELS        -> CAM-PARENT-VAR-LEV
                            4                     -> CAM-AMT-TYPE
                            GCN-COMPANY           -> CAM-COMPANY
                            GCN-ACCOUNT           -> CAM-ACCOUNT
                            GCN-SUB-ACCOUNT       -> CAM-SUB-ACCOUNT
                            GCN-FISCAL-YEAR       -> CAM-FISCAL-YEAR
                                                     CAM-ACCT-UNIT
                                                     CAM-VAR-LEVELS
                                                     CAM-CURRENCY-CODE

Children       GLCONSOL

                            GCN-VAR-LEVELS        -> GCN-PARENT-VAR-LEV
                            GCN-TRANS-TYPE        -> GCN-TRANS-TYPE
                            GCN-COMPANY           -> GCN-COMPANY
                            GCN-ACCOUNT           -> GCN-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GCN-SUB-ACCOUNT
                            GCN-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                                                     GCN-BUDGET-NBR
                                                     GCN-LEVEL-DEPTH
                                                     GCN-VAR-LEVELS
                                                     GCN-CURRENCY-CODE

Children Bud   GLCONSOL

                            GCN-VAR-LEVELS        -> GCN-PARENT-VAR-LEV
                            GCN-TRANS-TYPE        -> GCN-TRANS-TYPE
                            GCN-COMPANY           -> GCN-COMPANY
                            GCN-ACCOUNT           -> GCN-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GCN-SUB-ACCOUNT
                            GCN-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                            GCN-BUDGET-NBR        -> GCN-BUDGET-NBR
                                                     GCN-LEVEL-DEPTH
                                                     GCN-VAR-LEVELS
                                                     GCN-CURRENCY-CODE

Cuamount3      CUAMOUNT

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

Cuamount4      CUAMOUNT

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

Curr 1         GLCONSOL

                            GCN-VAR-LEVELS        -> GCN-VAR-LEVELS
                            "Y"                   -> GCN-TRANS-TYPE
                            GCN-COMPANY           -> GCN-COMPANY
                            GCN-ACCOUNT           -> GCN-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GCN-SUB-ACCOUNT
                            GCN-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                                                     GCN-BUDGET-NBR
                                                     GCN-LEVEL-DEPTH
                                                     GCN-CURRENCY-CODE

Curr 2         GLCONSOL

                            GCN-VAR-LEVELS        -> GCN-VAR-LEVELS
                            "Z"                   -> GCN-TRANS-TYPE
                            GCN-COMPANY           -> GCN-COMPANY
                            GCN-ACCOUNT           -> GCN-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GCN-SUB-ACCOUNT
                            GCN-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                                                     GCN-BUDGET-NBR
                                                     GCN-LEVEL-DEPTH
                                                     GCN-CURRENCY-CODE

Fbd Children   FBDETAIL

                            GCN-VAR-LEVELS        -> FBD-PARENT-VAR-LEV
                            GCN-FISCAL-YEAR       -> FBD-FISCAL-YEAR
                            GCN-BUDGET-NBR        -> FBD-BUDGET-NBR
                            GCN-COMPANY           -> FBD-COMPANY
                            GCN-ACCOUNT           -> FBD-ACCOUNT
                            GCN-SUB-ACCOUNT       -> FBD-SUB-ACCOUNT
                                                     FBD-ACCT-UNIT

Gam Children   GLAMOUNTS

                            GCN-VAR-LEVELS        -> GAM-PARENT-VAR-LEV
                            GCN-COMPANY           -> GAM-COMPANY
                            GCN-ACCOUNT           -> GAM-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GAM-SUB-ACCOUNT
                            GCN-FISCAL-YEAR       -> GAM-FISCAL-YEAR
                                                     GAM-ACCT-UNIT

Gcn Bud Parent GLCONSOL

                            GCN-PARENT-VAR-LEV    -> GCN-VAR-LEVELS
                            GCN-TRANS-TYPE        -> GCN-TRANS-TYPE
                            GCN-COMPANY           -> GCN-COMPANY
                            GCN-ACCOUNT           -> GCN-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GCN-SUB-ACCOUNT
                            GCN-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                            GCN-BUDGET-NBR        -> GCN-BUDGET-NBR
                                                     GCN-LEVEL-DEPTH
                                                     GCN-CURRENCY-CODE

Glamounts Acct GLAMOUNTS

                            GCN-COMPANY           -> GAM-COMPANY
                            GLS-FISCAL-YEAR       -> GAM-FISCAL-YEAR
                            GCN-ACCOUNT           -> GAM-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GAM-SUB-ACCOUNT
                                                     GAM-ACCT-UNIT

Glconsol 0     GLCONSOL

                            GCN-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                            Zeroes                -> GCN-LEVEL-DEPTH
                            GCN-BUDGET-NBR        -> GCN-BUDGET-NBR
                            GCN-TRANS-TYPE        -> GCN-TRANS-TYPE
                            GCN-COMPANY           -> GCN-COMPANY
                            GCN-ACCOUNT           -> GCN-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GCN-SUB-ACCOUNT
                                                     GCN-VAR-LEVELS
                                                     GCN-CURRENCY-CODE

Glconsol 1     GLCONSOL

                            GCN-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                            1                     -> GCN-LEVEL-DEPTH
                            GCN-BUDGET-NBR        -> GCN-BUDGET-NBR
                            GCN-TRANS-TYPE        -> GCN-TRANS-TYPE
                            GCN-COMPANY           -> GCN-COMPANY
                            GCN-ACCOUNT           -> GCN-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GCN-SUB-ACCOUNT
                                                     GCN-VAR-LEVELS
                                                     GCN-CURRENCY-CODE

Glconsol 2     GLCONSOL

                            GCN-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                            2                     -> GCN-LEVEL-DEPTH
                            GCN-BUDGET-NBR        -> GCN-BUDGET-NBR
                            GCN-TRANS-TYPE        -> GCN-TRANS-TYPE
                            GCN-COMPANY           -> GCN-COMPANY
                            GCN-ACCOUNT           -> GCN-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GCN-SUB-ACCOUNT
                                                     GCN-VAR-LEVELS
                                                     GCN-CURRENCY-CODE

Glconsol 3     GLCONSOL

                            GCN-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                            3                     -> GCN-LEVEL-DEPTH
                            GCN-BUDGET-NBR        -> GCN-BUDGET-NBR
                            GCN-TRANS-TYPE        -> GCN-TRANS-TYPE
                            GCN-COMPANY           -> GCN-COMPANY
                            GCN-ACCOUNT           -> GCN-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GCN-SUB-ACCOUNT
                                                     GCN-VAR-LEVELS
                                                     GCN-CURRENCY-CODE

Glconsol 4     GLCONSOL

                            GCN-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                            4                     -> GCN-LEVEL-DEPTH
                            GCN-BUDGET-NBR        -> GCN-BUDGET-NBR
                            GCN-TRANS-TYPE        -> GCN-TRANS-TYPE
                            GCN-COMPANY           -> GCN-COMPANY
                            GCN-ACCOUNT           -> GCN-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GCN-SUB-ACCOUNT
                                                     GCN-VAR-LEVELS
                                                     GCN-CURRENCY-CODE

Glmaster       GLMASTER     Required

                            GCN-COMPANY           -> GLM-COMPANY
                            GCN-ACCOUNT           -> GLM-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GLM-SUB-ACCOUNT
                                                     GLM-ACCT-UNIT

Glnames        GLNAMES      Required

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

Glu Children   GLUNITS

                            GCN-VAR-LEVELS        -> GLU-PARENT-VAR-LEV
                            GCN-COMPANY           -> GLU-COMPANY
                            GCN-ACCOUNT           -> GLU-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GLU-SUB-ACCOUNT
                            GCN-FISCAL-YEAR       -> GLU-FISCAL-YEAR
                                                     GLU-ACCT-UNIT

Parent         GLCONSOL

                            GCN-PARENT-VAR-LEV    -> GCN-VAR-LEVELS
                            GCN-TRANS-TYPE        -> GCN-TRANS-TYPE
                            GCN-COMPANY           -> GCN-COMPANY
                            GCN-ACCOUNT           -> GCN-ACCOUNT
                            GCN-SUB-ACCOUNT       -> GCN-SUB-ACCOUNT
                            GCN-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                                                     GCN-BUDGET-NBR
                                                     GCN-LEVEL-DEPTH
                                                     GCN-CURRENCY-CODE