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
ATVW.1	AD191	AM180	CA10.5	CA110	FB01.1
FB01.2	FB100	FB101	FB11.1	FB111	FB141
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	GL292	GL293	GL294
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	RW00.1	RW00.6	RW03.1	RW03.2
RW100	RW20.1	RW20.2	RW20.8	RW215	RW230
RW260	RW270	RW298	RW299	RW30.1	RW40.1
RW40.3	RW40.4	RW40.5	RW40.6	RW40.7	RW40.8
RW50.1	RW70.1	GL16.4	GLAV.1	GLCV.1	GLVW.1
ML292	ML293	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	SNGL.1
SNOA.1	SNRA.1	SNSA.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 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

RWROWDET FILE RELATIONS

ONE TO ONE RELATIONS

RWROWDET FILE RELATIONS

ONE TO MANY RELATIONS

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