Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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

UPDATED BY

CA110     GL110     GL120     GL146     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
Company              This is the company number you are          GL146   GL167
                     defining currency amounts for.              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
Fiscal Year          Key field. This is the fiscal year.         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
Amount Type          Key field. Two amount types are             GL167   GL190
                     allowed. Use 1 for amounts for non-base     GL197   GL199
                     account currencies. Use 2 for non-base      GL327   GL330
                     transaction currency amounts for balance    GL40.1  GL40.2
                     sheet accounts carried in both the base     GL40.3  GL40.7
                     and transaction amounts. Use 3 for          GL40.8  GL44.1
                     Report Currency One. Use 4 for Report       GL45.1  GL500
                     Currency Two.                               GLSV.1

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

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

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

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

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

CAM-CURRENCY-CODE    Alpha 5                                     CA110   GL146
Currency Code        Key field. This field contains the          GL167   GL190
                     company's base currency code established    GL197   GL199
                     in GL10.1 (Company).                        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
Chart Name           This is the name you assigned to the        GL167   GL190
                     chart of accounts when you defined your     GL197   GL199
                     company structure in the General Ledger     GL327   GL330
                     system.                                     GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

CAM-CURR-ND          Numeric 1                                   CA110   GL146
Currency Number of   This field determines the number of         GL167   GL190
Decimals             decimal positions for amount fields.        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       GL167   GL190
Decimals             positions for base amount fields.           GL197   GL199
                                                                 GL327   GL330
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500

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

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

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


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


CAM-RPT1-DB-BBAL     Currency 15.2                               GL167   GL199
Rpt1 Db Bbal                                                     GL310   GL327

CAM-RPT1-CR-BBAL     Currency 15.2                               GL167   GL199
Rpt1 Cr Bbal                                                     GL310   GL327

CAM-RPT2-DB-BBAL     Currency 15.2                               GL167   GL199
Rpt2 Db Bbal                                                     GL310   GL327

CAM-RPT2-CR-BBAL     Currency 15.2                               GL167   GL199
Rpt2 Cr Bbal                                                     GL310   GL327

CAM-DB-AMOUNT        Currency 15.2 Occurs 13 Times               GL110   GL146
Budget Debit Amount  This is the currency debit amount.          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        Currency 15.2 Occurs 13 Times               GL110   GL146
Budget Credit Amount This is the currency credit amount.         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      Currency 15.2 Occurs 13 Times               GL110   GL146
Period Base Debit    This is the base debit amount for the       GL167   GL190
Amount               period.                                     GL197   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

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

CAM-RPT1-DB-AMT      Currency 15.2 Occurs 13 Times               GL146   GL167
Rpt1 Db Amt                                                      GL190   GL197
                                                                 GL310   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

CAM-RPT1-CR-AMT      Currency 15.2 Occurs 13 Times               GL146   GL167
Rpt1 Cr Amt                                                      GL190   GL197
                                                                 GL310   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

CAM-RPT2-DB-AMT      Currency 15.2 Occurs 13 Times               GL146   GL167
Rpt2 Db Amt                                                      GL190   GL197
                                                                 GL310   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

CAM-RPT2-CR-AMT      Currency 15.2 Occurs 13 Times               GL146   GL167
Rpt2 Cr Amt                                                      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)
Maintenance Date     The date last changed.

CAM-MAINT-TIME       Numeric 6  (hhmmss)
Maintenance Time     The 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
Amnt 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-CYPAMT1          Derived
Period 1 Base Amount This is the period 1 base amount.

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-CYPAMT2          Derived
Period 2 Base Amount This is the period 2 base amount.

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-CYPAMT3          Derived
Period 3 Base Amount This is the period 3 base amount.

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-CYPAMT4          Derived
Period 4 Base Amount This is the period 4 base amount.

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-CYPAMT5          Derived
Period 5 Base Amount This is the period 5 base amount.

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-CYPAMT6          Derived
Period 6 Base Amount This is the period 6 base amount.

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-CYPAMT7          Derived
Period 7 Base Amount This is the period 7 base amount.

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-CYPAMT8          Derived
Period 8 Base Amount This is the period 8 base amount.

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-CYPAMT9          Derived
Period 9 Base Amount This is the period 9 base amount.

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-CYPAMT10         Derived
Period 10 Base       This is the period 10 base amount.
Amount

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-CYPAMT11         Derived
Period 11 Base       This is the period 11 base amount.
Amount

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-CYPAMT12         Derived
Period 12 Base       This is the period 12 base amount.
Amount

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-CYPAMT13         Derived
Period 13 Base       This is the period 13 base amount.
Amount

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
Beginning Balance    This is the beginning balance.

CAM-CYDCUR           Derived
Balance to Date      This 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-CYPCUR1          Derived
Per 1 Currency       This is the period 1 currency amount.
Amount

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-CYPCUR2          Derived
Per 2 Currency       This is the period 2 currency amount.
Amount

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-CYPCUR3          Derived
Per 3 Currency       This is the period 3 currency amount.
Amount

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-CYPCUR4          Derived
Per 4 Currency       This is the period 4 currency amount.
Amount

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-CYPCUR5          Derived
Per 5 Currency       This is the period 5 currency amount.
Amount

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-CYPCUR6          Derived
Per 6 Currency       This is the period 6 currency amount.
Amount

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-CYPCUR7          Derived
Per 7 Currency       This is the period 7 currency amount.
Amount

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-CYPCUR8          Derived
Per 8 Currency       This is the period 8 currency amount.
Amount

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-CYPCUR9          Derived
Per 9 Currency       This is the period 9 currency amount.
Amount

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-CYPCUR10         Derived
Per 10 Currency      This is the period 10 currency amount.
Amount

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-CYPCUR11         Derived
Per 11 Currency      This is the period 11 currency amount.
Amount

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-CYPCUR12         Derived
Per 12 Currency      This is the period 12 currency amount.
Amount

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-CYPCUR13         Derived
Per 13 Currency      This is the period 13 currency amount.
Amount

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


CAM-CPAMT-THOU       Derived
Cpamt Thou           The current period base amount divided
                     by 1,000.


CAM-CYDAMT-THOU      Derived
Cydamt Thou          The current year-to-date base amount
                     divided by 1,000.


CAM-CPCUR-THOU       Derived
Cpcur Thou           The current year-to-date currency
                     amount divided by 1,000.


CAM-CYDCUR-THOU      Derived
Cydcur Thou          The current year-to-date currency
                     amount divided by 1,000.


CAM-PARENT-OBJ-ID    Numeric 12                                  GL167   GL199
Parent Obj Id        This is the parent object identifier.       GL327
                     This unique key facilitates drill
                     around to the parent record.

                         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   GL167
          VAR-LEVELS                                             GL190   GL191
          ACCOUNT                                                GL197   GL199
          SUB-ACCOUNT                                            GL291   GL296
          ACCT-UNIT                                              GL300   GL327
          CURRENCY-CODE                                          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  GL320   GL327
          AMT-TYPE      and subaccount, and variable levels,     GL330   GLOP.1
          CURRENCY-CODE within company.
          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   GL199
          ACCOUNT                                                GL310   GL500
          SUB-ACCOUNT                                            GL90.1  GL90.4
          AMT-TYPE                                               GL20.2
          CURRENCY-CODE
          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

CAMSET8   PARENT-OBJ-ID
          AMT-TYPE
          COMPANY
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          FISCAL-YEAR
          CURRENCY-CODE

CAMSET9   AMT-TYPE      KeyChange
          MAINT-DATE
          MAINT-TIME
          CURRENCY-CODE
          COMPANY
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          FISCAL-YEAR
          VAR-LEVELS

                         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-OBJ-ID     -> GAM-PARENT-OBJ-ID
                            CAM-COMPANY           -> GAM-COMPANY
                            CAM-ACCT-UNIT         -> GAM-ACCT-UNIT
                            CAM-ACCOUNT           -> GAM-ACCOUNT
                            CAM-SUB-ACCOUNT       -> GAM-SUB-ACCOUNT
                            CAM-FISCAL-YEAR       -> GAM-FISCAL-YEAR

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-OBJ-ID     -> GCN-OBJ-ID
                            "Y"                   -> GCN-TRANS-TYPE
                            CAM-COMPANY           -> GCN-COMPANY
                                                     GCN-VAR-LEVELS
                                                     GCN-ACCOUNT
                                                     GCN-SUB-ACCOUNT
                                                     GCN-FISCAL-YEAR
                                                     GCN-LEVEL-DEPTH
                                                     GCN-CURRENCY-CODE
                                                     GCN-BUDGET-NBR

Consol Parent2 GLCONSOL

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

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-OBJ-ID     -> CAM-PARENT-OBJ-ID
                            3                     -> CAM-AMT-TYPE
                            CAM-COMPANY           -> CAM-COMPANY
                            CAM-ACCT-UNIT         -> CAM-ACCT-UNIT
                            CAM-ACCOUNT           -> CAM-ACCOUNT
                            CAM-SUB-ACCOUNT       -> CAM-SUB-ACCOUNT
                            CAM-VAR-LEVELS        -> CAM-VAR-LEVELS
                            CAM-FISCAL-YEAR       -> CAM-FISCAL-YEAR
                                                     CAM-CURRENCY-CODE

Curr 2         CUAMOUNT

                            CAM-PARENT-OBJ-ID     -> CAM-PARENT-OBJ-ID
                            4                     -> CAM-AMT-TYPE
                            CAM-COMPANY           -> CAM-COMPANY
                            CAM-ACCT-UNIT         -> CAM-ACCT-UNIT
                            CAM-ACCOUNT           -> CAM-ACCOUNT
                            CAM-SUB-ACCOUNT       -> CAM-SUB-ACCOUNT
                            CAM-VAR-LEVELS        -> CAM-VAR-LEVELS
                            CAM-FISCAL-YEAR       -> CAM-FISCAL-YEAR
                                                     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