RWROWDET – RW Row File Detail

System
General Ledger (GL)
Prefix
RRD
Primary key
RECORD-TYPE, HEAD-NAME, LINE-NBR
Fields
41
Updated by
12 programs
Referenced by
159 programs

RWROWDET is the RW Row File Detail table in Lawson General Ledger (prefix RRD). It is indexed by RECORD-TYPE, HEAD-NAME, LINE-NBR (RRDSET1). It is related 1:1 to RWHEADER, GLCHART, GLCHARTSUM and MXLISTHDR and 1:M to RWGRPDET and RWROWDTAU. It is updated by RW10.2, RW10.3, RW10.4, RW10.8, RW11.1, RW11.2, RW11.3, RW11.4 and 4 more and referenced by AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 and 151 more. The table has 41 fields, 1 index and 11 documented relations.

About RWROWDET

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.

Fields (41)

Column = COBOL field name without the RRD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
RRD-RECORD-TYPE PK
RECORD_TYPE		Alpha 1This 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 PK
HEAD_NAME		Alpha 12This is the name of a Level, Group, Row, or Total Range.RW10.2, RW10.3, RW10.4, RW10.8, RW100, RW11.4, RW210, RW298 +2 more
RRD-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.RW10.2, RW10.3, RW10.4, RW11.4, RW210, RW298, RW60.1
RRD-FR-COMPANY
FR_COMPANY		Numeric 4You 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
FR_VAR_LEVELS		Alpha 30You 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
FR_ACCOUNT		Numeric 6This 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
FR_SUB_ACCT		Numeric 4This 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
TH_COMPANY		Numeric 4You 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
TH_VAR_LEVELS		Alpha 30You 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
TH_ACCOUNT		Numeric 6This 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
TH_SUB_ACCT		Numeric 4This 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
ACCOUNT_DESC		Alpha 60 (Lower Case)The account description.RW10.2, RW10.3, RW10.4, RW210
RRD-LINE-TYPE
LINE_TYPE		Alpha 1This 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
LINE_TYPE_1		DerivedThis field is used for drill around. It displays the Line Type field values.—
RRD-DETAIL
DETAIL		Alpha 1This 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
DETAIL_1		DerivedThis field is used for drill around. It displays the Detail field values.—
RRD-TOTAL-CODE
TOTAL_CODE		Numeric 1Required if the line type is Total. This field indicates the level (1-9) to use for the total for this row. 0
  • 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
RW10.2, RW10.3, RW10.4, RW210
RRD-TOTAL-CODE-1
TOTAL_CODE_1		DerivedThis field is used for drill around. It displays the Total Code field values.—
RRD-SPACE-CODE
SPACE_CODE		Numeric 1Indicates the number of spaces you want to advance after the account appears on a report. 0
  • 1 No blank lines
  • 2 One blank line
  • 3 Two blank lines
  • 9 Page break
RW10.2, RW10.3, RW10.4, RW210
RRD-SPACE-CODE-1
SPACE_CODE_1		DerivedThis field is used for drill around. It displays the Space Code field values.—
RRD-SIGN-CODE
SIGN_CODE		Alpha 1This 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
SIGN_CODE_1		DerivedThis field is used for drill around. It displays the Sign Code field values.—
RRD-OVD-ACCTUNIT
OVD_ACCTUNIT		Alpha 15 Occurs 4 Times ×4This 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
ACCT_UNIT_1		DerivedThis derived field contains the value of the first Accounting Unit field.—
RRD-ACCT-UNIT-2
ACCT_UNIT_2		DerivedThis derived field contains the value of the second Accounting Unit field.—
RRD-ACCT-UNIT-3
ACCT_UNIT_3		DerivedThis derived field contains the value of the third Accounting Unit field.—
RRD-ACCT-UNIT-4
ACCT_UNIT_4		DerivedThis derived field contains the value of the fourth Accounting Unit field.—
RRD-LEVEL-GROUP
LEVEL_GROUP		Alpha 12You 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
ACCT_GROUP		Alpha 12You 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
SUB_ACCT_GRP		Alpha 12You 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
PRT_LINE_OPT		Alpha 1This 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
AFF_TOT_OPT		Alpha 1This 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
FORMAT_OVD		Numeric 1This 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
FORMAT_OVD_1		DerivedThis field is used for drill around. It displays the Format Override field values.—
RRD-TWO-LINE-HEAD
TWO_LINE_HEAD		Alpha 1—
  • Y Yes
  • N No
RW10.2, RW10.3, RW10.4, RW210
RRD-DETAIL-GROUP
DETAIL_GROUP		Alpha 1You 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 ZRW10.2, RW10.3, RW10.4, RW210
RRD-BAL-TYPE
BAL_TYPE		Alpha 1This 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
CHART_NAME		Alpha 12This 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
SUMRY_ACCT_ID		Numeric 6This is the identifier for the summary account.RW10.2, RW10.4, RW210
RRD-MATRIX-LIST
MATRIX_LIST		Alpha 12You 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
ACCOUNT_LIST		Alpha 12—RW10.2, RW10.4, RW210

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RRDSET1RECORD-TYPE, HEAD-NAME, LINE-NBRPrimaryAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)

Relations

One to one (7) — lookups and parents

RelationTableRulesConditionField map
Account GroupRWHEADERRequiredWhen RRD-ACCT-GROUP != Spaces"G" → RWH-HEAD-TYPE, RRD-ACCT-GROUP → RWH-HEAD-NAME, "A" → RWH-RECORD-TYPE
GlchartGLCHARTNot RequiredRRD-CHART-NAME → GCH-CHART-NAME
GlchartsumGLCHARTSUMNot RequiredRRD-CHART-NAME → GCS-CHART-NAME, RRD-SUMRY-ACCT-ID → GCS-SUMRY-ACCT-ID
Level GroupRWHEADERRequiredWhen RRD-LEVEL-GROUP != Spaces"G" → RWH-HEAD-TYPE, RRD-LEVEL-GROUP → RWH-HEAD-NAME, "L" → RWH-RECORD-TYPE
MxlisthdrMXLISTHDRNot Required"ACCTU" → MLH-OBJ-TYPE, RRD-MATRIX-LIST → MLH-MATRIX-LIST
Row HeaderRWHEADERRequired"R" → RWH-HEAD-TYPE, RRD-HEAD-NAME → RWH-HEAD-NAME, RRD-RECORD-TYPE → RWH-RECORD-TYPE
Subacct GroupRWHEADERRequiredWhen RRD-SUB-ACCT-GRP != Spaces"G" → RWH-HEAD-TYPE, RRD-SUB-ACCT-GRP → RWH-HEAD-NAME, "S" → RWH-RECORD-TYPE

One to many (4) — child tables

RelationTableRulesConditionField map
Acct Grp DetRWGRPDET"A" → RGD-RECORD-TYPE, RRD-ACCT-GROUP → RGD-HEAD-NAME, → RGD-RANGE-NUMBER
Lvl Grp DetRWGRPDET"L" → RGD-RECORD-TYPE, RRD-LEVEL-GROUP → RGD-HEAD-NAME, → RGD-RANGE-NUMBER
RwrowdtauRWROWDTAURRD-RECORD-TYPE → RDA-HEAD-NAME, RRD-HEAD-NAME → RDA-RECORD-TYPE, RRD-LINE-NBR → RDA-LINE-NBR, → RDA-ACTION, → RDA-DATE, → RDA-TIME, → RDA-UNIQUE-I-D
Sub Grp DetRWGRPDET"S" → RGD-RECORD-TYPE, RRD-SUB-ACCT-GRP → RGD-HEAD-NAME, → RGD-RANGE-NUMBER

Programs

Updated by (12)

Referenced by (159)