Lawson Insight Technical Documentation |
|
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
ATVW.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 SNOA.1 SNRA.1 SNSA.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 ATVW.1
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
...
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 ATVW.1
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
...
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 ATVW.1
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
...
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 ATVW.1
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
...
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 ATVW.1
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
...
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 ATVW.1
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
...
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 ATVW.1
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
...
RAT-CALC-TIME Numeric 6 (hhmmss) AC121 AC123
Element: Calculate Time AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
...
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
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 ATVW.1
B = Budget Amounts CA10.5 CA110
N = Budget Units FB100 FB11.1
R = Rpt Currency 1 FB111 FB160
S = Rpt Currency 2 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
...
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 ATVW.1
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
...
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 ATVW.1
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
...
RAT-DB-BEG-BAL Signed 18.2 AC121 AC123
Element: Debit Begin Balance AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
...
RAT-CR-BEG-BAL Signed 18.2 AC121 AC123
Element: Credit Begin Balance AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
...
RAT-DB-AMOUNT Signed 18.2 Occurs 13 Times AC121 AC123
Element: Debit Amount AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
...
RAT-CR-AMOUNT Signed 18.2 Occurs 13 Times AC121 AC123
Element: Credit Amount AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
...
RAT-ACCT-ND Numeric 1 AC121 AC123
Element: Acct Nd The number of decimals assigned to a AC130 AC20.1
particular account as determined by the AC20.2 AC20.3
account currency. AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
...
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 ATVW.1
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
...
RAT-OVD-ACCTUNIT Alpha 15 Occurs 4 Times AC121 AC123
Element: Acct Unit The 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 ATVW.1
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
...
RAT-FR-ACCOUNT Numeric 6 AC121 AC123
Element: From Account This field along with the accounting AC130 AC20.1
unit and subaccount make up the location AC20.2 AC20.3
(account) where amounts and other AC20.4 AC20.5
account information is stored. AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
...
RAT-TH-ACCOUNT Numeric 6 AC121 AC123
Element: Account This field along with the accounting AC130 AC20.1
unit and subaccount make up the location AC20.2 AC20.3
(account) where amounts and other AC20.4 AC20.5
account information is stored. AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
...
RAT-FR-SUB-ACCT Numeric 4 AC121 AC123
Element: From SubaccounThis field contains the subaccount from AC130 AC20.1
your general ledger chart of accounts AC20.2 AC20.3
that was charged with the amount carried AC20.4 AC20.5
on this record. AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
...
RAT-TH-SUB-ACCT Numeric 4 AC121 AC123
Element: Sub Acct This field contains the subaccount from AC130 AC20.1
your general ledger chart of accounts AC20.2 AC20.3
that was charged with the amount carried AC20.4 AC20.5
on this record. AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
...
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 ATVW.1
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
...
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 ATVW.1
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
...
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 ATVW.1
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
...
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 ATVW.1
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
...
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 ATVW.1
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
...
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 ATVW.1
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
...
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 ATVW.1
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
...
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 ATVW.1
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
...
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 ATVW.1
reporting in the OLAP environment using CA10.5 CA110
SL87 (Strategic Ledger Data Mart Setup). 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
...
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
Element: Cptot Dr The current period debit total.
RAT-CPTOT-CR Derived
Element: Cptot Cr The current period credit total.
RAT-CPTOT Derived
Element: Cptot The 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
ATVW.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
...
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
|