Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RWREQUEST


                             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