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
AM180 CA10.5 CA110 FB100 FB11.1 FB111
FB20.1 FB20.6 FB20.7 FB21.1 FB211 FB296
FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6
GL298 GL94.1 GL94.2 GL94.3 GL94.4 GL94.5
GL94.6 GL94.7 GL95.1 GL95.2 GL95.3 GL95.4
GL95.5 GL95.6 GL95.7 GL95.8 GL95.9 GL96.1
GL96.2 GL96.3 GL96.4 GL96.5 GL97.1 GL97.2
GL97.3 GL97.4 GL97.5 GL97.6 GL97.7 GL97.8
GL97.9 GL98.1 GL98.2 GL98.3 GL98.4 GL98.5
GL99.1 GL99.2 GL99.3 GL99.4 GL99.5 GL99.6
RW100 RW230 RW270 RW30.1 RW70.1 GLAV.1
GLCV.1 GLVW.1 SLVW.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RAT-FISCAL-YEAR Numeric 4 AC121 AC123
Element: Fiscal Year This is the fiscal year for the total. AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-TOTAL-NAME Alpha 10 AC121 AC123
Element: Total Name The total name as defined in RW70.1 AC130 AC20.1
(Total Names). AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-ACCT-UNIT Alpha 15 AC121 AC123
Element: Accounting UniThe accounting unit is a shorthand AC130 AC20.1
notation representing the variable level AC20.2 AC20.3
number. When used in the General Ledger AC20.4 AC20.5
Account Master file, the accounting unit AC32.1 AC37.1
must be defined in the General Ledger AC490 ACVW.1
Names file as a posting accounting unit. AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-FOLDER-NAME Alpha 12 AC121 AC123
Element: Folder Name This is the name of a folder defined in AC130 AC20.1
RW01.1 (Folder). AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-HEAD-NAME Alpha 12 AC121 AC123
Element: Head Name Name of total range if ranges not AC130 AC20.1
specified on this record. AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-DESCRIPTION Alpha 30 (Lower Case) AC121 AC123
Element: Description The description of the total name. AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-CALC-DATE Numeric 8 (yyyymmdd) AC121 AC123
Element: Calculate Date AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-CALC-TIME Numeric 6 (hhmmss) AC121 AC123
Element: Calculate Time AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-MAINT-DATE Numeric 8 (yyyymmdd) RW70.1
Element: Maintain Date
RAT-MAINT-TIME Numeric 6 (hhmmss) RW70.1
Element: Maintain Time
RAT-TRANS-TYPE Alpha 1 AC121 AC123
Element: Trans Type The transaction type that determines AC130 AC20.1
how totals are generated. AC20.2 AC20.3
AC20.4 AC20.5
A = Amounts AC32.1 AC37.1
U = Units AC490 ACVW.1
C = Acct Currency AM180 CA10.5
B = Budget Amounts CA110 FB100
N = Budget Units FB11.1 FB111
R = Rpt Currency 1 FB20.1 FB20.6
S = Rpt Currency 2 FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-BUDGET-NBR Numeric 3 AC121 AC123
Element: Budget Number This is the budget number if you are AC130 AC20.1
calculating a budget type total name. AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-CURRENCY-CODE Alpha 5 AC121 AC123
Element: Currency Code This field contains the company base AC130 AC20.1
currency code established in Company AC20.2 AC20.3
(GL10.1 ). AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-DB-BEG-BAL Currency 15.2 AC121 AC123
Element: Debit Begin Balance AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-CR-BEG-BAL Currency 15.2 AC121 AC123
Element: Credit Begin Balance AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-DB-AMOUNT Currency 15.2 Occurs 13 Times AC121 AC123
Element: Debit Amount AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-CR-AMOUNT Currency 15.2 Occurs 13 Times AC121 AC123
Element: Credit Amount AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-ACCT-ND Numeric 1 AC121 AC123
Account Currency The number of decimals assigned to a AC130 AC20.1
Code particular account as determined by the AC20.2 AC20.3
account currency. AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-COMPANY Numeric 4 AC121 AC123
Element: Company The company number you are defining AC130 AC20.1
total name information for. AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-OVD-ACCTUNIT Alpha 15 Occurs 4 Times AC121 AC123
Element: Accounting Unit AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-FR-ACCOUNT Numeric 6 AC121 AC123
Element: From Account AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-TH-ACCOUNT Numeric 6 AC121 AC123
Element: Account AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-FR-SUB-ACCT Numeric 4 AC121 AC123
Element: From Subaccount AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-TH-SUB-ACCT Numeric 4 AC121 AC123
Element: Subaccount AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-LEVEL-GROUP Alpha 12 AC121 AC123
Element: Level Group This is a group of sequential or AC130 AC20.1
nonsequential level ranges as defined in AC20.2 AC20.3
RW40.1 (Level Group). AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-ACCOUNT-GROUP Alpha 12 AC121 AC123
Element: Account Group This is a group of sequential or AC130 AC20.1
nonsequential account ranges as defined AC20.2 AC20.3
in RW40.3 (Account Group). AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-SUB-ACCT-GRP Alpha 12 AC121 AC123
Element: Subaccount GroThis is a group of sequential or AC130 AC20.1
nonsequential subaccount ranges as AC20.2 AC20.3
defined in RW40.4 (Subaccount Group). AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-COMPANY-GROUP Alpha 12 AC121 AC123
Element: Company Group The company group name as defined in AC130 AC20.1
GL11.1 (Company Group). AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-MATRIX-LIST Alpha 12 AC121 AC123
Element: Matrix List Attribute categories are selection AC130 AC20.1
parameters used to build a list of AC20.2 AC20.3
objects (accounting units). Attribute AC20.4 AC20.5
categories and values are the basis of AC32.1 AC37.1
the selection and sorting. A attribute AC490 ACVW.1
list can then be used for reporting on AM180 CA10.5
and processing objects. CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-CHART-NAME Alpha 12 AC121 AC123
Element: Chart Name This is the name you assigned to the AC130 AC20.1
chart of accounts when you defined your AC20.2 AC20.3
company structure in the General Ledger AC20.4 AC20.5
system. AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-SUMRY-ACCT-ID Numeric 6 AC121 AC123
Element: Summary AccounThe summary account name as defined in AC130 AC20.1
GL00.1 (Chart of Accounts). AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-ACCOUNT-LIST Alpha 12 AC121 AC123
Element: Account List AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-LEDGER Alpha 15 AC121 AC123
Element: Ledger The name that identifies the strategic AC130 AC20.1
ledger. AC20.2 AC20.3
AC20.4 AC20.5
The Ledger information is used to post AC32.1 AC37.1
Strategic ledger data using SL190 AC490 ACVW.1
(Strategic Ledger Posting) or used for AM180 CA10.5
reporting in the OLAP environment using CA110 FB100
SL87 (Strategic Ledger Data Mart Setup). FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
...
RAT-COMPANY-TO-USE Derived
Element: Company To UseThe company number as defined in GL10.1
(Company).
RAT-CYBTOT Derived
Element: Cybtot The current year beginning balance
total.
RAT-CPTOT-DR Derived
Current Period The current period debit total.
Total Debit
RAT-CPTOT-CR Derived
Current Period The current period credit total.
Total Credit
RAT-CPTOT Derived
Element: Current PeriodThe current period total.
RAT-CUR-PD-SUM-DR Derived
Element: Cur Pd Sum Dr The current period summary debit
amount.
RAT-CUR-PD-SUM-CR Derived
Element: Cur Pd Sum Cr The current period summary credit
amount.
RAT-CYDTOT Derived
Element: Cydtot The current year-to-date total.
RAT-CYPTOT1-DR Derived
Element: Cyptot1 Dr The current year period 1 debit total.
RAT-CYPTOT1-CR Derived
Element: Cyptot1 Cr The current year period 1 credit total.
RAT-CYPTOT1 Derived
Element: Cyptot1 The current year period 1 total.
RAT-CYPTOT2-DR Derived
Element: Cyptot2 Dr The current year period 2 debit total.
RAT-CYPTOT2-CR Derived
Element: Cyptot2 Cr The current year period 2 credit total.
RAT-CYPTOT2 Derived
Element: Cyptot2 The current year period 2 total.
RAT-CYPTOT3-DR Derived
Element: Cyptot3 Dr The current year period 3 debit total.
RAT-CYPTOT3-CR Derived
Element: Cyptot3 Cr The current year period 3 credit total.
RAT-CYPTOT3 Derived
Element: Cyptot3 The current year period 3 total.
RAT-CYPTOT4-DR Derived
Element: Cyptot4 Dr The current year period 4 debit total.
RAT-CYPTOT4-CR Derived
Element: Cyptot4 Cr The current year period 4 credit total.
RAT-CYPTOT4 Derived
Element: Cyptot4 The current year period 4 total.
RAT-CYPTOT5-DR Derived
Element: Cyptot5 Dr The current year period 5 debit total.
RAT-CYPTOT5-CR Derived
Element: Cyptot5 Cr The current year period 5 credit total.
RAT-CYPTOT5 Derived
Element: Cyptot5 The current year period 5 total.
RAT-CYPTOT6-DR Derived
Element: Cyptot6 Dr The current year period 6 debit total.
RAT-CYPTOT6-CR Derived
Element: Cyptot6 Cr The current year period 6 credit total.
RAT-CYPTOT6 Derived
Element: Cyptot6 The current year period 6 total.
RAT-CYPTOT7-DR Derived
Element: Cyptot7 Dr The current year period 7 debit total.
RAT-CYPTOT7-CR Derived
Element: Cyptot7 Cr The current year period 7 credit total.
RAT-CYPTOT7 Derived
Element: Cyptot7 The current year period 7 total.
RAT-CYPTOT8-DR Derived
Element: Cyptot8 Dr The current year period 8 debit total.
RAT-CYPTOT8-CR Derived
Element: Cyptot8 Cr The current year period 8 credit total.
RAT-CYPTOT8 Derived
Element: Cyptot8 The current year period 8 total.
RAT-CYPTOT9-DR Derived
Element: Cyptot9 Dr The current year period 9 debit total.
RAT-CYPTOT9-CR Derived
Element: Cyptot9 Cr The current year period 9 credit total.
RAT-CYPTOT9 Derived
Element: Cyptot9 The current year period 9 total.
RAT-CYPTOT10-DR Derived
Element: Cyptot10 Dr The current year period 10 debit total.
RAT-CYPTOT10-CR Derived
Element: Cyptot10 Cr The current year period 10 credit
total.
RAT-CYPTOT10 Derived
Element: Cyptot10 The current year period 10 total.
RAT-CYPTOT11-DR Derived
Element: Cyptot11 Dr The current year period 11 debit total.
RAT-CYPTOT11-CR Derived
Element: Cyptot11 Cr The current year period 11 credit
total.
RAT-CYPTOT11 Derived
Element: Cyptot11 The current year period 11 total.
RAT-CYPTOT12-DR Derived
Element: Cyptot12 Dr The current year period 12 debit total.
RAT-CYPTOT12-CR Derived
Element: Cyptot12 Cr The current year period 12 credit
total.
RAT-CYPTOT12 Derived
Element: Cyptot12 The current year period 12 total.
RAT-CYPTOT13-DR Derived
Element: Cyptot13 Dr The current year period 13 debit total.
RAT-CYPTOT13-CR Derived
Element: Cyptot13 Cr The current year period 13 credit
total.
RAT-CYPTOT13 Derived
Element: Cyptot13 The current year period 13 total.
RATOTALS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RATSET1 FISCAL-YEAR AC121 AC123
TOTAL-NAME AC130 AC20.1
ACCT-UNIT AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
...
RATSET2 FOLDER-NAME KeyChange RW01.1 RW01.2
FISCAL-YEAR RW201 RW270
TOTAL-NAME
ACCT-UNIT
RATSET3 TOTAL-NAME RW230 RW270
FISCAL-YEAR RW30.1 RW50.1
ACCT-UNIT
RATSET4 HEAD-NAME KeyChange RW60.2
TOTAL-NAME
FISCAL-YEAR
ACCT-UNIT
RATSET5 FISCAL-YEAR Subset RW270 RW70.1
TOTAL-NAME Where ACCT-UNIT = Spaces RW70.2
RATOTALS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Account Group RWHEADER Not Required
Valid When RAT-ACCOUNT-GROUP != Spaces
"G" -> RWH-HEAD-TYPE
RAT-ACCOUNT-GROUP -> RWH-HEAD-NAME
"A" -> RWH-RECORD-TYPE
Acct Unit GLNAMES Not Required
RAT-COMPANY -> GLN-COMPANY
RAT-ACCT-UNIT -> GLN-ACCT-UNIT
Company GLSYSTEM Not Required
RAT-COMPANY -> GLS-COMPANY
Folder GLCODES Required
"F" -> GCD-RECORD-TYPE
RAT-FOLDER-NAME -> GCD-FOLDER-NAME
Spaces -> GCD-PROCESS-GROUP
Spaces -> GCD-SYSTEM
Zeroes -> GCD-COMPANY
Glchart GLCHART Not Required
RAT-CHART-NAME -> GCH-CHART-NAME
Glchartsum GLCHARTSUM Not Required
RAT-CHART-NAME -> GCS-CHART-NAME
RAT-SUMRY-ACCT-ID -> GCS-SUMRY-ACCT-ID
Glcpygrp GLCPYGRP Not Required
RAT-COMPANY-GROUP -> GCG-COMPANY-GROUP
Level Group RWHEADER Not Required
Valid When RAT-LEVEL-GROUP != Spaces
"G" -> RWH-HEAD-TYPE
RAT-LEVEL-GROUP -> RWH-HEAD-NAME
"L" -> RWH-RECORD-TYPE
Level Group Co RWGRPDET Not Required
"L" -> RGD-RECORD-TYPE
RAT-LEVEL-GROUP -> RGD-HEAD-NAME
1 -> RGD-RANGE-NUMBER
Lvl Grp Tot Rn RWGRPDET Not Required
"L" -> RGD-RECORD-TYPE
RRD-LEVEL-GROUP -> RGD-HEAD-NAME
1 -> RGD-RANGE-NUMBER
Mxlisthdr MXLISTHDR Not Required
"ACCTU" -> MLH-OBJ-TYPE
RAT-MATRIX-LIST -> MLH-MATRIX-LIST
Ovd Acct Unit GLNAMES Not Required
RAT-COMPANY -> GLN-COMPANY
RAT-OVD-ACCTUNIT -> GLN-ACCT-UNIT
Subacct Group RWHEADER Not Required
Valid When RAT-SUB-ACCT-GRP != Spaces
"G" -> RWH-HEAD-TYPE
RAT-SUB-ACCT-GRP -> RWH-HEAD-NAME
"S" -> RWH-RECORD-TYPE
Total Range RWHEADER Not Required
"T" -> RWH-HEAD-TYPE
RAT-HEAD-NAME -> RWH-HEAD-NAME
"R" -> RWH-RECORD-TYPE
Total Range Co RWROWDET Not Required
"R" -> RRD-RECORD-TYPE
RAT-HEAD-NAME -> RRD-HEAD-NAME
1 -> RRD-LINE-NBR
RATOTALS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Grp Det RWGRPDET
Valid When RAT-ACCOUNT-GROUP != Spaces
"A" -> RGD-RECORD-TYPE
RAT-ACCOUNT-GROUP -> RGD-HEAD-NAME
RGD-RANGE-NUMBER
Acct Unit Amts RATOTALS Delete Cascades
RAT-FISCAL-YEAR -> RAT-FISCAL-YEAR
RAT-TOTAL-NAME -> RAT-TOTAL-NAME
RAT-ACCT-UNIT
Glcgcpy GLCGCPY
RAT-COMPANY-GROUP -> GCC-COMPANY-GROUP
GCC-COMPANY
Lvl Grp Det RWGRPDET
Valid When RAT-LEVEL-GROUP != Spaces
"L" -> RGD-RECORD-TYPE
RAT-LEVEL-GROUP -> RGD-HEAD-NAME
RGD-RANGE-NUMBER
Sub Grp Det RWGRPDET
Valid When RAT-SUB-ACCT-GRP != Spaces
"S" -> RGD-RECORD-TYPE
RAT-SUB-ACCT-GRP -> RGD-HEAD-NAME
RGD-RANGE-NUMBER
Tot Rng Det RWROWDET
Valid When RRD- = RAT-
"R" -> RRD-RECORD-TYPE
RAT-HEAD-NAME -> RRD-HEAD-NAME
RRD-LINE-NBR
|