Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RATOTALS


                             RATOTALS FILE

                              Ratio Totals

This file contains the ratio totals and all information used to define the
range for the ratio (company and account ranges). Primary form is RW70.1
(Total Names).


REFERENCED BY

RW298     RW01.1    RW01.2    RW201     RW50.1    RW60.2

UPDATED BY

AC121     AC123     AC130     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC32.1    AC37.1    AC490     ACVW.1
AM180     CA10.5    CA110     FB100     FB11.1    FB111
FB20.1    FB20.6    FB20.7    FB21.1    FB211     FB296
FB95.1    FB95.2    FB95.3    FB95.4    FB95.5    FB95.6
GL298     GL94.1    GL94.2    GL94.3    GL94.4    GL94.5
GL94.6    GL94.7    GL95.1    GL95.2    GL95.3    GL95.4
GL95.5    GL95.6    GL95.7    GL95.8    GL95.9    GL96.1
GL96.2    GL96.3    GL96.4    GL96.5    GL97.1    GL97.2
GL97.3    GL97.4    GL97.5    GL97.6    GL97.7    GL97.8
GL97.9    GL98.1    GL98.2    GL98.3    GL98.4    GL98.5
GL99.1    GL99.2    GL99.3    GL99.4    GL99.5    GL99.6
RW100     RW230     RW270     RW30.1    RW70.1    GLAV.1
GLCV.1    GLVW.1    SLVW.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RAT-FISCAL-YEAR        Numeric 4                                 AC121   AC123
Element: Fiscal Year   This is the fiscal year for the total.    AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-TOTAL-NAME         Alpha 10                                  AC121   AC123
Element: Total Name    The total name as defined in RW70.1       AC130   AC20.1
                       (Total Names).                            AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-ACCT-UNIT          Alpha 15                                  AC121   AC123
Element: Accounting UniThe accounting unit is a shorthand        AC130   AC20.1
                       notation representing the variable level  AC20.2  AC20.3
                       number. When used in the General Ledger   AC20.4  AC20.5
                       Account Master file, the accounting unit  AC32.1  AC37.1
                       must be defined in the General Ledger     AC490   ACVW.1
                       Names file as a posting accounting unit.  AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-FOLDER-NAME        Alpha 12                                  AC121   AC123
Element: Folder Name   This is the name of a folder defined in   AC130   AC20.1
                       RW01.1 (Folder).                          AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-HEAD-NAME          Alpha 12                                  AC121   AC123
Element: Head Name     Name of total range if ranges not         AC130   AC20.1
                       specified on this record.                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-DESCRIPTION        Alpha 30  (Lower Case)                    AC121   AC123
Element: Description   The description of the total name.        AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-CALC-DATE          Numeric 8  (yyyymmdd)                     AC121   AC123
Element: Calculate Date                                          AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-CALC-TIME          Numeric 6  (hhmmss)                       AC121   AC123
Element: Calculate Time                                          AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-MAINT-DATE         Numeric 8  (yyyymmdd)                     RW70.1
Element: Maintain Date

RAT-MAINT-TIME         Numeric 6  (hhmmss)                       RW70.1
Element: Maintain Time

RAT-TRANS-TYPE         Alpha 1                                   AC121   AC123
Element: Trans Type    The transaction type that determines      AC130   AC20.1
                       how totals are generated.                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                       A = Amounts                               AC32.1  AC37.1
                       U = Units                                 AC490   ACVW.1
                       C = Acct Currency                         AM180   CA10.5
                       B = Budget Amounts                        CA110   FB100
                       N = Budget Units                          FB11.1  FB111
                       R = Rpt Currency 1                        FB20.1  FB20.6
                       S = Rpt Currency 2                        FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-BUDGET-NBR         Numeric 3                                 AC121   AC123
Element: Budget Number This is the budget number if you are      AC130   AC20.1
                       calculating a budget type total name.     AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-CURRENCY-CODE      Alpha 5                                   AC121   AC123
Element: Currency Code This field contains the company base      AC130   AC20.1
                       currency code established in Company      AC20.2  AC20.3
                       (GL10.1 ).                                AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-DB-BEG-BAL         Currency 15.2                             AC121   AC123
Element: Debit Begin Balance                                     AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-CR-BEG-BAL         Currency 15.2                             AC121   AC123
Element: Credit Begin Balance                                    AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-DB-AMOUNT          Currency 15.2 Occurs 13 Times             AC121   AC123
Element: Debit Amount                                            AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-CR-AMOUNT          Currency 15.2 Occurs 13 Times             AC121   AC123
Element: Credit Amount                                           AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-ACCT-ND            Numeric 1                                 AC121   AC123
Account Currency       The number of decimals assigned to a      AC130   AC20.1
Code                   particular account as determined by the   AC20.2  AC20.3
                       account currency.                         AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-COMPANY            Numeric 4                                 AC121   AC123
Element: Company       The company number you are defining       AC130   AC20.1
                       total name information for.               AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-OVD-ACCTUNIT       Alpha 15 Occurs 4 Times                   AC121   AC123
Element: Accounting Unit                                         AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-FR-ACCOUNT         Numeric 6                                 AC121   AC123
Element: From Account                                            AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-TH-ACCOUNT         Numeric 6                                 AC121   AC123
Element: Account                                                 AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-FR-SUB-ACCT        Numeric 4                                 AC121   AC123
Element: From Subaccount                                         AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-TH-SUB-ACCT        Numeric 4                                 AC121   AC123
Element: Subaccount                                              AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-LEVEL-GROUP        Alpha 12                                  AC121   AC123
Element: Level Group   This is a group of sequential or          AC130   AC20.1
                       nonsequential level ranges as defined in  AC20.2  AC20.3
                       RW40.1 (Level Group).                     AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-ACCOUNT-GROUP      Alpha 12                                  AC121   AC123
Element: Account Group This is a group of sequential or          AC130   AC20.1
                       nonsequential account ranges as defined   AC20.2  AC20.3
                       in RW40.3 (Account Group).                AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-SUB-ACCT-GRP       Alpha 12                                  AC121   AC123
Element: Subaccount GroThis is a group of sequential or          AC130   AC20.1
                       nonsequential subaccount ranges as        AC20.2  AC20.3
                       defined in RW40.4 (Subaccount Group).     AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-COMPANY-GROUP      Alpha 12                                  AC121   AC123
Element: Company Group The company group name as defined in      AC130   AC20.1
                       GL11.1 (Company Group).                   AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-MATRIX-LIST        Alpha 12                                  AC121   AC123
Element: Matrix List   Attribute categories are selection        AC130   AC20.1
                       parameters used to build a list of        AC20.2  AC20.3
                       objects (accounting units). Attribute     AC20.4  AC20.5
                       categories and values are the basis of    AC32.1  AC37.1
                       the selection and sorting. A attribute    AC490   ACVW.1
                       list can then be used for reporting on    AM180   CA10.5
                       and processing objects.                   CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-CHART-NAME         Alpha 12                                  AC121   AC123
Element: Chart Name    This is the name you assigned to the      AC130   AC20.1
                       chart of accounts when you defined your   AC20.2  AC20.3
                       company structure in the General Ledger   AC20.4  AC20.5
                       system.                                   AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-SUMRY-ACCT-ID      Numeric 6                                 AC121   AC123
Element: Summary AccounThe summary account name as defined in    AC130   AC20.1
                       GL00.1 (Chart of Accounts).               AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-ACCOUNT-LIST       Alpha 12                                  AC121   AC123
Element: Account List                                            AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-LEDGER             Alpha 15                                  AC121   AC123
Element: Ledger        The name that identifies the strategic    AC130   AC20.1
                       ledger.                                   AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                       The Ledger information is used to post    AC32.1  AC37.1
                       Strategic ledger data using SL190         AC490   ACVW.1
                       (Strategic Ledger Posting) or used for    AM180   CA10.5
                       reporting in the OLAP environment using   CA110   FB100
                       SL87 (Strategic Ledger Data Mart Setup).  FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL94.1
                                                                 GL94.2  GL94.3
                                                                 GL94.4  GL94.5
                                                                 GL94.6  GL94.7
                                                                 GL95.1  GL95.2
                                                                 GL95.3  GL95.4
                                                                 GL95.5  GL95.6
                                                                 GL95.7  GL95.8
                                                                 GL95.9  GL96.1
                                                                 GL96.2  GL96.3
                                                                 GL96.4  GL96.5
                                                                 GL97.1  GL97.2
                                                                 GL97.3  GL97.4
                                                                 GL97.5  GL97.6
                                                                 GL97.7  GL97.8
                                                                 ...

RAT-COMPANY-TO-USE     Derived
Element: Company To UseThe company number as defined in GL10.1
                       (Company).


RAT-CYBTOT             Derived
Element: Cybtot        The current year beginning balance
                       total.


RAT-CPTOT-DR           Derived
Current Period         The current period debit total.
Total Debit

RAT-CPTOT-CR           Derived
Current Period         The current period credit total.
Total Credit

RAT-CPTOT              Derived
Element: Current PeriodThe current period total.

RAT-CUR-PD-SUM-DR      Derived
Element: Cur Pd Sum Dr The current period summary debit
                       amount.


RAT-CUR-PD-SUM-CR      Derived
Element: Cur Pd Sum Cr The current period summary credit
                       amount.


RAT-CYDTOT             Derived
Element: Cydtot        The current year-to-date total.

RAT-CYPTOT1-DR         Derived
Element: Cyptot1 Dr    The current year period 1 debit total.

RAT-CYPTOT1-CR         Derived
Element: Cyptot1 Cr    The current year period 1 credit total.


RAT-CYPTOT1            Derived
Element: Cyptot1       The current year period 1 total.

RAT-CYPTOT2-DR         Derived
Element: Cyptot2 Dr    The current year period 2 debit total.

RAT-CYPTOT2-CR         Derived
Element: Cyptot2 Cr    The current year period 2 credit total.


RAT-CYPTOT2            Derived
Element: Cyptot2       The current year period 2 total.

RAT-CYPTOT3-DR         Derived
Element: Cyptot3 Dr    The current year period 3 debit total.

RAT-CYPTOT3-CR         Derived
Element: Cyptot3 Cr    The current year period 3 credit total.


RAT-CYPTOT3            Derived
Element: Cyptot3       The current year period 3 total.

RAT-CYPTOT4-DR         Derived
Element: Cyptot4 Dr    The current year period 4 debit total.

RAT-CYPTOT4-CR         Derived
Element: Cyptot4 Cr    The current year period 4 credit total.


RAT-CYPTOT4            Derived
Element: Cyptot4       The current year period 4 total.

RAT-CYPTOT5-DR         Derived
Element: Cyptot5 Dr    The current year period 5 debit total.

RAT-CYPTOT5-CR         Derived
Element: Cyptot5 Cr    The current year period 5 credit total.


RAT-CYPTOT5            Derived
Element: Cyptot5       The current year period 5 total.

RAT-CYPTOT6-DR         Derived
Element: Cyptot6 Dr    The current year period 6 debit total.

RAT-CYPTOT6-CR         Derived
Element: Cyptot6 Cr    The current year period 6 credit total.


RAT-CYPTOT6            Derived
Element: Cyptot6       The current year period 6 total.

RAT-CYPTOT7-DR         Derived
Element: Cyptot7 Dr    The current year period 7 debit total.

RAT-CYPTOT7-CR         Derived
Element: Cyptot7 Cr    The current year period 7 credit total.


RAT-CYPTOT7            Derived
Element: Cyptot7       The current year period 7 total.

RAT-CYPTOT8-DR         Derived
Element: Cyptot8 Dr    The current year period 8 debit total.

RAT-CYPTOT8-CR         Derived
Element: Cyptot8 Cr    The current year period 8 credit total.


RAT-CYPTOT8            Derived
Element: Cyptot8       The current year period 8 total.

RAT-CYPTOT9-DR         Derived
Element: Cyptot9 Dr    The current year period 9 debit total.

RAT-CYPTOT9-CR         Derived
Element: Cyptot9 Cr    The current year period 9 credit total.


RAT-CYPTOT9            Derived
Element: Cyptot9       The current year period 9 total.

RAT-CYPTOT10-DR        Derived
Element: Cyptot10 Dr   The current year period 10 debit total.


RAT-CYPTOT10-CR        Derived
Element: Cyptot10 Cr   The current year period 10 credit
                       total.


RAT-CYPTOT10           Derived
Element: Cyptot10      The current year period 10 total.

RAT-CYPTOT11-DR        Derived
Element: Cyptot11 Dr   The current year period 11 debit total.


RAT-CYPTOT11-CR        Derived
Element: Cyptot11 Cr   The current year period 11 credit
                       total.


RAT-CYPTOT11           Derived
Element: Cyptot11      The current year period 11 total.

RAT-CYPTOT12-DR        Derived
Element: Cyptot12 Dr   The current year period 12 debit total.


RAT-CYPTOT12-CR        Derived
Element: Cyptot12 Cr   The current year period 12 credit
                       total.


RAT-CYPTOT12           Derived
Element: Cyptot12      The current year period 12 total.

RAT-CYPTOT13-DR        Derived
Element: Cyptot13 Dr   The current year period 13 debit total.


RAT-CYPTOT13-CR        Derived
Element: Cyptot13 Cr   The current year period 13 credit
                       total.


RAT-CYPTOT13           Derived
Element: Cyptot13      The current year period 13 total.

                         RATOTALS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RATSET1   FISCAL-YEAR                                            AC121   AC123
          TOTAL-NAME                                             AC130   AC20.1
          ACCT-UNIT                                              AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 ...

RATSET2   FOLDER-NAME   KeyChange                                RW01.1  RW01.2
          FISCAL-YEAR                                            RW201   RW270
          TOTAL-NAME
          ACCT-UNIT

RATSET3   TOTAL-NAME                                             RW230   RW270
          FISCAL-YEAR                                            RW30.1  RW50.1
          ACCT-UNIT

RATSET4   HEAD-NAME     KeyChange                                RW60.2
          TOTAL-NAME
          FISCAL-YEAR
          ACCT-UNIT

RATSET5   FISCAL-YEAR   Subset                                   RW270   RW70.1
          TOTAL-NAME    Where ACCT-UNIT = Spaces                 RW70.2

                         RATOTALS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Account Group  RWHEADER     Not Required
                            Valid When RAT-ACCOUNT-GROUP != Spaces

                            "G"                  -> RWH-HEAD-TYPE
                            RAT-ACCOUNT-GROUP    -> RWH-HEAD-NAME
                            "A"                  -> RWH-RECORD-TYPE

Acct Unit      GLNAMES      Not Required

                            RAT-COMPANY          -> GLN-COMPANY
                            RAT-ACCT-UNIT        -> GLN-ACCT-UNIT

Company        GLSYSTEM     Not Required

                            RAT-COMPANY          -> GLS-COMPANY

Folder         GLCODES      Required

                            "F"                  -> GCD-RECORD-TYPE
                            RAT-FOLDER-NAME      -> GCD-FOLDER-NAME
                            Spaces               -> GCD-PROCESS-GROUP
                            Spaces               -> GCD-SYSTEM
                            Zeroes               -> GCD-COMPANY

Glchart        GLCHART      Not Required

                            RAT-CHART-NAME       -> GCH-CHART-NAME

Glchartsum     GLCHARTSUM   Not Required

                            RAT-CHART-NAME       -> GCS-CHART-NAME
                            RAT-SUMRY-ACCT-ID    -> GCS-SUMRY-ACCT-ID

Glcpygrp       GLCPYGRP     Not Required

                            RAT-COMPANY-GROUP    -> GCG-COMPANY-GROUP

Level Group    RWHEADER     Not Required
                            Valid When RAT-LEVEL-GROUP != Spaces

                            "G"                  -> RWH-HEAD-TYPE
                            RAT-LEVEL-GROUP      -> RWH-HEAD-NAME
                            "L"                  -> RWH-RECORD-TYPE

Level Group Co RWGRPDET     Not Required

                            "L"                  -> RGD-RECORD-TYPE
                            RAT-LEVEL-GROUP      -> RGD-HEAD-NAME
                            1                    -> RGD-RANGE-NUMBER

Lvl Grp Tot Rn RWGRPDET     Not Required

                            "L"                  -> RGD-RECORD-TYPE
                            RRD-LEVEL-GROUP      -> RGD-HEAD-NAME
                            1                    -> RGD-RANGE-NUMBER

Mxlisthdr      MXLISTHDR    Not Required

                            "ACCTU"              -> MLH-OBJ-TYPE
                            RAT-MATRIX-LIST      -> MLH-MATRIX-LIST

Ovd Acct Unit  GLNAMES      Not Required

                            RAT-COMPANY          -> GLN-COMPANY
                            RAT-OVD-ACCTUNIT     -> GLN-ACCT-UNIT

Subacct Group  RWHEADER     Not Required
                            Valid When RAT-SUB-ACCT-GRP != Spaces

                            "G"                  -> RWH-HEAD-TYPE
                            RAT-SUB-ACCT-GRP     -> RWH-HEAD-NAME
                            "S"                  -> RWH-RECORD-TYPE

Total Range    RWHEADER     Not Required

                            "T"                  -> RWH-HEAD-TYPE
                            RAT-HEAD-NAME        -> RWH-HEAD-NAME
                            "R"                  -> RWH-RECORD-TYPE

Total Range Co RWROWDET     Not Required

                            "R"                  -> RRD-RECORD-TYPE
                            RAT-HEAD-NAME        -> RRD-HEAD-NAME
                            1                    -> RRD-LINE-NBR

                         RATOTALS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Grp Det   RWGRPDET
                            Valid When RAT-ACCOUNT-GROUP != Spaces

                            "A"                  -> RGD-RECORD-TYPE
                            RAT-ACCOUNT-GROUP    -> RGD-HEAD-NAME
                                                    RGD-RANGE-NUMBER

Acct Unit Amts RATOTALS     Delete Cascades

                            RAT-FISCAL-YEAR      -> RAT-FISCAL-YEAR
                            RAT-TOTAL-NAME       -> RAT-TOTAL-NAME
                                                    RAT-ACCT-UNIT

Glcgcpy        GLCGCPY

                            RAT-COMPANY-GROUP    -> GCC-COMPANY-GROUP
                                                    GCC-COMPANY

Lvl Grp Det    RWGRPDET
                            Valid When RAT-LEVEL-GROUP != Spaces

                            "L"                  -> RGD-RECORD-TYPE
                            RAT-LEVEL-GROUP      -> RGD-HEAD-NAME
                                                    RGD-RANGE-NUMBER

Sub Grp Det    RWGRPDET
                            Valid When RAT-SUB-ACCT-GRP != Spaces

                            "S"                  -> RGD-RECORD-TYPE
                            RAT-SUB-ACCT-GRP     -> RGD-HEAD-NAME
                                                    RGD-RANGE-NUMBER

Tot Rng Det    RWROWDET
                            Valid When RRD- = RAT-

                            "R"                  -> RRD-RECORD-TYPE
                            RAT-HEAD-NAME        -> RRD-HEAD-NAME
                                                    RRD-LINE-NBR