|
|
RWROWDET FILE
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
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 FB101 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 GL256 GL298 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 RW00.1
RW100 RW215 RW230 RW260 RW270 RW298
RW299 RW30.1 RW70.1 GL16.4 GLAV.1 GLCV.1
GLVW.1 SLVW.1
UPDATED BY
RW10.2 RW10.3 RW10.4 RW10.8 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 Alpha 1 RW10.2 RW10.3
Element: Record Type This field defines the record type for RW10.4 RW11.4
the row: accounts only, levels only, RW210 RW298
both levels and accounts, or ranges for RW60.1
totals.
A = Accounts
B = Both Levels and Accts
L = Levels
R = Ranges for Totals
RRD-HEAD-NAME Alpha 12 RW10.2 RW10.3
Element: Head Name This is the name of a Level, Group, RW10.4 RW10.8
Row, or Total Range. RW100 RW11.4
RW210 RW298
RW60.1 RW60.3
RRD-LINE-NBR Numeric 6 RW10.2 RW10.3
Element: Line Number This field contains the line number. RW10.4 RW11.4
RW210 RW298
RW60.1
RRD-FR-COMPANY Numeric 4 RW10.3 RW10.4
Element: Company You can create reports for a range of RW11.4 RW210
level groups within a specific company RW60.1
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.
RRD-FR-VAR-LEVELS Alpha 30 RW10.3 RW10.4
Element: From Variable You can select an additional level RW11.4 RW210
range to include in the row line. Type RW60.1
or select the beginning level
number in this field.
RRD-FR-ACCOUNT Numeric 6 RW10.2 RW10.4
Element: Account This field determines any additional RW11.4 RW210
accounts you want to include in the row RW60.1
line. Type or select the beginning
account number in this field.
If you select an account range, leave
the Account Group field blank.
RRD-FR-SUB-ACCT Numeric 4 RW10.2 RW10.4
Element: From SubaccounThis field determines any additional RW11.4 RW210
subaccounts you want to include in the RW60.1
row line. Type or select the beginning
subaccount number in this field.
If you select a subaccount range, leave
the Subaccount Group field blank.
RRD-TH-COMPANY Numeric 4 RW10.3 RW10.4
Element: Through CompanYou can create reports for a range of RW11.4 RW210
level groups within a specific company RW60.1
range. Type or select the ending company
number in this field.
If you leave this field blank, the
beginning company number defaults.
RRD-TH-VAR-LEVELS Alpha 30 RW10.3 RW10.4
Through Variable You can select an additional level RW11.4 RW210
Level range to include in the row line. Type RW60.1
or select the ending level number
in this field. If you leave this field
blank, the beginning level defaults.
RRD-TH-ACCOUNT Numeric 6 RW10.2 RW10.4
Element: Through AccounThis field determines any additional RW11.4 RW210
accounts you want to include in the row RW60.1
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.
RRD-TH-SUB-ACCT Numeric 4 RW10.2 RW10.4
Element: Through SubaccThis field determines any additional RW11.4 RW210
subaccounts you want to include in the RW60.1
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.
RRD-ACCOUNT-DESC Alpha 60 (Lower Case) RW10.2 RW10.3
Element: Account Desc The account description. RW10.4 RW210
RRD-LINE-TYPE Alpha 1 RW10.2 RW10.3
Element: Line Type This field defines the line type for RW10.4 RW100
the row: detail, header, total, base, RW210
underline, or split.
D = Detail
H = Heading
T = Total
B = Base
U = Underline
S = Split
RRD-LINE-TYPE-1 Derived
Element: Line Type 1 This field is used for drill around. It
displays the Line Type field values.
RRD-DETAIL Alpha 1 RW10.2 RW10.3
Element: Detail This field defines the kind of detail RW10.4 RW210
for the row: account detail, subaccount
detail, level detail, or consolidated.
A = Account
S = Subaccount
L = Level
C = Consolidated
" "
RRD-DETAIL-1 Derived
Element: Detail 1 This field is used for drill around. It
displays the Detail field values.
RRD-TOTAL-CODE Numeric 1 RW10.2 RW10.3
Element: Total Code Required if the line type is Total. RW10.4 RW210
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
RRD-TOTAL-CODE-1 Derived
Element: Total Code 1 This field is used for drill around. It
displays the Total Code field values.
RRD-SPACE-CODE Numeric 1 RW10.2 RW10.3
Element: Space Code Indicates the number of spaces you want RW10.4 RW210
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
RRD-SPACE-CODE-1 Derived
Element: Space Code 1 This field is used for drill around. It
displays the Space Code field values.
RRD-SIGN-CODE Alpha 1 RW10.2 RW10.3
Element: Sign Code This field determines if the system RW10.4 RW210
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
" "
RRD-SIGN-CODE-1 Derived
Element: Sign Code 1 This field is used for drill around. It
displays the Sign Code field values.
RRD-OVD-ACCTUNIT Alpha 15 Occurs 4 Times RW10.3 RW10.4
Accounting Unit This field lets you override the RW11.4 RW210
Override default accounting unit. Enter the
accounting unit to use as the override.
RRD-ACCT-UNIT-1 Derived
Element: Accounting UniThis derived field contains the value
of the first Accounting Unit field.
RRD-ACCT-UNIT-2 Derived
Element: Accounting UniThis derived field contains the value
of the second Accounting Unit field.
RRD-ACCT-UNIT-3 Derived
Element: Accounting UniThis derived field contains the value
of the third Accounting Unit field.
RRD-ACCT-UNIT-4 Derived
Element: Accounting UniThis derived field contains the value
of the fourth Accounting Unit field.
RRD-LEVEL-GROUP Alpha 12 RW10.3 RW10.4
Element: Level Group You can type or select a level group to RW11.4 RW210
include in the row line. A level group RW60.1
is a group of level ranges. If you
select a level group, leave the Company
and Level Range fields blank.
RRD-ACCT-GROUP Alpha 12 RW10.2 RW10.4
Element: Account Group You can type or select an account group RW11.4 RW210
to include in the row line. An account RW60.1
group is a group of account ranges. If
you select an account group, leave the
Major Account fields blank.
RRD-SUB-ACCT-GRP Alpha 12 RW10.2 RW10.4
Element: Subaccount GroYou can type or select a subaccount RW11.4 RW210
group. A subaccount group is a group of RW60.1
subaccount ranges. If you select a
subaccount group, leave the Subaccount
fields blank.
RRD-PRT-LINE-OPT Alpha 1 RW10.2 RW10.3
Element: Print Line OptThis field determines if account and RW10.4 RW210
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
RRD-AFF-TOT-OPT Alpha 1 RW10.2 RW10.3
Element: Affects Total This field lets you add the row line to RW10.4 RW210
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
" "
RRD-FORMAT-OVD Numeric 1 RW10.2 RW10.3
Element: Format OverridThis field lets you assign an RW10.4 RW210
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
RRD-FORMAT-OVD-1 Derived
Element: Format OverridThis field is used for drill around. It
displays the Format Override field
values.
RRD-TWO-LINE-HEAD Alpha 1 RW10.2 RW10.3
Element: Two-Line Head This field lets you print only the last RW10.4 RW210
two lines in a format file before each
detail line. This can be used along with
a format override.
Y = Yes
N = No
RRD-DETAIL-GROUP Alpha 1 RW10.2 RW10.3
Element: Detail Group You can type a number to group row RW10.4 RW210
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
RRD-BAL-TYPE Alpha 1 RW10.2 RW10.3
Element: Balance Type This field lets you include the net RW10.4 RW210
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
RRD-CHART-NAME Alpha 12 RW10.2 RW10.4
Element: Chart Name This is the name you assigned to the RW210
chart of accounts when you defined your
company structure in the General Ledger
system.
RRD-SUMRY-ACCT-ID Numeric 6 RW10.2 RW10.4
Element: Summary AccounThis is the identifier for the summary RW210
account.
RRD-MATRIX-LIST Alpha 12 RW10.3 RW10.4
Element: Attribute ListYou can type or select an accounting RW210
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.
RRD-ACCOUNT-LIST Alpha 12 RW10.2 RW10.4
Element: Account List RW210
RWROWDET FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RRDSET1 RECORD-TYPE AC121 AC123
HEAD-NAME AC130 AC20.1
LINE-NBR AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB101 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
...
RWROWDET FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
