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

FB01.1	FB01.2	FB141	GL292	GL293	GL294
GL95.4	GL99.1	RW03.1	RW03.2	RW10.2	RW10.3
RW10.4	RW10.8	RW11.1	RW11.2	RW11.3	RW11.4
RW20.1	RW20.2	RW20.8	RW200	RW210	RW298
RW299	RW30.1	RW40.1	RW40.3	RW40.4	RW40.5
RW40.6	RW40.7	RW40.8	RW50.1	RW60.1	RW60.2
RW60.3	RW70.1	RW80.1	ML292	ML293	ML95.4
ML99.1	SNGL.1	RW02.1	RW02.2	RW01.1	RW01.2
RW201

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

RWREQUEST FILE RELATIONS

ONE TO ONE RELATIONS

RWREQUEST FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.