RWREQUEST

Report Writer Request

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

REFERENCED BY
RW200 RW298 RW299 RW80.1 RW02.1 RW02.2
RW01.1 RW01.2 RW201 RW11.1 RW11.2 RW11.3


UPDATED BY
RW00.1 RW00.6 RW100

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RWR-REQUEST-NAME
Element: Request Name
Alpha 12
This is the report request name.
RW00.1 RW00.6
RW298
RWR-FREQUENCY
Element: Frequency
Alpha 1
This 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
Element: Active Status
Alpha 1
This field indicates whether the report request is active or inactive.
A = Active
I = Inactive
RW00.1 RW100
RWR-PROCESS-GROUP
Element: Process Group
Alpha 15
This field identifies the process group name as defined in RW02.1 (Process Group).
RW00.1
RWR-FORMAT
Element: Format
Alpha 12 Occurs 8 Times
This is the format name as defined in RW20.1 (Format).
RW00.1
RWR-FORMAT-1
Element: Format 1
Derived
This derived field contains the value of the Format field.
RWR-TOTAL-OPT
Element: Total Option
Alpha 1
This 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
Element: Row File Name
Alpha 12
This is the name of the row as defined in RW10 (Rows).
RW00.1
RWR-ROW-TYPE
Element: Row Type
Alpha 1
This 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
Element: Last Print
Numeric 8 (yyyymmdd)
This field indicates the last date this report request was processed by RW100 (Report Generation).
RW100
RWR-SAVE-REPORT
Element: All Flag
Alpha 1
This field indicates whether you want to save this report.
Y = Yes
N = No
RW00.1
RWR-ACCT-PERIOD
Element: Acct Period
Numeric 2
This field indicates the accounting period for this report.
01
02
03
04
05
06
07
08
09
10
11
12
13
RW00.1
RWR-YEAR-CODE
Element: Year Code
Alpha 1
This 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
Element: Print Blanks
Alpha 1
This 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
Element: Print Banner
Alpha 1
This field indicates whether to print a banner for this report.
Y = Yes
N = No
RW00.1
RWR-FOLDER-NAME
Element: Folder Name
Alpha 12
This is the folder name as defined in RW01.1 (Folder).
RW00.1 RW00.6
RWR-ACCT-UNIT
Element: Accounting Unit
Alpha 15 Occurs 4 Times
This field defines a Lawson General Ledger accounting unit.
RW00.1 RW100
RWR-ACCT-UNIT-1
Element: Accounting Unit 1
Derived
This derived field contains the value of the first Accounting Unit field.
RWR-ACCT-UNIT-2
Element: Accounting Unit 2
Derived
This derived field contains the value of the second Accounting Unit field.
RWR-ACCT-UNIT-3
Element: Accounting Unit 3
Derived
This derived field contains the value of the third Accounting Unit field.
RWR-ACCT-UNIT-4
Element: Accounting Unit 4
Derived
This derived field contains the value of the fourth Accounting Unit field.
RWR-FR-COMPANY
Element: Company
Numeric 4
This is the beginning company number for a range of companies.
RW00.1 RW100
RWR-FR-VAR-LEVELS
Element: From Variable Level
Alpha 30
This is the beginning variable level for a range of variable levels.
RW00.1 RW100
RWR-TH-COMPANY
Element: Through Company
Numeric 4
This is the ending company number for a range of companies.
RW00.1 RW100
RWR-TH-VAR-LEVELS
Through Variable
Level
Alpha 30
This is the ending variable level for a range of variable levels.
RW00.1 RW100
RWR-FR-ACCOUNT
Element: Account
Numeric 6
This is the beginning account number for a range of accounts.
RW00.1
RWR-TH-ACCOUNT
Element: Through Account
Numeric 6
This is the ending account number for a range of accounts.
RW00.1
RWR-FR-SUB-ACCT
Element: From Subaccount
Numeric 4
This is the beginning subaccount for a range of subaccounts.
RW00.1
RWR-TH-SUB-ACCT
Element: Through Subaccount
Numeric 4
This is the ending subaccount for a range of subaccounts.
RW00.1
RWR-LEVEL-GROUP
Element: Level Group
Alpha 12
This identifies the level group as defined in RW40.1 (Level Group).
RW00.1 RW100
RWR-ACCOUNT-GROUP
Element: Account Group
Alpha 12
This identifies the account group as defined in RW40.3 (Account Group).
RW00.1
RWR-SUB-ACCT-GRP
Element: Subaccount Group
Alpha 12
This identifies the subaccount group as defined in RW40.4 (Subaccount Group).
RW00.1
RWR-INDIV-RPTS
Element: Individual Reports
Alpha 1 Occurs 6 Times
This field indicates whether individual reports are to be produced.
" " = No Individual Reports
X = Individual Reports
RW00.1 RW100
RWR-RPT-DESC
Element: Report Description
Alpha 50 (Lower Case)
Occurs 3 Times
This is the description of the report.
RW00.1
RWR-RPT-DESC-1
Element: Report Description 1
Derived
This derived field contains the value of the first Report Description field.
RWR-RPT-DESC-2
Element: Report Description 2
Derived
This derived field contains the value of the second Report Description field.
RWR-RPT-DESC-3
Element: Report Description 3
Derived
This derived field contains the value of the third Report Description field.
RWR-NBR-COPIES
Element: Number of Copies
Numeric 2
This field indicates the number of copies that print.
RW00.1
RWR-COMPLETE-FLAG
Element: Complete Flag
Alpha 1
This 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
Element: Size
Numeric 2
This field determines the number of lines that print on each page.
RW00.1
RWR-DESCRIPTION
Element: Form Description
Alpha 30 (Lower Case)
This is the description of the report.
RW00.1 RW00.6
RWR-DISTRIB-GROUP
Element: Distribution Group
Alpha 10
This field defines a distribution group that specifies who is to receive the report.
RW00.1
RWR-PRINTER
Element: Printer
Alpha 10
This field identifies the printer to use in printing the report request.
RW00.1
RWR-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.
RW00.1
RWR-CHART-SECTION
Element: Chart Section
Alpha 1
This 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
Element: Depth
Numeric 2
This field indicates the number of levels to include in a chart-driven report.
00
09
RW00.1
RWR-DETAIL
Element: Detail
Alpha 1
This 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
Element: All Flag
Alpha 1
When 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
Element: Level Depth
Alpha 1
In 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
Element: Style
Alpha 1
This is the row style to use in this report: account rows, level rows, both rows, or undefined.
1 = Account Rows
2 = Level Rows
3 = Both Rows
" " = Not Defined
RW00.1
RWR-STYLE-1
Element: Style 1
Derived
This field is used for drill around. It displays the Style field values.
RWR-MATRIX-VIEW
Element: Matrix View
Alpha 12
A matrix view is a display and roll-up of an attribute list.
RW00.1
RWR-OBJ-ID
Element: Object Identifier
Numeric 12
This is the identifier for the accounting unit view summary level object.
RW00.1
RWR-SUMRY-ACCT-ID
Element: Summary Account ID
Numeric 6
This field identifies the summary account.
RW00.1
RWR-MATRIX-LIST
Element: Matrix List
Alpha 12
Matrix 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
Element: Company Group
Alpha 12
A 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
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
RW00.1
RWR-ACCOUNT-LIST
Element: Account List
Alpha 12
This identifies the Account list as defined in MX10 (List) for object type ACCNT.
RW00.1
RWR-ACCOUNT-VIEW
Element: Account View
Alpha 12
RWR-STYLESHEET
Element: Stylesheet
Alpha 12
RW00.1
RWR-LEDGER
Element: Ledger
Alpha 15
The 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


RWREQUEST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RWRSET1 REQUEST-NAME
RW00.1 RW00.6
RW100 RW200
RW298 RW299
RW80.1
RWRSET2 PROCESS-GROUP
REQUEST-NAME
KeyChange
RW02.1 RW02.2
RW100 RW200
RWRSET3 FOLDER-NAME
REQUEST-NAME
KeyChange
RW01.1 RW01.2
RW100 RW200
RW201
RWRSET4 ROW-FILE-NAME
REQUEST-NAME
KeyChange
RW11.1 RW11.2
RW11.3
RWRSET5 CHART-NAME
REQUEST-NAME
KeyChange


RWREQUEST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Account Group RWHEADER Required
When RWR-ACCOUNT-GROUP !=Spaces
"G"->RWH-HEAD-TYPE
RWR-ACCOUNT-GROUP->RWH-HEAD-NAME
"A"->RWH-RECORD-TYPE
Folder GLCODES Required
"F"->GCD-RECORD-TYPE
RWR-FOLDER-NAME->GCD-FOLDER-NAME
Spaces->GCD-PROCESS-GROUP
Spaces->GCD-SYSTEM
Zeroes->GCD-COMPANY
Format RWFORMAT Not Required
RWR-FORMAT->RWF-FORMAT
"1"->RWF-RECORD-TYPE
1->RWF-LINE-NBR
Glchart GLCHART Not Required
RWR-CHART-NAME->GCH-CHART-NAME
Glchartsum GLCHARTSUM Not Required
RWR-CHART-NAME->GCS-CHART-NAME
RWR-SUMRY-ACCT-ID->GCS-SUMRY-ACCT-ID
Glcpygrp GLCPYGRP Not Required
RWR-COMPANY-GROUP->GCG-COMPANY-GROUP
Level Group RWHEADER Required
When RWR-LEVEL-GROUP !=Spaces
"G"->RWH-HEAD-TYPE
RWR-LEVEL-GROUP->RWH-HEAD-NAME
"L"->RWH-RECORD-TYPE
Mxlisthdr MXLISTHDR Not Required
"ACCTU"->MLH-OBJ-TYPE
RWR-MATRIX-LIST->MLH-MATRIX-LIST
Mxviewdtl MXVIEWDTL Not Required
"ACCTU"->MVD-OBJ-TYPE
RWR-OBJ-ID->MVD-OBJ-ID
Mxviewhdr MXVIEWHDR Not Required
"ACCTU"->MVH-OBJ-TYPE
RWR-MATRIX-VIEW->MVH-MATRIX-VIEW
Process Group GLCODES Required
RWR-PROCESS-GROUP->GCD-PROCESS-GROUP
Row RWHEADER Required
RWR-ROW-FILE-NAME->RWH-HEAD-NAME
"R"->RWH-HEAD-TYPE
RWR-ROW-TYPE->RWH-RECORD-TYPE
Subacct Group RWHEADER Required
When RWR-SUB-ACCT-GRP !=Spaces
"G"->RWH-HEAD-TYPE
RWR-SUB-ACCT-GRP->RWH-HEAD-NAME
"S"->RWH-RECORD-TYPE


RWREQUEST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acct Grp Det RWGRPDET
"A"->RGD-RECORD-TYPE
RWR-ACCOUNT-GROUP->RGD-HEAD-NAME
  RGD-RANGE-NUMBER
Glcgcpy GLCGCPY
RWR-COMPANY-GROUP->GCC-COMPANY-GROUP
  GCC-COMPANY
Lvl Grp Det RWGRPDET
"L"->RGD-RECORD-TYPE
RWR-LEVEL-GROUP->RGD-HEAD-NAME
  RGD-RANGE-NUMBER
Sub Grp Det RWGRPDET
"S"->RGD-RECORD-TYPE
RWR-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.