RWROWDET

RW Row File Detail

This file maintains the horizontal portion of a Report Writer report. The rows are named and assigned types. RW210 (Row Listing) creates listings of requested row information.

REFERENCED BY
ACVW.1 ATVW.1 AD191 FB100 FB101 FB20.1
FB20.6 FB20.7 FB21.1 RW00.1 RW215 RW230
RW260 RW270 RW298 RW299 RW30.1 RW70.1
GL16.4 GLAV.1 GLCV.1 GLVW.1 ML94.1 ML94.2
ML94.3 ML94.4 ML95.1 ML95.2 ML95.3 ML95.4
ML95.5 ML95.6 ML95.7 ML95.8 ML95.9 ML96.1
ML96.2 ML96.3 ML96.4 ML96.5 ML97.1 ML97.2
ML97.3 ML97.4 ML97.5 ML97.6 ML97.7 ML97.8
ML97.9 ML98.1 ML98.2 ML98.3 ML98.4 ML98.5
ML99.1 ML99.2 ML99.3 ML99.4 ML99.5 ML99.6
SLVW.1 SNOA.1 SNRA.1 SNSA.1


UPDATED BY
AC121 AC123 AC130 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC32.1 AC37.1 AC490 AM180
CA10.5 CA110 FB11.1 FB111 FB160 FB211
FB296 FB60.1 FB95.1 FB95.2 FB95.3 FB95.4
FB95.5 FB95.6 GL256 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 RW10.2
RW10.3 RW10.4 RW10.8 RW100 RW11.1 RW11.2
RW11.3 RW11.4 RW210 RW60.1 RW60.2 RW60.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RRD-RECORD-TYPE
Element: Record Type
Alpha 1
This field defines the record type for the row: accounts only, levels only, both levels and accounts, or ranges for totals.
A = Accounts
B = Both Levels and Accts
L = Levels
R = Ranges for Totals
RW10.2 RW10.3
RW10.4 RW11.4
RW210 RW298
RW60.1
RRD-HEAD-NAME
Element: Head Name
Alpha 12
This is the name of a Level, Group, Row, or Total Range.
RW10.2 RW10.3
RW10.4 RW10.8
RW100 RW11.4
RW210 RW298
RW60.1 RW60.3
RRD-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
RW10.2 RW10.3
RW10.4 RW11.4
RW210 RW298
RW60.1
RRD-FR-COMPANY
Element: Company
Numeric 4
You can create reports for a range of level groups within a specific company range. Type or select the beginning company number in this field. Important: When you select a company range, the companies must have the same organizational level structure.
RW10.3 RW10.4
RW11.4 RW210
RW60.1
RRD-FR-VAR-LEVELS
Element: From Variable Level
Alpha 30
You can select an additional level range to include in the row line. Type or select the beginning level number in this field.
RW10.3 RW10.4
RW11.4 RW210
RW60.1
RRD-FR-ACCOUNT
Element: Account
Numeric 6
This field determines any additional accounts you want to include in the row line. Type or select the beginning account number in this field. If you select an account range, leave the Account Group field blank.
RW10.2 RW10.4
RW11.4 RW210
RW60.1
RRD-FR-SUB-ACCT
Element: From Subaccount
Numeric 4
This field determines any additional subaccounts you want to include in the row line. Type or select the beginning subaccount number in this field. If you select a subaccount range, leave the Subaccount Group field blank.
RW10.2 RW10.4
RW11.4 RW210
RW60.1
RRD-TH-COMPANY
Element: Through Company
Numeric 4
You can create reports for a range of level groups within a specific company range. Type or select the ending company number in this field. If you leave this field blank, the beginning company number defaults.
RW10.3 RW10.4
RW11.4 RW210
RW60.1
RRD-TH-VAR-LEVELS
Through Variable
Level
Alpha 30
You can select an additional level range to include in the row line. Type or select the ending level number in this field. If you leave this field blank, the beginning level defaults.
RW10.3 RW10.4
RW11.4 RW210
RW60.1
RRD-TH-ACCOUNT
Element: Through Account
Numeric 6
This field determines any additional accounts you want to include in the row line. Type or select the ending account number in this field. If you leave this field blank, the beginning account number defaults. If you select an account range, leave the Account Group field blank.
RW10.2 RW10.4
RW11.4 RW210
RW60.1
RRD-TH-SUB-ACCT
Element: Through Subaccount
Numeric 4
This field determines any additional subaccounts you want to include in the row line. Type or select the ending subaccount number in this field. If you leave this field blank, the beginning subaccount number defaults. If you select a subaccount range, leave the Subaccount Group field blank.
RW10.2 RW10.4
RW11.4 RW210
RW60.1
RRD-ACCOUNT-DESC
Element: Account Desc
Alpha 60 (Lower Case)
The account description.
RW10.2 RW10.3
RW10.4 RW210
RRD-LINE-TYPE
Element: Line Type
Alpha 1
This field defines the line type for the row: detail, header, total, base, underline, or split.
D = Detail
H = Heading
T = Total
B = Base
U = Underline
S = Split
RW10.2 RW10.3
RW10.4 RW100
RW210
RRD-LINE-TYPE-1
Element: Line Type 1
Derived
This field is used for drill around. It displays the Line Type field values.
RRD-DETAIL
Element: Detail
Alpha 1
This field defines the kind of detail for the row: account detail, subaccount detail, level detail, or consolidated.
A = Account
S = Subaccount
L = Level
C = Consolidated
" "
RW10.2 RW10.3
RW10.4 RW210
RRD-DETAIL-1
Element: Detail 1
Derived
This field is used for drill around. It displays the Detail field values.
RRD-TOTAL-CODE
Element: Total Code
Numeric 1
Required if the line type is Total. This field indicates the level (1-9) to use for the total for this row.
1 = Level 1
2 = Level 2
3 = Level 3
4 = Level 4
5 = Level 5
6 = Level 6
7 = Level 7
8 = Level 8
9 = Level 9
0
RW10.2 RW10.3
RW10.4 RW210
RRD-TOTAL-CODE-1
Element: Total Code 1
Derived
This field is used for drill around. It displays the Total Code field values.
RRD-SPACE-CODE
Element: Space Code
Numeric 1
Indicates the number of spaces you want to advance after the account appears on a report.
1 = No blank lines
2 = One blank line
3 = Two blank lines
9 = Page break
0
RW10.2 RW10.3
RW10.4 RW210
RRD-SPACE-CODE-1
Element: Space Code 1
Derived
This field is used for drill around. It displays the Space Code field values.
RRD-SIGN-CODE
Element: Sign Code
Alpha 1
This field determines if the system prints a negative sign next to a positive amount. Use this option if you do not want revenue and liability balances to print with a negative sign. Reversing the sign only affects report printing, not account totaling. If you leave this field blank, No defaults and the system prints a negative sign for a negative amount.
Y = Yes
N = No
" "
RW10.2 RW10.3
RW10.4 RW210
RRD-SIGN-CODE-1
Element: Sign Code 1
Derived
This field is used for drill around. It displays the Sign Code field values.
RRD-OVD-ACCTUNIT
Accounting Unit
Override
Alpha 15 Occurs 4 Times
This field lets you override the default accounting unit. Enter the accounting unit to use as the override.
RW10.3 RW10.4
RW11.4 RW210
RRD-ACCT-UNIT-1
Element: Accounting Unit 1
Derived
This derived field contains the value of the first Accounting Unit field.
RRD-ACCT-UNIT-2
Element: Accounting Unit 2
Derived
This derived field contains the value of the second Accounting Unit field.
RRD-ACCT-UNIT-3
Element: Accounting Unit 3
Derived
This derived field contains the value of the third Accounting Unit field.
RRD-ACCT-UNIT-4
Element: Accounting Unit 4
Derived
This derived field contains the value of the fourth Accounting Unit field.
RRD-LEVEL-GROUP
Element: Level Group
Alpha 12
You can type or select a level group to include in the row line. A level group is a group of level ranges. If you select a level group, leave the Company and Level Range fields blank.
RW10.3 RW10.4
RW11.4 RW210
RW60.1
RRD-ACCT-GROUP
Element: Account Group
Alpha 12
You can type or select an account group to include in the row line. An account group is a group of account ranges. If you select an account group, leave the Major Account fields blank.
RW10.2 RW10.4
RW11.4 RW210
RW60.1
RRD-SUB-ACCT-GRP
Element: Subaccount Group
Alpha 12
You can type or select a subaccount group. A subaccount group is a group of subaccount ranges. If you select a subaccount group, leave the Subaccount fields blank.
RW10.2 RW10.4
RW11.4 RW210
RW60.1
RRD-PRT-LINE-OPT
Element: Print Line Option
Alpha 1
This field determines if account and level row information prints on the report. If you select No, only the row line totals print. If you leave this field blank, Yes defaults and the line information prints. You can select Unconditional Underline only for an underline or separator row that specifies the row is printed unconditionally.
Y = Yes
N = No
U = Unconditional Underline/Sep
RW10.2 RW10.3
RW10.4 RW210
RRD-AFF-TOT-OPT
Element: Affects Total Option
Alpha 1
This field lets you add the row line to the total, subtract the row line from the total, or define the row line as having no effect on the total.
A = Add to total
S = Subtract from total
N = Don't affect total
" "
RW10.2 RW10.3
RW10.4 RW210
RRD-FORMAT-OVD
Element: Format Override
Numeric 1
This field lets you assign an additional format to calculate the row line differently than other row lines. Type or select a format defined in the Formats form tab in RW00.1 (Report Writer).
1 = Format 1
2 = Format 2
3 = Format 3
4 = Format 4
5 = Format 5
6 = Format 6
7 = Format 7
8 = Format 8
RW10.2 RW10.3
RW10.4 RW210
RRD-FORMAT-OVD-1
Element: Format Override 1
Derived
This field is used for drill around. It displays the Format Override field values.
RRD-TWO-LINE-HEAD
Element: Two-Line Head
Alpha 1

Y = Yes
N = No
RW10.2 RW10.3
RW10.4 RW210
RRD-DETAIL-GROUP
Element: Detail Group
Alpha 1
You can type a number to group row lines into a detail group. For example, if you type 1 in this field for row lines 10 through 50, they become detail group 1.
" "
0
9
A
Z
RW10.2 RW10.3
RW10.4 RW210
RRD-BAL-TYPE
Element: Balance Type
Alpha 1
This field lets you include the net balance, only the debit balance, or only the credit balance on the row file. The default is Net Balance. For example, if you are using a sales account and only want to view the debit balance, select Debit Only.
" " = Net Balance
D = Debit Only
C = Credit Only
E = Net Debit
R = Net Credit
RW10.2 RW10.3
RW10.4 RW210
RRD-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.
RW10.2 RW10.4
RW210
RRD-SUMRY-ACCT-ID
Element: Summary Account ID
Numeric 6
This is the identifier for the summary account.
RW10.2 RW10.4
RW210
RRD-MATRIX-LIST
Element: Matrix List
Alpha 12
You can type or select an accounting unit list to include in the row line. An accounting unit list is a group of accounting units. If you select an accounting unit list, leave the Company and Accounting Unit fields blank.
RW10.3 RW10.4
RW210
RRD-ACCOUNT-LIST
Element: Account List
Alpha 12
RW10.2 RW10.4
RW210


RWROWDET FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RRDSET1 RECORD-TYPE
HEAD-NAME
LINE-NBR
...
AC121 AC123
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
ATVW.1 AD191
AM180 CA10.5
CA110 FB100
FB101 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1


RWROWDET FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Account Group RWHEADER Required
When RRD-ACCT-GROUP !=Spaces
"G"->RWH-HEAD-TYPE
RRD-ACCT-GROUP->RWH-HEAD-NAME
"A"->RWH-RECORD-TYPE
Glchart GLCHART Not Required
RRD-CHART-NAME->GCH-CHART-NAME
Glchartsum GLCHARTSUM Not Required
RRD-CHART-NAME->GCS-CHART-NAME
RRD-SUMRY-ACCT-ID->GCS-SUMRY-ACCT-ID
Level Group RWHEADER Required
When RRD-LEVEL-GROUP !=Spaces
"G"->RWH-HEAD-TYPE
RRD-LEVEL-GROUP->RWH-HEAD-NAME
"L"->RWH-RECORD-TYPE
Mxlisthdr MXLISTHDR Not Required
"ACCTU"->MLH-OBJ-TYPE
RRD-MATRIX-LIST->MLH-MATRIX-LIST
Row Header RWHEADER Required
"R"->RWH-HEAD-TYPE
RRD-HEAD-NAME->RWH-HEAD-NAME
RRD-RECORD-TYPE->RWH-RECORD-TYPE
Subacct Group RWHEADER Required
When RRD-SUB-ACCT-GRP !=Spaces
"G"->RWH-HEAD-TYPE
RRD-SUB-ACCT-GRP->RWH-HEAD-NAME
"S"->RWH-RECORD-TYPE


RWROWDET FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acct Grp Det RWGRPDET
"A"->RGD-RECORD-TYPE
RRD-ACCT-GROUP->RGD-HEAD-NAME
  RGD-RANGE-NUMBER
Lvl Grp Det RWGRPDET
"L"->RGD-RECORD-TYPE
RRD-LEVEL-GROUP->RGD-HEAD-NAME
  RGD-RANGE-NUMBER
Sub Grp Det RWGRPDET
"S"->RGD-RECORD-TYPE
RRD-SUB-ACCT-GRP->RGD-HEAD-NAME
  RGD-RANGE-NUMBER


File created: Thu Jun 09 11:13:35 2016

Home
Contact Us



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