|
|
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
GL950 RW00.1 RW00.6 RW100
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RWR-REQUEST-NAME Alpha 12 GL950 RW00.1
Request This is the report request name. RW00.6 RW298
RWR-FREQUENCY Alpha 1 GL950 RW00.1
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 GL950 RW00.1
Active This field indicates whether the report RW100
request is active or inactive.
A = Active
I = Inactive
RWR-PROCESS-GROUP Alpha 15 GL950 RW00.1
Process Group This field identifies the process group
name as defined in RW02.1 (Process
Group).
RWR-FORMAT Alpha 12 Occurs 8 Times GL950 RW00.1
Format This is the format name as defined in
RW20.1 (Format).
RWR-FORMAT-1 Derived
Format This derived field contains the value
of the Format field.
RWR-TOTAL-OPT Alpha 1 GL950 RW00.1
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 GL950 RW00.1
Row This is the name of the row as defined
in RW10 (Rows).
RWR-ROW-TYPE Alpha 1 GL950 RW00.1
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) GL950 RW100
Date Last Printed This field indicates the last date this
report request was processed by RW100
(Report Generation).
RWR-SAVE-REPORT Alpha 1 GL950 RW00.1
Save Report This field indicates whether you want
to save this report.
Y = Yes
N = No
RWR-ACCT-PERIOD Numeric 2 GL950 RW00.1
Period This 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 GL950 RW00.1
Fiscal Year 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 GL950 RW00.1
Print Blank Lines 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 GL950 RW00.1
Print Banner This field indicates whether to print a
banner for this report.
Y = Yes
N = No
RWR-FOLDER-NAME Alpha 12 GL950 RW00.1
Folder This is the folder name as defined in RW00.6
RW01.1 (Folder).
RWR-ACCT-UNIT Alpha 15 Occurs 4 Times GL950 RW00.1
Accounting Unit This field defines a Lawson General
Ledger accounting unit.
RWR-ACCT-UNIT-1 Derived
Accounting Unit 1 This derived field contains the value
of the first Accounting Unit field.
RWR-ACCT-UNIT-2 Derived
Accounting Unit 2 This derived field contains the value
of the second Accounting Unit field.
RWR-ACCT-UNIT-3 Derived
Accounting Unit 3 This derived field contains the value
of the third Accounting Unit field.
RWR-ACCT-UNIT-4 Derived
Accounting Unit 4 This derived field contains the value
of the fourth Accounting Unit field.
RWR-FR-COMPANY Numeric 4 GL950 RW00.1
From Company This is the beginning company number
for a range of companies.
RWR-FR-VAR-LEVELS Alpha 30 GL950 RW00.1
From Variable Level This is the beginning variable level
for a range of variable levels.
RWR-TH-COMPANY Numeric 4 GL950 RW00.1
Through Company This is the ending company number for a
range of companies.
RWR-TH-VAR-LEVELS Alpha 30 GL950 RW00.1
Through Variable This is the ending variable level for a
Level range of variable levels.
RWR-FR-ACCOUNT Numeric 6 GL950 RW00.1
From Account This is the beginning account number
for a range of accounts.
RWR-TH-ACCOUNT Numeric 6 GL950 RW00.1
Through Account This is the ending account number for a
range of accounts.
RWR-FR-SUB-ACCT Numeric 4 GL950 RW00.1
From Subaccount This is the beginning subaccount for a
range of subaccounts.
RWR-TH-SUB-ACCT Numeric 4 GL950 RW00.1
Through Subaccount This is the ending subaccount for a
range of subaccounts.
RWR-LEVEL-GROUP Alpha 12 GL950 RW00.1
Level Group This identifies the level group as RW100
defined in RW40.1 (Level Group).
RWR-ACCOUNT-GROUP Alpha 12 GL950 RW00.1
Account Group This identifies the account group as
defined in RW40.3 (Account Group).
RWR-SUB-ACCT-GRP Alpha 12 GL950 RW00.1
Subaccount Group This identifies the subaccount group as
defined in RW40.4 (Subaccount Group).
RWR-INDIV-RPTS Alpha 1 Occurs 6 Times GL950 RW00.1
Individual Reports This field indicates whether individual
reports are to be produced.
" " = No Individual Reports
X = Individual Reports
RWR-RPT-DESC Alpha 50 (Lower Case) GL950 RW00.1
Report Description Occurs 3 Times
This is the description of the report.
RWR-RPT-DESC-1 Derived
Report Description 1 This derived field contains the value
of the first Report Description field.
RWR-RPT-DESC-2 Derived
Report Description 2 This derived field contains the value
of the second Report Description field.
RWR-RPT-DESC-3 Derived
Report Description 3 This derived field contains the value
of the third Report Description field.
RWR-NBR-COPIES Numeric 2 GL950 RW00.1
Number of Copies This field indicates the number of
copies that print.
RWR-COMPLETE-FLAG Alpha 1 GL950 RW00.1
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 GL950 RW00.1
Form Length This field determines the number of
lines that print on each page.
RWR-DESCRIPTION Alpha 30 (Lower Case) GL950 RW00.1
Form Description This is the description of the report. RW00.6
RWR-DISTRIB-GROUP Alpha 10 GL950 RW00.1
Distribution Group This field defines a distribution group
that specifies who is to receive the
report.
RWR-PRINTER Alpha 10 GL950 RW00.1
Printer This field identifies the printer to
use in printing the report request.
RWR-CHART-NAME Alpha 12 GL950 RW00.1
Chart 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 GL950 RW00.1
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 GL950 RW00.1
Level Depth This field indicates the number of
levels to include in a chart-driven
report.
00
09
RWR-DETAIL Alpha 1 GL950 RW00.1
Level 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 GL950 RW00.1
Indent 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 GL950 RW00.1
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 GL950 RW00.1
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
Style This field is used for drill around. It
displays the Style field values.
RWR-MATRIX-VIEW Alpha 12 GL950 RW00.1
Attribute View A matrix view is a display and roll-up
of an attribute list.
RWR-OBJ-ID Numeric 12 GL950 RW00.1
Object Identifier This is the identifier for the
accounting unit view summary level
object.
RWR-SUMRY-ACCT-ID Numeric 6 GL950 RW00.1
Summary Account ID This field identifies the summary
account.
RWR-MATRIX-LIST Alpha 12 GL950 RW00.1
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 GL950 RW00.1
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
Currency Code This field contains the company base
currency code established in GL10.1
(Company).
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
|