RWREQUEST – Report Writer Request

System
General Ledger (GL)
Prefix
RWR
Primary key
REQUEST-NAME
Fields
61
Updated by
3 programs
Referenced by
49 programs

RWREQUEST is the Report Writer Request table in Lawson General Ledger (prefix RWR). It is indexed by REQUEST-NAME (RWRSET1); alternate indexes: RWRSET2, RWRSET3, RWRSET4 and RWRSET5. It is related 1:1 to RWHEADER, GLCODES, RWFORMAT, GLCHART, GLCHARTSUM, GLCPYGRP, MXLISTHDR, MXVIEWDTL and 1 more and 1:M to RWGRPDET, GLCGCPY and RWREQSTAU. It is updated by RW00.1, RW00.6 and RW100 and referenced by FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 and 41 more. The table has 61 fields, 5 indexes and 18 documented relations.

About RWREQUEST

This file holds the final parameters that make up a report. The request name is the same as the report name.

Fields (61)

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

Field / columnTypeDescription & valuesUpdated by
RWR-REQUEST-NAME PK
REQUEST_NAME		Alpha 12This is the report request name.RW00.1, RW00.6, RW298
RWR-FREQUENCY
FREQUENCY		Alpha 1This field identifies how frequently the report request is processed.
  • O One Time
  • P Period
  • W Weekly
  • Q Quarterly
  • A Annual
RW00.1
RWR-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1This field indicates whether the report request is active or inactive.
  • A Active
  • I Inactive
RW00.1, RW100
RWR-PROCESS-GROUP
PROCESS_GROUP		Alpha 15This field identifies the process group name as defined in RW02.1 (Process Group).RW00.1
RWR-FORMAT
FORMAT		Alpha 12 Occurs 8 Times ×8This is the format name as defined in RW20.1 (Format).RW00.1
RWR-FORMAT-1
FORMAT_1		DerivedThis derived field contains the value of the Format field.—
RWR-TOTAL-OPT
TOTAL_OPT		Alpha 1This field determines whether totals are maintained by format. Use Yes to maintain totals by format.
  • Y Yes
  • N No
RW00.1
RWR-ROW-FILE-NAME
ROW_FILE_NAME		Alpha 12This is the name of the row as defined in RW10 (Rows).RW00.1
RWR-ROW-TYPE
ROW_TYPE		Alpha 1This field defines the type of row this is: accounts only, levels only, or both accounts and levels.
  • A Accounts Type
  • L Levels Type
  • B Both Type
RW00.1
RWR-LAST-PRINT
LAST_PRINT		Numeric 8 (yyyymmdd)This field indicates the last date this report request was processed by RW100 (Report Generation).RW100
RWR-SAVE-REPORT
SAVE_REPORT		Alpha 1This field indicates whether you want to save this report.
  • Y Yes
  • N No
RW00.1
RWR-ACCT-PERIOD
ACCT_PERIOD		Numeric 2This field indicates the accounting period for this report. 01 02 03 04 05 06 07 08 09 10 11 12 13RW00.1
RWR-YEAR-CODE
YEAR_CODE		Alpha 1This field contains the year code for this report, indicating current, next, or last year.
  • C Current Year
  • L Last Year
  • N Next Year
RW00.1
RWR-PRINT-BLANKS
PRINT_BLANKS		Alpha 1This field indicates whether to print blank lines (when all amounts in the lines are equal to zero). Use Yes to print the line even if all amounts are zero. Use No not to print the lines when all amounts are zero.
  • Y Yes
  • N No
RW00.1
RWR-PRT-BANNER
PRT_BANNER		Alpha 1This field indicates whether to print a banner for this report.
  • Y Yes
  • N No
RW00.1
RWR-FOLDER-NAME
FOLDER_NAME		Alpha 12This is the folder name as defined in RW01.1 (Folder).RW00.1, RW00.6
RWR-ACCT-UNIT
ACCT_UNIT		Alpha 15 Occurs 4 Times ×4This field defines a Lawson General Ledger accounting unit.RW00.1, RW100
RWR-ACCT-UNIT-1
ACCT_UNIT_1		DerivedThis derived field contains the value of the first Accounting Unit field.—
RWR-ACCT-UNIT-2
ACCT_UNIT_2		DerivedThis derived field contains the value of the second Accounting Unit field.—
RWR-ACCT-UNIT-3
ACCT_UNIT_3		DerivedThis derived field contains the value of the third Accounting Unit field.—
RWR-ACCT-UNIT-4
ACCT_UNIT_4		DerivedThis derived field contains the value of the fourth Accounting Unit field.—
RWR-FR-COMPANY
FR_COMPANY		Numeric 4This is the beginning company number for a range of companies.RW00.1, RW100
RWR-FR-VAR-LEVELS
FR_VAR_LEVELS		Alpha 30This is the beginning variable level for a range of variable levels.RW00.1, RW100
RWR-TH-COMPANY
TH_COMPANY		Numeric 4This is the ending company number for a range of companies.RW00.1, RW100
RWR-TH-VAR-LEVELS
TH_VAR_LEVELS		Alpha 30This is the ending variable level for a range of variable levels.RW00.1, RW100
RWR-FR-ACCOUNT
FR_ACCOUNT		Numeric 6This is the beginning account number for a range of accounts.RW00.1
RWR-TH-ACCOUNT
TH_ACCOUNT		Numeric 6This is the ending account number for a range of accounts.RW00.1
RWR-FR-SUB-ACCT
FR_SUB_ACCT		Numeric 4This is the beginning subaccount for a range of subaccounts.RW00.1
RWR-TH-SUB-ACCT
TH_SUB_ACCT		Numeric 4This is the ending subaccount for a range of subaccounts.RW00.1
RWR-LEVEL-GROUP
LEVEL_GROUP		Alpha 12This identifies the level group as defined in RW40.1 (Level Group).RW00.1, RW100
RWR-ACCOUNT-GROUP
ACCOUNT_GROUP		Alpha 12This identifies the account group as defined in RW40.3 (Account Group).RW00.1
RWR-SUB-ACCT-GRP
SUB_ACCT_GRP		Alpha 12This identifies the subaccount group as defined in RW40.4 (Subaccount Group).RW00.1
RWR-INDIV-RPTS
INDIV_RPTS		Alpha 1 Occurs 6 Times ×6This field indicates whether individual reports are to be produced. " " = No Individual Reports
  • X Individual Reports
RW00.1, RW100
RWR-RPT-DESC
RPT_DESC		Alpha 50 (Lower Case)Occurs 3 Times This is the description of the report.RW00.1
RWR-RPT-DESC-1
RPT_DESC_1		DerivedThis derived field contains the value of the first Report Description field.—
RWR-RPT-DESC-2
RPT_DESC_2		DerivedThis derived field contains the value of the second Report Description field.—
RWR-RPT-DESC-3
RPT_DESC_3		DerivedThis derived field contains the value of the third Report Description field.—
RWR-NBR-COPIES
NBR_COPIES		Numeric 2This field indicates the number of copies that print.RW00.1
RWR-COMPLETE-FLAG
COMPLETE_FLAG		Alpha 1This field indicates if the report record is complete (i.e., has the required level or account definition). A report with an account type row (A) needs a level definition. A report with a level type row (L) needs an account definition.
  • N Incompl State
  • Y Complete State
RW00.1
RWR-FORM-LENGTH
FORM_LENGTH		Numeric 2This field determines the number of lines that print on each page.RW00.1
RWR-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the description of the report.RW00.1, RW00.6
RWR-DISTRIB-GROUP
DISTRIB_GROUP		Alpha 10This field defines a distribution group that specifies who is to receive the report.RW00.1
RWR-PRINTER
PRINTER		Alpha 10This field identifies the printer to use in printing the report request.RW00.1
RWR-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.RW00.1
RWR-CHART-SECTION
CHART_SECTION		Alpha 1This is the section of the chart requested for this report: balance sheet, income statement, or all sections. " " = All
  • 1 Balance Sheet
  • 2 Income Statement
RW00.1
RWR-DEPTH
DEPTH		Numeric 2This field indicates the number of levels to include in a chart-driven report. 00 09RW00.1
RWR-DETAIL
DETAIL		Alpha 1This field defines the kind of detail to include in a chart-driven report: account, subaccount, or none.
  • N None
  • A Account
  • S Subacct
RW00.1
RWR-INDENT
INDENT		Alpha 1When you use the chart name as the row file, this field determines if the description is indented, based on the depth of the summary account.
  • Y Yes
  • N No
RW00.1
RWR-DEPTH-LEVEL
DEPTH_LEVEL		Alpha 1In a chart-driven report, this field determines the level detail printed for each account.
  • N None
  • 0 Company
  • 1 Level 1
  • 2 Level 2
  • 3 Level 3
  • 4 Level 4
  • 5 Level 5
RW00.1
RWR-STYLE
STYLE		Alpha 1This is the row style to use in this report: account rows, level rows, both rows, or undefined. " " = Not Defined
  • 1 Account Rows
  • 2 Level Rows
  • 3 Both Rows
RW00.1
RWR-STYLE-1
STYLE_1		DerivedThis field is used for drill around. It displays the Style field values.—
RWR-MATRIX-VIEW
MATRIX_VIEW		Alpha 12A matrix view is a display and roll-up of an attribute list.RW00.1
RWR-OBJ-ID
OBJ_ID		Numeric 12This is the identifier for the accounting unit view summary level object.RW00.1
RWR-SUMRY-ACCT-ID
SUMRY_ACCT_ID		Numeric 6This field identifies the summary account.RW00.1
RWR-MATRIX-LIST
MATRIX_LIST		Alpha 12Matrix categories are parameters used to build a list of objects (for example, accounting units). Matrix categories and values are the basis of the selection and sorting. You can then use this matrix list for reporting and processing objects.RW00.1, RW100
RWR-COMPANY-GROUP
COMPANY_GROUP		Alpha 12A company group is a list of companies that serves as a definition of company and level range. Each company is processed for all levels defined (a range of 0 through 9).RW00.1, RW100
RWR-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).RW00.1
RWR-ACCOUNT-LIST
ACCOUNT_LIST		Alpha 12This identifies the Account list as defined in MX10 (List) for object type ACCNT.RW00.1
RWR-ACCOUNT-VIEW
ACCOUNT_VIEW		Alpha 12——
RWR-STYLESHEET
STYLESHEET		Alpha 12—RW00.1
RWR-LEDGER
LEDGER		Alpha 15The name that identifies the Multi-Book ledger as defined ML10.1 (Ledger Setup). If this field is populated the report will print the combined amounts for the company and the multi-book ledger related to the company.RW00.1

Indexes (5)

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

IndexKeysFlagsConditionUsed in
RWRSET1REQUEST-NAMEPrimaryFB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 +22 more (list truncated in source)
RWRSET2PROCESS-GROUP, REQUEST-NAMEKeyChangeRW02.1, RW02.2, RW100, RW200
RWRSET3FOLDER-NAME, REQUEST-NAMEKeyChangeRW01.1, RW01.2, RW100, RW200, RW201
RWRSET4ROW-FILE-NAME, REQUEST-NAMEKeyChangeRW11.1, RW11.2, RW11.3
RWRSET5CHART-NAME, REQUEST-NAMEKeyChange—

Relations

One to one (13) — lookups and parents

RelationTableRulesConditionField map
Account GroupRWHEADERRequiredWhen RWR-ACCOUNT-GROUP != Spaces"G" → RWH-HEAD-TYPE, RWR-ACCOUNT-GROUP → RWH-HEAD-NAME, "A" → RWH-RECORD-TYPE
FolderGLCODESRequired"F" → GCD-RECORD-TYPE, RWR-FOLDER-NAME → GCD-FOLDER-NAME, Spaces → GCD-PROCESS-GROUP, Spaces → GCD-SYSTEM, Zeroes → GCD-COMPANY
FormatRWFORMATNot RequiredRWR-FORMAT → RWF-FORMAT, "1" → RWF-RECORD-TYPE, 1 → RWF-LINE-NBR
GlchartGLCHARTNot RequiredRWR-CHART-NAME → GCH-CHART-NAME
GlchartsumGLCHARTSUMNot RequiredRWR-CHART-NAME → GCS-CHART-NAME, RWR-SUMRY-ACCT-ID → GCS-SUMRY-ACCT-ID
GlcpygrpGLCPYGRPNot RequiredRWR-COMPANY-GROUP → GCG-COMPANY-GROUP
Level GroupRWHEADERRequiredWhen RWR-LEVEL-GROUP != Spaces"G" → RWH-HEAD-TYPE, RWR-LEVEL-GROUP → RWH-HEAD-NAME, "L" → RWH-RECORD-TYPE
MxlisthdrMXLISTHDRNot Required"ACCTU" → MLH-OBJ-TYPE, RWR-MATRIX-LIST → MLH-MATRIX-LIST
MxviewdtlMXVIEWDTLNot Required"ACCTU" → MVD-OBJ-TYPE, RWR-OBJ-ID → MVD-OBJ-ID
MxviewhdrMXVIEWHDRNot Required"ACCTU" → MVH-OBJ-TYPE, RWR-MATRIX-VIEW → MVH-MATRIX-VIEW
Process GroupGLCODESRequiredRWR-PROCESS-GROUP → GCD-PROCESS-GROUP
RowRWHEADERRequiredRWR-ROW-FILE-NAME → RWH-HEAD-NAME, "R" → RWH-HEAD-TYPE, RWR-ROW-TYPE → RWH-RECORD-TYPE
Subacct GroupRWHEADERRequiredWhen RWR-SUB-ACCT-GRP != Spaces"G" → RWH-HEAD-TYPE, RWR-SUB-ACCT-GRP → RWH-HEAD-NAME, "S" → RWH-RECORD-TYPE

One to many (5) — child tables

RelationTableRulesConditionField map
Acct Grp DetRWGRPDET"A" → RGD-RECORD-TYPE, RWR-ACCOUNT-GROUP → RGD-HEAD-NAME, → RGD-RANGE-NUMBER
GlcgcpyGLCGCPYRWR-COMPANY-GROUP → GCC-COMPANY-GROUP, → GCC-COMPANY
Lvl Grp DetRWGRPDET"L" → RGD-RECORD-TYPE, RWR-LEVEL-GROUP → RGD-HEAD-NAME, → RGD-RANGE-NUMBER
RwreqstauRWREQSTAURWR-REQUEST-NAME → RRA-REQUEST-NAME, → RRA-ACTION, → RRA-DATE, → RRA-TIME, → RRA-UNIQUE-I-D
Sub Grp DetRWGRPDET"S" → RGD-RECORD-TYPE, RWR-SUB-ACCT-GRP → RGD-HEAD-NAME, → RGD-RANGE-NUMBER

Programs

Updated by (3)

Referenced by (49)