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

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
Element: 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
Element: Last Closed YeKey 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
Element: 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
Element: Variable LevelKey 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
Element: 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
Element: 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
Element: Accounting UniThe 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
Element: 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
Element: Name User     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
Account Currency       This field determines the number of       GL167   GL190
Code                   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
Account Currency       This is the defined number of decimal     GL167   GL190
Code                   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
Element: Rpt1 Db Bbal  The Report One currency debit beginning   GL310   GL327
                       balance.


CAM-RPT1-CR-BBAL       Currency 15.2                             GL167   GL199
Element: Rpt1 Cr Bbal  The Report One currency credit beginning  GL310   GL327
                       balance.

CAM-RPT2-DB-BBAL       Currency 15.2                             GL167   GL199
Element: Rpt2 Db Bbal  The Report Two currency debit beginning   GL310   GL327
                       balance amount.

CAM-RPT2-CR-BBAL       Currency 15.2                             GL167   GL199
Element: Rpt2 Cr Bbal  The Report Two currency credit beginning  GL310   GL327
                       balance amount.

CAM-DB-AMOUNT          Currency 15.2 Occurs 13 Times             GL110   GL146
Element: Budget Debit AThis 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
Element: Budget Credit 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
Element: Rpt1 Db Amt   The Report One currency debit amount for  GL190   GL197
                       the period.                               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
Element: Rpt1 Cr Amt   The Report One currency credit amount     GL190   GL197
                       for the period.                           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
Element: Rpt2 Db Amt   The Report Two currency debit amount for  GL190   GL197
                       the period.                               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
Element: Rpt2 Cr Amt   The Report Two currency credit amount     GL190   GL197
                       for the period.                           GL310   GL327
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

CAM-MAINT-DATE         Numeric 8  (yyyymmdd)
Element: Date

CAM-MAINT-TIME         Numeric 6  (hhmmss)
Element: Sys Time

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
Element: Period 1 Base 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
Element: Period 2 Base 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
Element: Period 3 Base 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
Element: Period 4 Base 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
Element: Period 5 Base 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
Element: Period 6 Base 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
Element: Period 7 Base 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
Element: Period 8 Base 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
Element: Period 9 Base 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
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-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
Element: Blank         This derived field is always blank. It
                       is used in drill around to allow for
                       column headings.


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


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


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


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


CAM-PARENT-OBJ-ID      Numeric 12                                GL167   GL199
Object                 This is the parent object identifier.     GL327
Identification         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  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   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 KeyChange
          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