|
RWREQUEST FILE
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 Alpha 12 RW00.1 RW00.6
Element: Name User This is the report request name. RW298
RWR-FREQUENCY Alpha 1 RW00.1
Element: Frequency This field identifies how frequently
the report request is processed.
O = One Time
P = Period
W = Weekly
Q = Quarterly
A = Annual
RWR-ACTIVE-STATUS Alpha 1 RW00.1 RW100
Element: Status This field indicates whether the report
request is active or inactive.
A = Active
I = Inactive
RWR-PROCESS-GROUP Alpha 15 RW00.1
Element: Group This field identifies the process group
name as defined in RW02.1 (Process
Group).
RWR-FORMAT Alpha 12 Occurs 8 Times RW00.1
Element: Format This is the format name as defined in
RW20.1 (Format).
RWR-FORMAT-1 Derived
Element: Format 1 This derived field contains the value
of the Format field.
RWR-TOTAL-OPT Alpha 1 RW00.1
Element: Total Option This field determines whether totals
are maintained by format. Use Yes to
maintain totals by format.
Y = Yes
N = No
RWR-ROW-FILE-NAME Alpha 12 RW00.1
Element: Name User This is the name of the row as defined
in RW10 (Rows).
RWR-ROW-TYPE Alpha 1 RW00.1
Element: Row Type 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
RWR-LAST-PRINT Numeric 8 (yyyymmdd) RW100
Element: Date This field indicates the last date this
report request was processed by RW100
(Report Generation).
RWR-SAVE-REPORT Alpha 1 RW00.1
Element: All Flag This field indicates whether you want
to save this report.
Y = Yes
N = No
RWR-ACCT-PERIOD Numeric 2 RW00.1
Element: Current PeriodThis field indicates the accounting
period for this report.
01
02
03
04
05
06
07
08
09
10
11
12
13
RWR-YEAR-CODE Alpha 1 RW00.1
Element: Year Code This field contains the year code for
this report, indicating current, next,
or last year.
C = Current Year
L = Last Year
N = Next Year
RWR-PRINT-BLANKS Alpha 1 RW00.1
Element: Print Blanks 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
RWR-PRT-BANNER Alpha 1 RW00.1
Element: Print Banner This field indicates whether to print a
banner for this report.
Y = Yes
N = No
RWR-FOLDER-NAME Alpha 12 RW00.1 RW00.6
Element: Name User This is the folder name as defined in
RW01.1 (Folder).
RWR-ACCT-UNIT Alpha 15 Occurs 4 Times RW00.1
Element: Accounting UniThis field defines a Lawson General
Ledger accounting unit.
RWR-ACCT-UNIT-1 Derived
Element: Accounting UniThis derived field contains the value
of the first Accounting Unit field.
RWR-ACCT-UNIT-2 Derived
Element: Accounting UniThis derived field contains the value
of the second Accounting Unit field.
RWR-ACCT-UNIT-3 Derived
Element: Accounting UniThis derived field contains the value
of the third Accounting Unit field.
RWR-ACCT-UNIT-4 Derived
Element: Accounting UniThis derived field contains the value
of the fourth Accounting Unit field.
RWR-FR-COMPANY Numeric 4 RW00.1
Element: Company This is the beginning company number
for a range of companies.
RWR-FR-VAR-LEVELS Alpha 30 RW00.1
Element: From Variable This is the beginning variable level
for a range of variable levels.
RWR-TH-COMPANY Numeric 4 RW00.1
Element: Through CompanThis is the ending company number for a
range of companies.
RWR-TH-VAR-LEVELS Alpha 30 RW00.1
Through Variable This is the ending variable level for a
Level range of variable levels.
RWR-FR-ACCOUNT Numeric 6 RW00.1
Element: Account This is the beginning account number
for a range of accounts.
RWR-TH-ACCOUNT Numeric 6 RW00.1
Element: Through AccounThis is the ending account number for a
range of accounts.
RWR-FR-SUB-ACCT Numeric 4 RW00.1
Element: From SubaccounThis is the beginning subaccount for a
range of subaccounts.
RWR-TH-SUB-ACCT Numeric 4 RW00.1
Element: Through SubaccThis is the ending subaccount for a
range of subaccounts.
RWR-LEVEL-GROUP Alpha 12 RW00.1 RW100
Element: Level Group This identifies the level group as
defined in RW40.1 (Level Group).
RWR-ACCOUNT-GROUP Alpha 12 RW00.1
Element: Account Group This identifies the account group as
defined in RW40.3 (Account Group).
RWR-SUB-ACCT-GRP Alpha 12 RW00.1
Element: Subaccount GroThis identifies the subaccount group as
defined in RW40.4 (Subaccount Group).
RWR-INDIV-RPTS Alpha 1 Occurs 6 Times RW00.1
Element: Individual RepThis field indicates whether individual
reports are to be produced.
" " = No Individual Reports
X = Individual Reports
RWR-RPT-DESC Alpha 50 (Lower Case) RW00.1
Element: Report DescripOccurs 3 Times
This is the description of the report.
RWR-RPT-DESC-1 Derived
Element: Report DescripThis derived field contains the value
of the first Report Description field.
RWR-RPT-DESC-2 Derived
Element: Report DescripThis derived field contains the value
of the second Report Description field.
RWR-RPT-DESC-3 Derived
Element: Report DescripThis derived field contains the value
of the third Report Description field.
RWR-NBR-COPIES Numeric 2 RW00.1
Element: Number of CopiThis field indicates the number of
copies that print.
RWR-COMPLETE-FLAG Alpha 1 RW00.1
Element: Complete Flag 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
RWR-FORM-LENGTH Numeric 2 RW00.1
Element: Size This field determines the number of
lines that print on each page.
RWR-DESCRIPTION Alpha 30 (Lower Case) RW00.1 RW00.6
Element: Form DescriptiThis is the description of the report.
RWR-DISTRIB-GROUP Alpha 10 RW00.1
Element: Distribution GThis field defines a distribution group
that specifies who is to receive the
report.
RWR-PRINTER Alpha 10 RW00.1
Element: Printer This field identifies the printer to
use in printing the report request.
RWR-CHART-NAME Alpha 12 RW00.1
Element: Name User This is the name you assigned to the
chart of accounts when you defined your
company structure in the General Ledger
system.
RWR-CHART-SECTION Alpha 1 RW00.1
Element: Chart Section 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
RWR-DEPTH Numeric 2 RW00.1
Element: Depth This field indicates the number of
levels to include in a chart-driven
report.
00
09
RWR-DETAIL Alpha 1 RW00.1
Element: Detail This field defines the kind of detail
to include in a chart-driven report:
account, subaccount, or none.
N = None
A = Account
S = Subacct
RWR-INDENT Alpha 1 RW00.1
Element: All Flag 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
RWR-DEPTH-LEVEL Alpha 1 RW00.1
Element: Level Depth 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
RWR-STYLE Alpha 1 RW00.1
Element: Style 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
RWR-STYLE-1 Derived
Element: Style 1 This field is used for drill around. It
displays the Style field values.
RWR-MATRIX-VIEW Alpha 12 RW00.1
Element: Attribute ListA matrix view is a display and roll-up
of an attribute list.
RWR-OBJ-ID Numeric 12 RW00.1
Element: Object IdentifThis is the identifier for the
accounting unit view summary level
object.
RWR-SUMRY-ACCT-ID Numeric 6 RW00.1
Element: Summary AccounThis field identifies the summary
account.
RWR-MATRIX-LIST Alpha 12 RW00.1
Element: Matrix List 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.
RWR-COMPANY-GROUP Alpha 12 RW00.1
Element: Company Group 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).
RWR-CURRENCY-CODE Alpha 5 RW00.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
RWR-ACCOUNT-LIST Alpha 12 RW00.1
Element: Account List
RWR-ACCOUNT-VIEW Alpha 12
Element: Account View
RWR-STYLESHEET Alpha 12 RW00.1
Element: Stylesheet
RWR-LEDGER Alpha 15 RW00.1
Element: Ledger The name that identifies the strategic
ledger.
The Ledger information is used to post
Strategic ledger data using SL190
(Strategic Ledger Posting) or used for
reporting in the OLAP environment using
SL87 (Strategic Ledger Data Mart Setup).
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 KeyChange RW02.1 RW02.2
REQUEST-NAME RW100 RW200
RWRSET3 FOLDER-NAME KeyChange RW01.1 RW01.2
REQUEST-NAME RW100 RW200
RW201
RWRSET4 ROW-FILE-NAME KeyChange RW11.1 RW11.2
REQUEST-NAME RW11.3
RWRSET5 CHART-NAME KeyChange
REQUEST-NAME
RWREQUEST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|