Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUAMOUNT


                             CUAMOUNT FILE

                            Currency Amount

The Currency Amount file contains a partial chart of accounts for non-base
currency transactions. All Lawson subsystems verify the existence of non-base
currency  accounts against this file.

This file also maintains monthly activity and beginning balances for all
non-base currency, posting level accounting units. GL190 (Journal Posting)
updates this file, and GL191 (Currency Revaluation) revalues the balance sheet
accounts. Non-base currency, balance sheet accounts used in revaluation are
designated as type 2 amounts. Type 1 amounts are non-base currency account
amounts and are not revalued.



REFERENCED BY

GL141     GL147     GL191     GL291     GL296     GLSV.1
GLOP.1    GLRV.1    GL196     GL320     GL290     RW80.1
GL90.1    GL90.4    GL90.6

UPDATED BY

CA110     GL110     GL120     GL146     GL148     GL167
GL190     GL197     GL199     GL300     GL310     GL327
GL330     GL40.1    GL40.2    GL40.3    GL40.7    GL40.8
GL44.1    GL45.1    GL500     GL122     GL20.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CAM-COMPANY            Numeric 4                                 CA110   GL110
Element: Company       This is the company number for which      GL146   GL148
                       currency amounts are defined.             GL167   GL190
                                                                 GL197   GL199
                                                                 GL327   GL330
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

CAM-FISCAL-YEAR        Numeric 4                                 CA110   GL146
Element: Fiscal Year   Key field. This is the fiscal year.       GL148   GL167
                                                                 GL190   GL197
                                                                 GL199   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GLSV.1

CAM-AMT-TYPE           Numeric 1                                 CA110   GL146
Element: Amount Type   Key field. Two amount types are           GL148   GL167
                       allowed. Use 1 for amounts for non-base   GL190   GL197
                       account currencies. Use 2 for non-base    GL199   GL327
                       transaction currency amounts for balance  GL330   GL40.1
                       sheet accounts carried in both the base   GL40.2  GL40.3
                       and transaction amounts. Use 3 for        GL40.7  GL40.8
                       Report Currency One. Use 4 for Report     GL44.1  GL45.1
                       Currency Two.                             GL500   GLSV.1

                       1 = Account Currency Balance
                       2 = Transaction Balances
                       3 = Currency One Balance
                       4 = Currency Two Balance

CAM-VAR-LEVELS         Alpha 30                                  CA110   GL120
Element: Variable LevelKey field. The variable level             GL146   GL148
                       represents the location of an accounting  GL167   GL190
                       unit in an organization's level           GL197   GL199
                       structure.                                GL327   GL330
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

CAM-ACCOUNT            Numeric 6                                 CA110   GL146
Element: Account       Key field. This field and the             GL148   GL167
                       accounting unit and subaccount define     GL190   GL197
                       the location (account) where amounts and  GL199   GL327
                       other  account information are stored.    GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GLSV.1

CAM-SUB-ACCOUNT        Numeric 4                                 CA110   GL146
Element: Subaccount    Key field. This field and the             GL148   GL167
                       accounting unit and account define the    GL190   GL197
                       location (account) where amounts and      GL199   GL327
                       other account information are stored.     GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GLSV.1

CAM-ACCT-UNIT          Alpha 15                                  CA110   GL146
Element: Accounting UniThe accounting unit is a shorthand        GL148   GL167
                       notation representing the variable level  GL190   GL197
                       number. When used in the General Ledger   GL199   GL327
                       Account Master file, the accounting unit  GL330   GL40.1
                       must be defined in the General Ledger     GL40.2  GL40.3
                       Names file as a posting accounting unit.  GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GLSV.1

CAM-CURRENCY-CODE      Alpha 5                                   CA110   GL146
Element: Currency Code Key field. This field contains the        GL148   GL167
                       company's base currency code established  GL190   GL197
                       in GL10.1 (Company).                      GL199   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GLSV.1

CAM-CHART-NAME         Alpha 12                                  CA110   GL146
Element: Chart Name    This is the name you assigned to the      GL148   GL167
                       chart of accounts when you defined your   GL190   GL197
                       company structure in the General Ledger   GL199   GL327
                       system.                                   GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GLSV.1

CAM-CURR-ND            Numeric 1                                 CA110   GL146
Element: currency Code This field determines the number of       GL148   GL167
                       decimal positions for amount fields.      GL190   GL197
                                                                 GL199   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

CAM-BASE-ND            Numeric 1                                 CA110   GL146
Base Number of         This is the defined number of decimal     GL148   GL167
Decimals               positions for base amount fields.         GL190   GL197
                                                                 GL199   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

CAM-DB-BEG-BAL         Signed 18.2                               GL110   GL167
Debit Beginning        This is the debit beginning balance.      GL199   GL291
Balance                                                          GL327   GL500
                                                                 GLSV.1

CAM-CR-BEG-BAL         Signed 18.2                               GL110   GL167
Credit Beginning       This is the credit beginning balance.     GL199   GL291
Balance                                                          GL327   GL500
                                                                 GLSV.1

CAM-BASE-DB-BBAL       Signed 18.2                               GL110   GL167
Base Currency Debit    This is the base currency debit           GL199   GL327
Balance                balance.                                  GL500


CAM-BASE-CR-BBAL       Signed 18.2                               GL110   GL167
Base Currency          This is the base currency credit          GL199   GL327
Credit Balance         balance.                                  GL500


CAM-RPT1-DB-BBAL       Signed 18.2                               GL110   GL167
Report One Debit       The Report One currency debit beginning   GL199   GL310
Beg Balance            balance.                                  GL327

CAM-RPT1-CR-BBAL       Signed 18.2                               GL110   GL167
Report One Credit      The Report One currency credit beginning  GL199   GL310
Beg Balance            balance.                                  GL327

CAM-RPT2-DB-BBAL       Signed 18.2                               GL110   GL167
Report Two Debit       The Report Two currency debit beginning   GL199   GL310
Beg Balance            balance.                                  GL327

CAM-RPT2-CR-BBAL       Signed 18.2                               GL110   GL167
Report Two Credit      The Report Two currency credit beginning  GL199   GL310
Beg Balance            balance.                                  GL327

CAM-DB-AMOUNT          Signed 18.2 Occurs 13 Times               GL110   GL146
Element: Budget Debit AThis is the currency debit amount.        GL148   GL167
                                                                 GL190   GL197
                                                                 GL291   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GLSV.1

CAM-CR-AMOUNT          Signed 18.2 Occurs 13 Times               GL110   GL146
Element: Budget Credit This is the currency credit amount.       GL148   GL167
                                                                 GL190   GL197
                                                                 GL291   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GLSV.1

CAM-BASE-DB-AMT        Signed 18.2 Occurs 13 Times               GL110   GL146
Period Base Debit      This is the base debit amount for the     GL148   GL167
Amount                 period.                                   GL190   GL197
                                                                 GL327   GL330
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500

CAM-BASE-CR-AMT        Signed 18.2 Occurs 13 Times               GL110   GL146
Period Base Credit     This is the base credit amount for the    GL148   GL167
Amount                 period.                                   GL190   GL197
                                                                 GL327   GL330
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500

CAM-RPT1-DB-AMT        Signed 18.2 Occurs 13 Times               GL110   GL146
Report One Debit       The Report One currency debit amount for  GL148   GL167
Amount                 the period.                               GL190   GL197
                                                                 GL310   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

CAM-RPT1-CR-AMT        Signed 18.2 Occurs 13 Times               GL110   GL146
Report One Credit      The Report One currency credit amount     GL148   GL167
Amount                 for the period.                           GL190   GL197
                                                                 GL310   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

CAM-RPT2-DB-AMT        Signed 18.2 Occurs 13 Times               GL110   GL146
Report Two Debit       The Report Two currency debit amount for  GL148   GL167
Amount                 the period.                               GL190   GL197
                                                                 GL310   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

CAM-RPT2-CR-AMT        Signed 18.2 Occurs 13 Times               GL110   GL146
Report Two Credit      The Report Two currency credit amount     GL148   GL167
Amount                 for the period.                           GL190   GL197
                                                                 GL310   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

CAM-MAINT-DATE         Numeric 8  (yyyymmdd)
Element: Maintenance DaThe date last changed.

CAM-MAINT-TIME         Numeric 6  (hhmmss)
Element: Maintenance TiThe time last changed.

CAM-CPAMT-DR           Derived
Current Per            This is the currency debit amount for
Currency Dr Amount     the current period.


CAM-CPAMT-CR           Derived
Current Per            This is the currency credit amount for
Currency Cr Amount     the current period.


CAM-CPAMT              Derived
Current Period         This is the currency amount for the
Currency Amount        current period.


CAM-CUR-PD-SUM-A-D     Derived
Current Per Base Dr    This is the base debit amount for the
Amount                 current period.


CAM-CUR-PD-SUM-A-C     Derived
Current Per Base Cr    This is the base credit amount for the
Amount                 current period.


CAM-CYBAMT             Derived
Current Year Beg       This is the beginning base amount for
Base Amount            the current year.


CAM-CYDAMT             Derived
Current Per Base       This is the base amount to date for the
Amt to Date            current period.


CAM-CYPAMT1-DR         Derived
Period 1 Base Debit    This is the period 1 base debit amount.
Amount

CAM-CYPAMT1-CR         Derived
Period 1 Base          This is the period 1 base credit
Credit Amount          amount.


CAM-CYPYTD1            Derived
Period 1 Year to       Current year period year to date
Date Amount            period 1.

CAM-CYPAMT2-DR         Derived
Period 2 Base Debit    This is the period 2 base debit amount.
Amount

CAM-CYPAMT2-CR         Derived
Period 2 Base          This is the period 2 base credit
Credit Amount          amount.


CAM-CYPYTD2            Derived
Period 2 Year to       Current year period year to date
Date Amount            period 2.

CAM-CYPAMT3-DR         Derived
Period 3 Base Debit    This is the period 3 base debit amount.
Amount

CAM-CYPAMT3-CR         Derived
Period 3 Base          This is the period 3 base credit
Credit Amount          amount.


CAM-CYPYTD3            Derived
Period 3 Year to       Current year period year to date
Date Amount            period 3.

CAM-CYPAMT4-DR         Derived
Period 4 Base Debit    This is the period 4 base debit amount.
Amount

CAM-CYPAMT4-CR         Derived
Period 4 Base          This is the period 4 base credit
Credit Amount          amount.


CAM-CYPYTD4            Derived
Period 4 Year to       Current year period year to date
Date Amount            period 4.

CAM-CYPAMT5-DR         Derived
Period 5 Base Debit    This is the period 5 base debit amount.
Amount

CAM-CYPAMT5-CR         Derived
Period 5 Base          This is the period 5 base credit
Credit Amount          amount.


CAM-CYPYTD5            Derived
Period 5 Year to       Current year period year to date
Date Amount            period 5.

CAM-CYPAMT6-DR         Derived
Period 6 Base Debit    This is the period 6 base debit amount.
Amount

CAM-CYPAMT6-CR         Derived
Period 6 Base          This is the period 6 base credit
Credit Amount          amount.


CAM-CYPYTD6            Derived
Period 6 Year to       Current year period year year to date
Date Amount            period 6.

CAM-CYPAMT7-DR         Derived
Period 7 Base Debit    This is the period 7 base debit amount.
Amount

CAM-CYPAMT7-CR         Derived
Period 7 Base          This is the period 7 base credit
Credit Amount          amount.


CAM-CYPYTD7            Derived
Period 7 Year to       Current year period year to date
Date Amount            period 7.

CAM-CYPAMT8-DR         Derived
Period 8 Base Debit    This is the period 8 base debit amount.
Amount

CAM-CYPAMT8-CR         Derived
Period 8 Base          This is the period 8 base credit
Credit Amount          amount.


CAM-CYPYTD8            Derived
Period 8 Year to       Current year period year to date
Date Amount            period 8.

CAM-CYPAMT9-DR         Derived
Period 9 Base Debit    This is the period 9 base debit amount.
Amount

CAM-CYPAMT9-CR         Derived
Period 9 Base          This is the period 9 base credit
Credit Amount          amount.


CAM-CYPYTD9            Derived
Period 9 Year to       Current year period year to date
Date Amount            period 9.

CAM-CYPAMT10-DR        Derived
Period 10 Base         This is the period 10 base debit
Debit Amount           amount.


CAM-CYPAMT10-CR        Derived
Period 10 Base         This is the period 10 base credit
Credit Amount          amount.


CAM-CYPYTD10           Derived
Period 10 Year to      Current year period year to date
Date Amount            period 10.

CAM-CYPAMT11-DR        Derived
Period 11 Base         This is the period 11 base debit
Debit Amount           amount.


CAM-CYPAMT11-CR        Derived
Period 11 Base         This is the period 11 base credit
Credit Amount          amount.


CAM-CYPYTD11           Derived
Period 11 Year to      Current year period year to date
Date Amount            period 11.

CAM-CYPAMT12-DR        Derived
Period 12 Base         This is the period 12 base debit
Debit Amount           amount.


CAM-CYPAMT12-CR        Derived
Period 12 Base         This is the period 12 base credit
Credit Amount          amount.


CAM-CYPYTD12           Derived
Period 12 Year to      Current year period year to date
Date Amount            period 12.

CAM-CYPAMT13-DR        Derived
Period 13 Base         This is the period 13 base debit
Debit Amount           amount.


CAM-CYPAMT13-CR        Derived
Period 13 Base         This is the period 13 base credit
Credit Amount          amount.


CAM-CYPYTD13           Derived
Period 13 Year to      Current year period year to date
Date Amount            period 13.

CAM-CPCUR-DR           Derived
Current Period         This is the current period debit
Debit Amount           amount.


CAM-CPCUR-CR           Derived
Current Period         This is the current period credit
Credit Amount          amount.


CAM-CPCUR              Derived
Current Period         This is the current period amount.
Amount

CAM-CUR-PD-SUM-C-D     Derived
Year-to-Date Debit     This is the year-to-date debit amount.
Amount

CAM-CUR-PD-SUM-C-C     Derived
Year-to-Date Credit    This is the year-to-date credit amount.
Amount

CAM-CYBCUR             Derived
Element: Beginning BalaThis is the beginning balance.

CAM-CYDCUR             Derived
Element: Balance to DatThis is the balance to date.

CAM-CYPCUR1-DR         Derived
Per 1 Currency         This is the period 1 currency debit
Debit Amount           amount.


CAM-CYPCUR1-CR         Derived
Per 1 Currency         This is the period 1 currency credit
Credit Amount          amount.


CAM-CURYTD1            Derived
Per 1 Curr Year to     Currency current year period year to
Date Amt               date period 1.

CAM-CYPCUR2-DR         Derived
Per 2 Currency         This is the period 2 currency debit
Debit Amount           amount.


CAM-CYPCUR2-CR         Derived
Per 2 Currency         This is the period 2 currency credit
Credit Amount          amount.


CAM-CURYTD2            Derived
Per 2 Curr Year to     Currency current year period year to
Date Amt               date period 2.

CAM-CYPCUR3-DR         Derived
Per 3 Currency         This is the period 3 currency debit
Debit Amount           amount.


CAM-CYPCUR3-CR         Derived
Per 3 Currency         This is the period 3 currency credit
Credit Amount          amount.


CAM-CURYTD3            Derived
Per 3 Curr Year to     Currency current year period year to
Date Amt               date period 3.

CAM-CYPCUR4-DR         Derived
Per 4 Currency         This is the period 4 currency debit
Debit Amount           amount.


CAM-CYPCUR4-CR         Derived
Per 4 Currency         This is the period 4 currency credit
Credit Amount          amount.


CAM-CURYTD4            Derived
Per 4 Curr Year to     Currency current year period year to
Date Amt               date period 4.

CAM-CYPCUR5-DR         Derived
Per 5 Currency         This is the period 5 currency debit
Debit Amount           amount.


CAM-CYPCUR5-CR         Derived
Per 5 Currency         This is the period 5 currency credit
Credit Amount          amount.


CAM-CURYTD5            Derived
Per 5 Curr Year to     Currency current year period year to
Date Amt               date period 5.

CAM-CYPCUR6-DR         Derived
Per 6 Currency         This is the period 6 currency debit
Debit Amount           amount.


CAM-CYPCUR6-CR         Derived
Per 6 Currency         This is the period 6 currency credit
Credit Amount          amount.


CAM-CURYTD6            Derived
Per 6 Curr Year to     Currency current year period year to
Date Amt               date period 6.

CAM-CYPCUR7-DR         Derived
Per 7 Currency         This is the period 7 currency debit
Debit Amount           amount.


CAM-CYPCUR7-CR         Derived
Per 7 Currency         This is the period 7 currency credit
Credit Amount          amount.


CAM-CURYTD7            Derived
Per 8 Curr Year to     Currency current year period year to
Date Amt               date period 7.

CAM-CYPCUR8-DR         Derived
Per 8 Currency         This is the period 8 currency debit
Debit Amount           amount.


CAM-CYPCUR8-CR         Derived
Per 8 Currency         This is the period 8 currency credit
Credit Amount          amount.


CAM-CURYTD8            Derived
Per 8 Curr Year to     Currency current year period year to
Date Amt               date period 8.

CAM-CYPCUR9-DR         Derived
Per 9 Currency         This is the period 9 currency debit
Debit Amount           amount.


CAM-CYPCUR9-CR         Derived
Per 9 Currency         This is the period 9 currency credit
Credit Amount          amount.


CAM-CURYTD9            Derived
Per 9 Curr Year to     Currency current year period year to
Date Amt               date period 9.

CAM-CYPCUR10-DR        Derived
Per 10 Currency        This is the period 10 currency debit
Debit Amount           amount.


CAM-CYPCUR10-CR        Derived
Per 10 Currency        This is the period 10 currency credit
Credit Amount          amount.


CAM-CURYTD10           Derived
Per 10 Curr Year to    Currency current year period year to
Date Amt               date period 10.

CAM-CYPCUR11-DR        Derived
Per 11 Currency        This is the period 11 currency debit
Debit Amount           amount.


CAM-CYPCUR11-CR        Derived
Per 11 Currency        This is the period 11 currency credit
Credit Amount          amount.


CAM-CURYTD11           Derived
Per 11 Curr Year to    Currency current year period year to
Date Amt               date period 11.

CAM-CYPCUR12-DR        Derived
Per 12 Currency        This is the period 12 currency debit
Debit Amount           amount.


CAM-CYPCUR12-CR        Derived
Per 12 Currency        This is the period 12 currency credit
Credit Amount          amount.


CAM-CURYTD12           Derived
Per 12 Curr year to    Currency current year period year to
Date Amt               date period 12.

CAM-CYPCUR13-DR        Derived
Per 13 Currency        This is the period 13 currency debit
Debit Amount           amount.


CAM-CYPCUR13-CR        Derived
Per 13 Currency        This is the period 13 currency credit
Credit Amount          amount.


CAM-CURYTD13           Derived
Per 13 Curr Year to    Currency current year period year to
Date Amt               date period 13.

CAM-BLANK              Derived
Element: Blank         This derived field is always blank. It
                       is used in drill around to allow for
                       column headings.


CAM-CPAMT-THOU         Derived
Current Period         The current period base amount divided
Amount Thousand        by 1,000.


CAM-CYDAMT-THOU        Derived
Current YTD Amount     The current year-to-date base amount
Thousands              divided by 1,000.


CAM-CPCUR-THOU         Derived
Current Per Curr       The current year-to-date currency
Amt Thousand           amount divided by 1,000.


CAM-CYDCUR-THOU        Derived
Current YTD Curreny    The current year-to-date currency
Amt Thou               amount divided by 1,000.


CAM-PARENT-VAR-LEV     Alpha 30                                  CA110   GL120
Parent Variable        The variable level address of the parent  GL146   GL148
Level                  accounting unit.                          GL167   GL190
                                                                 GL197   GL199
                                                                 GL327   GL330
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500

                         CUAMOUNT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CAMSET1   FISCAL-YEAR   This path is used to retrieve a          CA110   GL110
          COMPANY       currency amount for a specific company,  GL141   GL146
          AMT-TYPE      variable level, etc.                     GL147   GL148
          VAR-LEVELS                                             GL167   GL190
          ACCOUNT                                                GL191   GL197
          SUB-ACCOUNT                                            GL199   GL291
          ACCT-UNIT                                              GL296   GL300
          CURRENCY-CODE                                          GL327   GL330
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GLSV.1
                                                                 GLOP.1  GLRV.1

CAMSET2   FISCAL-YEAR   This path accesses the accounting unit   GL196   GL199
          COMPANY       via amount type, currency code, account  GL296   GL320
          AMT-TYPE      and subaccount, and variable levels,     GL327   GL330
          CURRENCY-CODE within company.                          GLOP.1
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          ACCT-UNIT

CAMSET3   AMT-TYPE                                               GL290   GL291
          FISCAL-YEAR                                            GLSV.1  RW80.1
          COMPANY                                                GLRV.1
          VAR-LEVELS
          ACCOUNT
          SUB-ACCOUNT
          ACCT-UNIT
          CURRENCY-CODE

CAMSET4   AMT-TYPE                                               GL327   GL330
          FISCAL-YEAR                                            GLSV.1  GLRV.1
          COMPANY
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          ACCT-UNIT
          CURRENCY-CODE

CAMSET5   COMPANY                                                GL110   GL120
          ACCT-UNIT                                              GL122   GL148
          ACCOUNT                                                GL199   GL310
          SUB-ACCOUNT                                            GL500   GL90.1
          AMT-TYPE                                               GL90.4  GL90.6
          CURRENCY-CODE                                          GL20.2
          FISCAL-YEAR
          VAR-LEVELS

CAMSET6   AMT-TYPE                                               GLSV.1  GLRV.1
          FISCAL-YEAR
          VAR-LEVELS
          ACCOUNT
          SUB-ACCOUNT
          COMPANY
          ACCT-UNIT
          CURRENCY-CODE

CAMSET7   AMT-TYPE                                               GLSV.1  GLRV.1
          FISCAL-YEAR
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          COMPANY
          ACCT-UNIT
          CURRENCY-CODE

CAMSET9   PARENT-VAR-LEV
          AMT-TYPE
          COMPANY
          ACCOUNT
          SUB-ACCOUNT
          FISCAL-YEAR
          ACCT-UNIT
          VAR-LEVELS
          CURRENCY-CODE

                         CUAMOUNT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Chart Detail   GLCHARTDTL   Required

                            GLS-CHART-NAME        -> GDT-CHART-NAME  (GDTSET2)
                            CAM-ACCOUNT           -> GDT-ACCOUNT
                            CAM-SUB-ACCOUNT       -> GDT-SUB-ACCOUNT

Company        GLSYSTEM     Required

                            CAM-COMPANY           -> GLS-COMPANY

Cucodes        CUCODES      Required

                            CAM-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Gam Sibling    GLAMOUNTS    Not Required

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

Glmaster       GLMASTER     Required

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

Glnames        GLNAMES      Required

                            CAM-COMPANY           -> GLN-COMPANY
                            CAM-ACCT-UNIT         -> GLN-ACCT-UNIT

                         CUAMOUNT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Consol Parent1 GLCONSOL

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

Consol Parent2 GLCONSOL

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

Cuconv         CUCONV

                            GLS-CURRENCY-TABLE    -> CCN-CURRENCY-TABLE
                            CAM-CURRENCY-CODE     -> CCN-FR-CURR-CODE
                            GLS-CURRENCY-CODE     -> CCN-TO-CURR-CODE
                                                     CCN-SYSTEM
                                                     CCN-EFFECT-DATE

Curr 1         CUAMOUNT

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

Curr 2         CUAMOUNT

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

Gltrans 1 Prd  GLTRANS

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

Gltrans 1 Year GLTRANS

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