 |
Lawson Insight Technical Documentation |
|
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 AC30.2 AC30.3 AC32.1 AC490
ACVW.1 AM180 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 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
Fiscal Year This is the fiscal year for the total. AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-TOTAL-NAME Alpha 10 AC121 AC123
Total Name The total name as defined in RW70.1 AC130 AC20.1
(Total Names). AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-ACCT-UNIT Alpha 15 AC121 AC123
Accounting 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 AC30.2 AC30.3
must be defined in the General Ledger AC32.1 AC490
Names file as a posting accounting unit. ACVW.1 AM180
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
...
RAT-FOLDER-NAME Alpha 12 AC121 AC123
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
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-HEAD-NAME Alpha 12 AC121 AC123
Head Name Name of total range if ranges not AC130 AC20.1
specified on this record. AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-DESCRIPTION Alpha 30 (Lower Case) AC121 AC123
Description The description of the total name. AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-CALC-DATE Numeric 8 (yyyymmdd) AC121 AC123
Calculate Date The date amounts were last calculated. AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-CALC-TIME Numeric 6 (hhmmss) AC121 AC123
Calculate Time The time amounts were last calculated. AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
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 AC130 AC20.1
how totals are generated. AC20.2 AC20.3
AC20.4 AC20.5
A = Amounts AC30.2 AC30.3
U = Units AC32.1 AC490
C = Acct Currency ACVW.1 AM180
B = Budget Amounts CA10.5 CA110
N = Budget Units FB100 FB20.1
R = Rpt Currency 1 FB20.6 FB20.7
S = Rpt Currency 2 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
...
RAT-BUDGET-NBR Numeric 3 AC121 AC123
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
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-CURRENCY-CODE Alpha 5 AC121 AC123
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
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-DB-BEG-BAL Currency 15.2 AC121 AC123
Debit Begin Balance The debit beginning balance. AC130 AC490
ACVW.1 AM180
CA110 FB100
FB21.1 GLAV.1
GLCV.1 GLVW.1
RW100 RW230
RW270 RW30.1
SLVW.1
RAT-CR-BEG-BAL Currency 15.2 AC121 AC123
Credit Begin Balance The credit beginning balance. AC130 AC490
ACVW.1 AM180
CA110 FB100
FB21.1 GLAV.1
GLCV.1 GLVW.1
RW100 RW230
RW270 RW30.1
SLVW.1
RAT-DB-AMOUNT Currency 15.2 Occurs 13 Times AC121 AC123
Debit Amount The budget debit amount. AC130 AC490
ACVW.1 AM180
CA110 FB100
FB21.1 GLAV.1
GLCV.1 GLVW.1
RW100 RW230
RW270 RW30.1
SLVW.1
RAT-CR-AMOUNT Currency 15.2 Occurs 13 Times AC121 AC123
Credit Amount The budget credit amount. AC130 AC490
ACVW.1 AM180
CA110 FB100
FB21.1 GLAV.1
GLCV.1 GLVW.1
RW100 RW230
RW270 RW30.1
SLVW.1
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
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-COMPANY Numeric 4 AC121 AC123
Company The company number you are defining AC130 AC20.1
total name information for. AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-OVD-ACCTUNIT Alpha 15 Occurs 4 Times AC121 AC123
Ovd Acctunit The accounting units defined for the AC130 AC20.1
record. AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-FR-ACCOUNT Numeric 6 AC121 AC123
From Account This is the beginning account for a AC130 AC20.1
range of accounts. AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-TH-ACCOUNT Numeric 6 AC121 AC123
Through Account This is the ending account for a range AC130 AC20.1
of accounts. AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-FR-SUB-ACCT Numeric 4 AC121 AC123
From Subaccount This is the beginning subaccount for a AC130 AC20.1
range of subaccounts. AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-TH-SUB-ACCT Numeric 4 AC121 AC123
Through Subaccount This is the ending subaccount for a AC130 AC20.1
range of subaccounts. AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-LEVEL-GROUP Alpha 12 AC121 AC123
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
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-ACCOUNT-GROUP Alpha 12 AC121 AC123
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
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-SUB-ACCT-GRP Alpha 12 AC121 AC123
Subaccount Group This 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
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-COMPANY-GROUP Alpha 12 AC121 AC123
Company Group The company group name as defined in AC130 AC20.1
GL11.1 (Company Group). AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-MATRIX-LIST Alpha 12 AC121 AC123
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 AC30.2 AC30.3
the selection and sorting. A attribute AC32.1 AC490
list can then be used for reporting on ACVW.1 AM180
and processing objects. 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
...
RAT-CHART-NAME Alpha 12 AC121 AC123
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. AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-SUMRY-ACCT-ID Numeric 6 AC121 AC123
Summary Account ID The summary account name as defined in AC130 AC20.1
GL00.1 (Chart of Accounts). AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-ACCOUNT-LIST Alpha 12 AC121 AC123
Account List AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
RAT-LEDGER Alpha 15 AC121 AC123
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 AC30.2 AC30.3
Strategic ledger data using SL190 AC32.1 AC490
(Strategic Ledger Posting) or used for ACVW.1 AM180
reporting in the OLAP environment using CA10.5 CA110
SL87 (Strategic Ledger Data Mart Setup). 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
...
RAT-COMPANY-TO-USE Derived
Company To Use 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 AC130 AC20.1
ACCT-UNIT AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
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
...
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
|