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).
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
RAT-FISCAL-YEAR
Element: Fiscal Year | Numeric 4
This is the fiscal year for the total.
|
|
RAT-TOTAL-NAME
Element: Total Name | Alpha 10
The total name as defined in RW70.1
(Total Names).
|
|
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.
|
|
RAT-FOLDER-NAME
Element: Folder Name | Alpha 12
This is the name of a folder defined in
RW01.1 (Folder).
|
|
RAT-HEAD-NAME
Element: Head Name | Alpha 12
Name of total range if ranges not
specified on this record.
|
|
RAT-DESCRIPTION
Element: Description | Alpha 30 (Lower Case)
The description of the total name.
|
|
RAT-CALC-DATE
Element: Calculate Date | Numeric 8 (yyyymmdd)
The date amounts were last calculated.
|
|
RAT-CALC-TIME
Element: Calculate Time | Numeric 6 (hhmmss)
|
|
RAT-MAINT-DATE
Element: Maintain Date | Numeric 8 (yyyymmdd)
The date last changed.
|
|
RAT-MAINT-TIME
Element: Maintain Time | Numeric 6 (hhmmss)
|
|
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 |
|
RAT-BUDGET-NBR
Element: Budget Number | Numeric 3
This is the budget number if you are
calculating a budget type total name.
|
|
RAT-CURRENCY-CODE
Element: Currency Code | Alpha 5
This field contains the company base
currency code established in Company
(GL10.1 ).
|
|
RAT-DB-BEG-BAL
Element: Debit Begin Balance | Signed 18.2
|
|
RAT-CR-BEG-BAL
Element: Credit Begin Balance | Signed 18.2
|
|
RAT-DB-AMOUNT
Element: Debit Amount | Signed 18.2 Occurs 13 Times
|
|
RAT-CR-AMOUNT
Element: Credit Amount | Signed 18.2 Occurs 13 Times
|
|
RAT-ACCT-ND
Element: Acct Nd | Numeric 1
The number of decimals assigned to a
particular account as determined by the
account currency.
|
|
RAT-COMPANY
Element: Company | Numeric 4
The company number you are defining
total name information for.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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).
|
|
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).
|
|
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).
|
|
RAT-COMPANY-GROUP
Element: Company Group | Alpha 12
The company group name as defined in
GL11.1 (Company Group).
|
|
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.
|
|
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.
|
|
RAT-SUMRY-ACCT-ID
Element: Summary Account ID | Numeric 6
The summary account name as defined in
GL00.1 (Chart of Accounts).
|
|
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.
|
|
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).
|
|
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.
|
|
