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 AC127 AC130 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB700 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 GLCV.1 GLVW.1 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY RAT-FISCAL-YEAR Numeric 4 AC121 AC123 Fiscal Year This is the fiscal year for the total. AC127 AC130 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-TOTAL-NAME Alpha 10 AC121 AC123 Total Name The total name as defined in RW70.1 AC127 AC130 (Total Names). AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-ACCT-UNIT Alpha 15 AC121 AC123 Accounting Unit The accounting unit is a shorthand AC127 AC130 notation representing the variable level AC20.1 AC20.2 number. When used in the General Ledger AC20.3 AC20.4 Account Master file, the accounting unit AC22.1 AC30.2 must be defined in the General Ledger AC30.3 AC32.1 Names file as a posting accounting unit. ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-FOLDER-NAME Alpha 12 AC121 AC123 Folder Name This is the name of a folder defined in AC127 AC130 RW01.1 (Folder). AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-HEAD-NAME Alpha 12 AC121 AC123 Head Name Name of total range if ranges not AC127 AC130 specified on this record. AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-DESCRIPTION Alpha 30 (Lower Case) AC121 AC123 Description The description of the total name. AC127 AC130 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-CALC-DATE Numeric 8 (yyyymmdd) AC121 AC123 Calculate Date The date amounts were last calculated. AC127 AC130 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-CALC-TIME Numeric 6 (hhmmss) AC121 AC123 Calculate Time The time amounts were last calculated. AC127 AC130 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-MAINT-DATE Numeric 8 (yyyymmdd) RW70.1 Maintain Date The date last changed. RAT-MAINT-TIME Numeric 6 (hhmmss) RW70.1 Maintain Time The time last changed. RAT-TRANS-TYPE Alpha 1 AC121 AC123 Trans Type The transaction type that determines AC127 AC130 how totals are generated. AC20.1 AC20.2 AC20.3 AC20.4 A = Amounts AC22.1 AC30.2 U = Units AC30.3 AC32.1 C = Currency ACVW.1 CA10.5 B = Budget Amounts CA110 FB100 N = Budget Units FB20.1 FB20.6 FB20.7 FB21.1 FB700 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-BUDGET-NBR Numeric 3 AC121 AC123 Budget Number This is the budget number if you are AC127 AC130 calculating a budget type total name. AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-DB-BEG-BAL Currency 15.2 AC121 AC123 Debit Begin Balance The debit beginning balance. AC127 AC130 AC22.1 AC32.1 ACVW.1 CA110 FB100 FB21.1 GLCV.1 GLVW.1 RW100 RW230 RW270 RW30.1 RAT-CR-BEG-BAL Currency 15.2 AC121 AC123 Credit Begin Balance The credit beginning balance. AC127 AC130 AC22.1 AC32.1 ACVW.1 CA110 FB100 FB21.1 GLCV.1 GLVW.1 RW100 RW230 RW270 RW30.1 RAT-DB-AMOUNT Currency 15.2 Occurs 13 Times AC121 AC123 Debit Amount The budget debit amount. AC127 AC130 AC22.1 AC32.1 ACVW.1 CA110 FB100 FB21.1 GLCV.1 GLVW.1 RW100 RW230 RW270 RW30.1 RAT-CR-AMOUNT Currency 15.2 Occurs 13 Times AC121 AC123 Credit Amount The budget credit amount. AC127 AC130 AC22.1 AC32.1 ACVW.1 CA110 FB100 FB21.1 GLCV.1 GLVW.1 RW100 RW230 RW270 RW30.1 RAT-ACCT-ND Numeric 1 AC121 AC123 Account The number of decimals assigned to a AC127 AC130 particular account as determined by the AC20.1 AC20.2 account currency. AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-COMPANY Numeric 4 AC121 AC123 Company The company number you are defining AC127 AC130 total name information for. AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-OVD-ACCTUNIT Alpha 15 Occurs 4 Times AC121 AC123 Override Accounting The accounting units defined for the AC127 AC130 Unit record. AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-FR-ACCOUNT Numeric 6 AC121 AC123 From Account This is the beginning account for a AC127 AC130 range of accounts. AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-TH-ACCOUNT Numeric 6 AC121 AC123 Through Account This is the ending account for a range AC127 AC130 of accounts. AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-FR-SUB-ACCT Numeric 4 AC121 AC123 From Subaccount This is the beginning subaccount for a AC127 AC130 range of subaccounts. AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-TH-SUB-ACCT Numeric 4 AC121 AC123 Through Subaccount This is the ending subaccount for a AC127 AC130 range of subaccounts. AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-LEVEL-GROUP Alpha 12 AC121 AC123 Level Group This is a group of sequential or AC127 AC130 nonsequential level ranges as defined in AC20.1 AC20.2 RW40.1 (Level Group). AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-ACCOUNT-GROUP Alpha 12 AC121 AC123 Account Group This is a group of sequential or AC127 AC130 nonsequential account ranges as defined AC20.1 AC20.2 in RW40.3 (Account Group). AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-SUB-ACCT-GRP Alpha 12 AC121 AC123 Subaccount Group This is a group of sequential or AC127 AC130 nonsequential subaccount ranges as AC20.1 AC20.2 defined in RW40.4 (Subaccount Group). AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-COMPANY-GROUP Alpha 12 AC121 AC123 Company Group The company group name as defined in AC127 AC130 GL11.1 (Company Group). AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-MATRIX-LIST Alpha 12 AC121 AC123 Matrix List Attribute categories are selection AC127 AC130 parameters used to build a list of AC20.1 AC20.2 objects (accounting units). Attribute AC20.3 AC20.4 categories and values are the basis of AC22.1 AC30.2 the selection and sorting. A attribute AC30.3 AC32.1 list can then be used for reporting on ACVW.1 CA10.5 and processing objects. CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-CHART-NAME Alpha 12 AC121 AC123 Chart Name This is the name you assigned to the AC127 AC130 chart of accounts when you defined your AC20.1 AC20.2 company structure in the General Ledger AC20.3 AC20.4 system. AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-SUMRY-ACCT-ID Numeric 6 AC121 AC123 Summary Account ID The summary account name as defined in AC127 AC130 GL00.1 (Chart of Accounts). AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-CURRENCY-CODE Alpha 5 AC121 AC123 Currency Code This field contains the company base AC127 AC130 currency code established in GL10.1 AC20.1 AC20.2 (Company). AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 ... RAT-COMPANY-TO-USE Derived Company The company number as defined in GL10.1 (Company). RAT-CYBTOT Derived 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 Current Period Total The current period total. RAT-CUR-PD-SUM-DR Derived Cur Pd Sum Dr The current period summary debit amount. RAT-CUR-PD-SUM-CR Derived Cur Pd Sum Cr The current period summary credit amount. RAT-CYDTOT Derived Cydtot The current year-to-date total. RAT-CYPTOT1-DR Derived Cyptot1 Dr The current year period 1 debit total. RAT-CYPTOT1-CR Derived Cyptot1 Cr The current year period 1 credit total. RAT-CYPTOT1 Derived Cyptot1 The current year period 1 total. RAT-CYPTOT2-DR Derived Cyptot2 Dr The current year period 2 debit total. RAT-CYPTOT2-CR Derived Cyptot2 Cr The current year period 2 credit total. RAT-CYPTOT2 Derived Cyptot2 The current year period 2 total. RAT-CYPTOT3-DR Derived Cyptot3 Dr The current year period 3 debit total. RAT-CYPTOT3-CR Derived Cyptot3 Cr The current year period 3 credit total. RAT-CYPTOT3 Derived Cyptot3 The current year period 3 total. RAT-CYPTOT4-DR Derived Cyptot4 Dr The current year period 4 debit total. RAT-CYPTOT4-CR Derived Cyptot4 Cr The current year period 4 credit total. RAT-CYPTOT4 Derived Cyptot4 The current year period 4 total. RAT-CYPTOT5-DR Derived Cyptot5 Dr The current year period 5 debit total. RAT-CYPTOT5-CR Derived Cyptot5 Cr The current year period 5 credit total. RAT-CYPTOT5 Derived Cyptot5 The current year period 5 total. RAT-CYPTOT6-DR Derived Cyptot6 Dr The current year period 6 debit total. RAT-CYPTOT6-CR Derived Cyptot6 Cr The current year period 6 credit total. RAT-CYPTOT6 Derived Cyptot6 The current year period 6 total. RAT-CYPTOT7-DR Derived Cyptot7 Dr The current year period 7 debit total. RAT-CYPTOT7-CR Derived Cyptot7 Cr The current year period 7 credit total. RAT-CYPTOT7 Derived Cyptot7 The current year period 7 total. RAT-CYPTOT8-DR Derived Cyptot8 Dr The current year period 8 debit total. RAT-CYPTOT8-CR Derived Cyptot8 Cr The current year period 8 credit total. RAT-CYPTOT8 Derived Cyptot8 The current year period 8 total. RAT-CYPTOT9-DR Derived Cyptot9 Dr The current year period 9 debit total. RAT-CYPTOT9-CR Derived Cyptot9 Cr The current year period 9 credit total. RAT-CYPTOT9 Derived Cyptot9 The current year period 9 total. RAT-CYPTOT10-DR Derived Cyptot10 Dr The current year period 10 debit total. RAT-CYPTOT10-CR Derived Cyptot10 Cr The current year period 10 credit total. RAT-CYPTOT10 Derived Cyptot10 The current year period 10 total. RAT-CYPTOT11-DR Derived Cyptot11 Dr The current year period 11 debit total. RAT-CYPTOT11-CR Derived Cyptot11 Cr The current year period 11 credit total. RAT-CYPTOT11 Derived Cyptot11 The current year period 11 total. RAT-CYPTOT12-DR Derived Cyptot12 Dr The current year period 12 debit total. RAT-CYPTOT12-CR Derived Cyptot12 Cr The current year period 12 credit total. RAT-CYPTOT12 Derived Cyptot12 The current year period 12 total. RAT-CYPTOT13-DR Derived Cyptot13 Dr The current year period 13 debit total. RAT-CYPTOT13-CR Derived Cyptot13 Cr The current year period 13 credit total. RAT-CYPTOT13 Derived 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 AC127 AC130 ACCT-UNIT AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7 FB21.1 FB700 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 GL95.1 GL95.2 GL95.3 ... RATSET2 FOLDER-NAME 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 RAT- = RAT- "R" -> RRD-RECORD-TYPE RAT-HEAD-NAME -> RRD-HEAD-NAME RRD-LINE-NBR |