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
FB160     FB20.1    FB20.6    FB20.7    FB21.1    FB211
FB296     FB60.1    FB95.1    FB95.2    FB95.3    FB95.4
FB95.5    FB95.6    GL298     GL90.6    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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

RAT-CALC-DATE          Numeric 8  (yyyymmdd)                     AC121   AC123
Element: Calculate DateThe date amounts were last calculated.    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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

RAT-CALC-TIME          Numeric 6  (hhmmss)                       AC121   AC123
Element: Calculate TimeThe time amounts were last calculated.    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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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

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

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                        FB160   FB20.1
                       S = Rpt Currency 2                        FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

RAT-DB-BEG-BAL         Signed 18.2                               AC121   AC123
Element: Debit Begin BaThe debit beginning 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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

RAT-CR-BEG-BAL         Signed 18.2                               AC121   AC123
Element: Credit Begin BThe credit beginning 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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

RAT-DB-AMOUNT          Signed 18.2 Occurs 13 Times               AC121   AC123
Element: Debit Amount  The budget 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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

RAT-CR-AMOUNT          Signed 18.2 Occurs 13 Times               AC121   AC123
Element: Credit Amount The budget 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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

RAT-OVD-ACCTUNIT       Alpha 15 Occurs 4 Times                   AC121   AC123
Element: Accounting UniThe accounting units defined for the      AC130   AC20.1
                       record.                                   AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

RAT-FR-ACCOUNT         Numeric 6                                 AC121   AC123
Element: From Account  This is the beginning account for a       AC130   AC20.1
                       range 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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

RAT-TH-ACCOUNT         Numeric 6                                 AC121   AC123
Element: Account       This is the ending account for a range    AC130   AC20.1
                       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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

RAT-FR-SUB-ACCT        Numeric 4                                 AC121   AC123
Element: From SubaccounThis is the beginning subaccount for a    AC130   AC20.1
                       range of subaccounts.                     AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

RAT-TH-SUB-ACCT        Numeric 4                                 AC121   AC123
Element: Subaccount    This is the ending subaccount for a       AC130   AC20.1
                       range of subaccounts.                     AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

RAT-MATRIX-LIST        Alpha 12                                  AC121   AC123
Element: Matrix List   The Accounting Unit List is one of the    AC130   AC20.1
                       organizational parameter options and is   AC20.2  AC20.3
                       defined in MX10  (List) for object type   AC20.4  AC20.5
                       ACCTU.                                    AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

RAT-ACCOUNT-LIST       Alpha 12                                  AC121   AC123
Element: Account List  The Account List is one of the Account    AC130   AC20.1
                       parameter options and is defined in MX10  AC20.2  AC20.3
                       (List) for object type ACCNT.             AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 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
                                                                 ...

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
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 ...

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