RATOTALS

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).
UPDATED BY
ACVW.1 AM180 CA10.5 CA110 FB100 FB11.1
FB111 FB160 FB20.1 FB20.6 FB20.7 FB21.1
FB211 FB296 FB60.1 FB95.1 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 GL298 GL299 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 RW70.2 GLAV.1
GLCV.1 GLVW.1 SLVW.1 SNOA.1 SNRA.1 SNSA.1
RW298 RW01.1 RW01.2 RW201 RW50.1 RW60.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RAT-FISCAL-YEAR
Element: Fiscal Year		Numeric 4
This is the fiscal year for the total. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-TOTAL-NAME
Element: Total Name		Alpha 10
The total name as defined in RW70.1 (Total Names). 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-ACCT-UNIT
Element: Accounting Unit		Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-FOLDER-NAME
Element: Folder Name		Alpha 12
This is the name of a folder defined in RW01.1 (Folder). 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-HEAD-NAME
Element: Head Name		Alpha 12
Name of total range if ranges not specified on this record. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
The description of the total name. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-CALC-DATE
Element: Calculate Date		Numeric 8 (yyyymmdd)
The date amounts were last calculated. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-CALC-TIME
Element: Calculate Time		Numeric 6 (hhmmss)
 ...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-MAINT-DATE
Element: Maintain Date		Numeric 8 (yyyymmdd)
The date last changed.
RW70.1
RAT-MAINT-TIME
Element: Maintain Time		Numeric 6 (hhmmss)
RW70.1
RAT-TRANS-TYPE
Element: Trans Type		Alpha 1
The transaction type that determines how totals are generated.
A = Amounts
U = Units
C = Acct Currency
B = Budget Amounts
N = Budget Units
R = Rpt Currency 1
S = Rpt Currency 2		 ...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-BUDGET-NBR
Element: Budget Number		Numeric 3
This is the budget number if you are calculating a budget type total name. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ). 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-DB-BEG-BAL
Element: Debit Begin Balance		Signed 18.2
 ...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-CR-BEG-BAL
Element: Credit Begin Balance		Signed 18.2
 ...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-DB-AMOUNT
Element: Debit Amount		Signed 18.2 Occurs 13 Times
 ...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-CR-AMOUNT
Element: Credit Amount		Signed 18.2 Occurs 13 Times
 ...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-ACCT-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-COMPANY
Element: Company		Numeric 4
The company number you are defining total name information for. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-OVD-ACCTUNIT
Element: Acct Unit		Alpha 15 Occurs 4 Times
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-FR-ACCOUNT
Element: From Account		Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-TH-ACCOUNT
Element: Account		Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-FR-SUB-ACCT
Element: From Subaccount		Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-TH-SUB-ACCT
Element: Sub Acct		Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-LEVEL-GROUP
Element: Level Group		Alpha 12
This is a group of sequential or nonsequential level ranges as defined in RW40.1 (Level Group). 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-ACCOUNT-GROUP
Element: Account Group		Alpha 12
This is a group of sequential or nonsequential account ranges as defined in RW40.3 (Account Group). 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-SUB-ACCT-GRP
Element: Subaccount Group		Alpha 12
This is a group of sequential or nonsequential subaccount ranges as defined in RW40.4 (Subaccount Group). 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-COMPANY-GROUP
Element: Company Group		Alpha 12
The company group name as defined in GL11.1 (Company Group). 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-MATRIX-LIST
Element: Matrix List		Alpha 12
The Accounting Unit List is one of the organizational parameter options and is defined in MX10 (List) for object type ACCTU. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-CHART-NAME
Element: Chart Name		Alpha 12
This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-SUMRY-ACCT-ID
Element: Summary Account ID		Numeric 6
The summary account name as defined in GL00.1 (Chart of Accounts). 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-ACCOUNT-LIST
Element: Account List		Alpha 12
The Account List is one of the Account parameter options and is defined in MX10 (List) for object type ACCNT. 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-LEDGER
Element: Ledger		Alpha 15
The name that identifies the strategic ledger. The Ledger information is used to post Strategic ledger data using SL190 (Strategic Ledger Posting) or used for reporting in the OLAP environment using SL87 (Strategic Ledger Data Mart Setup). 		...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
RAT-COMPANY-TO-USE
Element: Company To Use		Derived
The company number as defined in GL10.1 (Company).
RAT-CYBTOT
Element: Cybtot		Derived
The current year beginning balance total.
RAT-CPTOT-DR
Element: Cptot Dr		Derived
The current period debit total.
RAT-CPTOT-CR
Element: Cptot Cr		Derived
The current period credit total.
RAT-CPTOT
Element: Cptot		Derived
The current period total.
RAT-CUR-PD-SUM-DR
Element: Cur Pd Sum Dr		Derived
The current period summary debit amount.
RAT-CUR-PD-SUM-CR
Element: Cur Pd Sum Cr		Derived
The current period summary credit amount.
RAT-CYDTOT
Element: Cydtot		Derived
The current year-to-date total.
RAT-CYPTOT1-DR
Element: Cyptot1 Dr		Derived
The current year period 1 debit total.
RAT-CYPTOT1-CR
Element: Cyptot1 Cr		Derived
The current year period 1 credit total.
RAT-CYPTOT1
Element: Cyptot1		Derived
The current year period 1 total.
RAT-CYPTOT2-DR
Element: Cyptot2 Dr		Derived
The current year period 2 debit total.
RAT-CYPTOT2-CR
Element: Cyptot2 Cr		Derived
The current year period 2 credit total.
RAT-CYPTOT2
Element: Cyptot2		Derived
The current year period 2 total.
RAT-CYPTOT3-DR
Element: Cyptot3 Dr		Derived
The current year period 3 debit total.
RAT-CYPTOT3-CR
Element: Cyptot3 Cr		Derived
The current year period 3 credit total.
RAT-CYPTOT3
Element: Cyptot3		Derived
The current year period 3 total.
RAT-CYPTOT4-DR
Element: Cyptot4 Dr		Derived
The current year period 4 debit total.
RAT-CYPTOT4-CR
Element: Cyptot4 Cr		Derived
The current year period 4 credit total.
RAT-CYPTOT4
Element: Cyptot4		Derived
The current year period 4 total.
RAT-CYPTOT5-DR
Element: Cyptot5 Dr		Derived
The current year period 5 debit total.
RAT-CYPTOT5-CR
Element: Cyptot5 Cr		Derived
The current year period 5 credit total.
RAT-CYPTOT5
Element: Cyptot5		Derived
The current year period 5 total.
RAT-CYPTOT6-DR
Element: Cyptot6 Dr		Derived
The current year period 6 debit total.
RAT-CYPTOT6-CR
Element: Cyptot6 Cr		Derived
The current year period 6 credit total.
RAT-CYPTOT6
Element: Cyptot6		Derived
The current year period 6 total.
RAT-CYPTOT7-DR
Element: Cyptot7 Dr		Derived
The current year period 7 debit total.
RAT-CYPTOT7-CR
Element: Cyptot7 Cr		Derived
The current year period 7 credit total.
RAT-CYPTOT7
Element: Cyptot7		Derived
The current year period 7 total.
RAT-CYPTOT8-DR
Element: Cyptot8 Dr		Derived
The current year period 8 debit total.
RAT-CYPTOT8-CR
Element: Cyptot8 Cr		Derived
The current year period 8 credit total.
RAT-CYPTOT8
Element: Cyptot8		Derived
The current year period 8 total.
RAT-CYPTOT9-DR
Element: Cyptot9 Dr		Derived
The current year period 9 debit total.
RAT-CYPTOT9-CR
Element: Cyptot9 Cr		Derived
The current year period 9 credit total.
RAT-CYPTOT9
Element: Cyptot9		Derived
The current year period 9 total.
RAT-CYPTOT10-DR
Element: Cyptot10 Dr		Derived
The current year period 10 debit total.
RAT-CYPTOT10-CR
Element: Cyptot10 Cr		Derived
The current year period 10 credit total.
RAT-CYPTOT10
Element: Cyptot10		Derived
The current year period 10 total.
RAT-CYPTOT11-DR
Element: Cyptot11 Dr		Derived
The current year period 11 debit total.
RAT-CYPTOT11-CR
Element: Cyptot11 Cr		Derived
The current year period 11 credit total.
RAT-CYPTOT11
Element: Cyptot11		Derived
The current year period 11 total.
RAT-CYPTOT12-DR
Element: Cyptot12 Dr		Derived
The current year period 12 debit total.
RAT-CYPTOT12-CR
Element: Cyptot12 Cr		Derived
The current year period 12 credit total.
RAT-CYPTOT12
Element: Cyptot12		Derived
The current year period 12 total.
RAT-CYPTOT13-DR
Element: Cyptot13 Dr		Derived
The current year period 13 debit total.
RAT-CYPTOT13-CR
Element: Cyptot13 Cr		Derived
The current year period 13 credit total.
RAT-CYPTOT13
Element: Cyptot13		Derived
The current year period 13 total.


RATOTALS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RATSET1 FISCAL-YEAR
TOTAL-NAME
ACCT-UNIT
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
RATSET2 FOLDER-NAME
FISCAL-YEAR
TOTAL-NAME
ACCT-UNIT
KeyChange
RW01.1 RW01.2
RW201 RW270
RATSET3 TOTAL-NAME
FISCAL-YEAR
ACCT-UNIT
RW230 RW270
RW30.1 RW50.1
RATSET4 HEAD-NAME
TOTAL-NAME
FISCAL-YEAR
ACCT-UNIT
KeyChange
RW60.2
RATSET5 FISCAL-YEAR
TOTAL-NAME
Subset
WhereACCT-UNIT =Spaces
RW270 RW70.1
RW70.2


RATOTALS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Wed Jun 08 20:48:42 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.