Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RWROWDET


                             RWROWDET FILE

                           RW Row File Detail

This file maintains the horizontal portion of a Report Writer report.
The rows are named and assigned types. RW210 (Row Listing) creates listings of
requested row information.


REFERENCED BY

AC121     AC123     AC130     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC32.1    AC37.1    AC490     ACVW.1
ATVW.1    AM180     CA10.5    CA110     FB100     FB101
FB11.1    FB111     FB160     FB20.1    FB20.6    FB20.7
FB21.1    FB211     FB296     FB60.1    FB95.1    FB95.2
FB95.3    FB95.4    FB95.5    FB95.6    GL256     GL298
GL90.6    GL94.1    GL94.2    GL94.3    GL94.4    GL94.5
GL94.6    GL94.7    GL95.1    GL95.2    GL95.3    GL95.4
GL95.5    GL95.6    GL95.7    GL95.8    GL95.9    GL96.1
GL96.2    GL96.3    GL96.4    GL96.5    GL97.1    GL97.2
GL97.3    GL97.4    GL97.5    GL97.6    GL97.7    GL97.8
GL97.9    GL98.1    GL98.2    GL98.3    GL98.4    GL98.5
GL99.1    GL99.2    GL99.3    GL99.4    GL99.5    GL99.6
RW00.1    RW100     RW215     RW230     RW260     RW270
RW298     RW299     RW30.1    RW70.1    GL16.4    GLAV.1
GLCV.1    GLVW.1    SLVW.1    SNOA.1    SNRA.1    SNSA.1


UPDATED BY

RW10.2    RW10.3    RW10.4    RW10.8    RW11.1    RW11.2
RW11.3    RW11.4    RW210     RW60.1    RW60.2    RW60.3


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RRD-RECORD-TYPE        Alpha 1                                   RW10.2  RW10.3
Element: Record Type   This field defines the record type for    RW10.4  RW11.4
                       the row: accounts only, levels only,      RW210   RW298
                       both levels and accounts, or ranges for   RW60.1
                       totals.

                       A = Accounts
                       B = Both Levels and Accts
                       L = Levels
                       R = Ranges for Totals

RRD-HEAD-NAME          Alpha 12                                  RW10.2  RW10.3
Element: Head Name     This is the name of a Level, Group,       RW10.4  RW10.8
                       Row, or Total Range.                      RW100   RW11.4
                                                                 RW210   RW298
                                                                 RW60.1  RW60.3

RRD-LINE-NBR           Numeric 6                                 RW10.2  RW10.3
Element: Line Nbr      This field contains the line number.      RW10.4  RW11.4
                                                                 RW210   RW298
                                                                 RW60.1

RRD-FR-COMPANY         Numeric 4                                 RW10.3  RW10.4
Element: Company       You can create reports for a range of     RW11.4  RW210
                       level groups within a specific company    RW60.1
                       range. Type or select the beginning
                       company number in this field.

                       Important: When you select a company
                       range, the companies must have the same
                       organizational level structure.



RRD-FR-VAR-LEVELS      Alpha 30                                  RW10.3  RW10.4
Element: From Variable You can select an additional level        RW11.4  RW210
                       range to include in the row line. Type    RW60.1
                       or select the beginning level
                       number in this field.


RRD-FR-ACCOUNT         Numeric 6                                 RW10.2  RW10.4
Element: Account       This field determines any additional      RW11.4  RW210
                       accounts you want to include in the row   RW60.1
                       line. Type or select the beginning
                       account number in this field.

                       If you select an account range, leave
                       the Account Group field blank.



RRD-FR-SUB-ACCT        Numeric 4                                 RW10.2  RW10.4
Element: From SubaccounThis field determines any additional      RW11.4  RW210
                       subaccounts you want to include in the    RW60.1
                       row line. Type or select the beginning
                       subaccount number in this field.

                       If you select a subaccount range, leave
                       the Subaccount Group field blank.

RRD-TH-COMPANY         Numeric 4                                 RW10.3  RW10.4
Element: Through CompanYou can create reports for a range of     RW11.4  RW210
                       level groups within a specific company    RW60.1
                       range. Type or select the ending company
                       number in this field.

                       If you leave this field blank, the
                       beginning company number defaults.



RRD-TH-VAR-LEVELS      Alpha 30                                  RW10.3  RW10.4
Through Variable       You can select an additional level        RW11.4  RW210
Level                  range to include in the row line. Type    RW60.1
                       or select the ending level number
                       in this field. If you leave this field
                       blank, the beginning level defaults.



RRD-TH-ACCOUNT         Numeric 6                                 RW10.2  RW10.4
Element: Through AccounThis field determines any additional      RW11.4  RW210
                       accounts you want to include in the row   RW60.1
                       line. Type or select the ending account
                       number in this field.

                       If you leave this field blank, the
                       beginning account number defaults.

                       If you select an account range, leave
                       the Account Group field blank.

RRD-TH-SUB-ACCT        Numeric 4                                 RW10.2  RW10.4
Element: Through SubaccThis field determines any additional      RW11.4  RW210
                       subaccounts you want to include in the    RW60.1
                       row line. Type or select the ending
                       subaccount number in this field.

                       If you leave this field blank, the
                       beginning subaccount number defaults.

                       If you select a subaccount range, leave
                       the Subaccount Group field blank.

RRD-ACCOUNT-DESC       Alpha 60  (Lower Case)                    RW10.2  RW10.3
Element: Account Desc  The account description.                  RW10.4  RW210

RRD-LINE-TYPE          Alpha 1                                   RW10.2  RW10.3
Element: Line Type     This field defines the line type for      RW10.4  RW100
                       the row: detail, header, total, base,     RW210
                       underline, or split.

                       D = Detail
                       H = Heading
                       T = Total
                       B = Base
                       U = Underline
                       S = Split

RRD-LINE-TYPE-1        Derived
Element: Line Type 1   This field is used for drill around. It
                       displays the Line Type field values.


RRD-DETAIL             Alpha 1                                   RW10.2  RW10.3
Element: Detail        This field defines the kind of detail     RW10.4  RW210
                       for the row: account detail, subaccount
                       detail, level detail, or consolidated.

                       A = Account
                       S = Subaccount
                       L = Level
                       C = Consolidated
                       " "

RRD-DETAIL-1           Derived
Element: Detail 1      This field is used for drill around. It
                       displays the Detail field values.


RRD-TOTAL-CODE         Numeric 1                                 RW10.2  RW10.3
Element: Total Code    Required if the line type is Total.       RW10.4  RW210
                       This field indicates the level (1-9) to
                       use for the total for this row.

                       1 = Level 1
                       2 = Level 2
                       3 = Level 3
                       4 = Level 4
                       5 = Level 5
                       6 = Level 6
                       7 = Level 7
                       8 = Level 8
                       9 = Level 9
                       0

RRD-TOTAL-CODE-1       Derived
Element: Total Code 1  This field is used for drill around. It
                       displays the Total Code field values.


RRD-SPACE-CODE         Numeric 1                                 RW10.2  RW10.3
Element: Space Code    Indicates the number of spaces you want   RW10.4  RW210
                       to advance after the account appears on
                       a report.

                       1 = No blank lines
                       2 = One blank line
                       3 = Two blank lines
                       9 = Page break
                       0

RRD-SPACE-CODE-1       Derived
Element: Space Code 1  This field is used for drill around. It
                       displays the Space Code field values.


RRD-SIGN-CODE          Alpha 1                                   RW10.2  RW10.3
Element: Sign Code     This field determines if the system       RW10.4  RW210
                       prints a negative sign next to a
                       positive amount. Use this option if you
                       do not want revenue and liability
                       balances to print with a negative sign.
                       Reversing the sign only affects report
                       printing, not account totaling.

                       If you leave this field blank, No
                       defaults and the system prints a
                       negative sign for a negative amount.


                       Y = Yes
                       N = No
                       " "

RRD-SIGN-CODE-1        Derived
Element: Sign Code 1   This field is used for drill around. It
                       displays the Sign Code field values.


RRD-OVD-ACCTUNIT       Alpha 15 Occurs 4 Times                   RW10.3  RW10.4
Accounting Unit        This field lets you override the          RW11.4  RW210
Override               default accounting unit. Enter the
                       accounting unit to use as the override.


RRD-ACCT-UNIT-1        Derived
Element: Accounting UniThis derived field contains the value
                       of the first Accounting Unit field.


RRD-ACCT-UNIT-2        Derived
Element: Accounting UniThis derived field contains the value
                       of the second Accounting Unit field.


RRD-ACCT-UNIT-3        Derived
Element: Accounting UniThis derived field contains the value
                       of the third Accounting Unit field.


RRD-ACCT-UNIT-4        Derived
Element: Accounting UniThis derived field contains the value
                       of the fourth Accounting Unit field.


RRD-LEVEL-GROUP        Alpha 12                                  RW10.3  RW10.4
Element: Level Group   You can type or select a level group to   RW11.4  RW210
                       include in the row line. A level group    RW60.1
                       is a group of level ranges. If you
                       select a level group, leave the Company
                       and Level Range fields blank.

RRD-ACCT-GROUP         Alpha 12                                  RW10.2  RW10.4
Element: Account Group You can type or select an account group   RW11.4  RW210
                       to include in the row line. An account    RW60.1
                       group is a group of account ranges. If
                       you select an account group, leave the
                       Major Account fields blank.


RRD-SUB-ACCT-GRP       Alpha 12                                  RW10.2  RW10.4
Element: Subaccount GroYou can type or select a subaccount       RW11.4  RW210
                       group. A subaccount group is a group of   RW60.1
                       subaccount ranges. If you select a
                       subaccount group, leave the Subaccount
                       fields blank.

RRD-PRT-LINE-OPT       Alpha 1                                   RW10.2  RW10.3
Element: Print Line OptThis field determines if account and      RW10.4  RW210
                       level row information prints on the
                       report. If you select No, only the row
                       line totals print.

                       If you leave this field blank, Yes
                       defaults and the line information
                       prints. You can select Unconditional
                       Underline only for an underline or
                       separator row that specifies the row is
                       printed unconditionally.


                       Y = Yes
                       N = No
                       U = Unconditional Underline/Sep

RRD-AFF-TOT-OPT        Alpha 1                                   RW10.2  RW10.3
Element: Affects Total This field lets you add the row line to   RW10.4  RW210
                       the total, subtract the row line from
                       the total, or define the row line as
                       having no effect on the total.

                       A = Add to total
                       S = Subtract from total
                       N = Don't affect total
                       " "

RRD-FORMAT-OVD         Numeric 1                                 RW10.2  RW10.3
Element: Format OverridThis field lets you assign an             RW10.4  RW210
                       additional format to calculate the row
                       line differently than other row lines.

                       Type or select a format defined in the
                       Formats form tab in RW00.1 (Report
                       Writer).


                       1 = Format 1
                       2 = Format 2
                       3 = Format 3
                       4 = Format 4
                       5 = Format 5
                       6 = Format 6
                       7 = Format 7
                       8 = Format 8

RRD-FORMAT-OVD-1       Derived
Element: Format OverridThis field is used for drill around. It
                       displays the Format Override field
                       values.


RRD-TWO-LINE-HEAD      Alpha 1                                   RW10.2  RW10.3
Element: Two-Line Head Y = Yes                                   RW10.4  RW210
                       N = No

RRD-DETAIL-GROUP       Alpha 1                                   RW10.2  RW10.3
Element: Detail Group  You can type a number to group row        RW10.4  RW210
                       lines into a detail group.

                       For example, if you type 1 in this field
                       for row lines 10 through 50, they become
                       detail group 1.


                       " "
                       0
                       9
                       A
                       Z

RRD-BAL-TYPE           Alpha 1                                   RW10.2  RW10.3
Element: Balance Type  This field lets you include the net       RW10.4  RW210
                       balance, only the debit balance, or only
                       the credit balance on the row file. The
                       default is Net Balance.

                       For example, if you are using a sales
                       account and only want to view the debit
                       balance, select Debit Only.


                       " " = Net Balance
                       D = Debit Only
                       C = Credit Only
                       E = Net Debit
                       R = Net Credit

RRD-CHART-NAME         Alpha 12                                  RW10.2  RW10.4
Element: Chart Name    This is the name you assigned to the      RW210
                       chart of accounts when you defined your
                       company structure in the General Ledger
                       system.


RRD-SUMRY-ACCT-ID      Numeric 6                                 RW10.2  RW10.4
Element: Summary AccounThis is the identifier for the summary    RW210
                       account.


RRD-MATRIX-LIST        Alpha 12                                  RW10.3  RW10.4
Element: Matrix List   You can type or select an accounting      RW210
                       unit list to include in the row line. An
                       accounting unit list is a group of
                       accounting units.

                       If you select an accounting unit list,
                       leave the Company and Accounting Unit
                       fields blank.

RRD-ACCOUNT-LIST       Alpha 12                                  RW10.2  RW10.4
Element: Account List                                            RW210

                         RWROWDET FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RRDSET1   RECORD-TYPE                                            AC121   AC123
          HEAD-NAME                                              AC130   AC20.1
          LINE-NBR                                               AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 ATVW.1  AM180
                                                                 CA10.5  CA110
                                                                 FB100   FB101
                                                                 FB11.1  FB111
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 ...

                         RWROWDET FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Account Group  RWHEADER     Required
                            When RRD-ACCT-GROUP != Spaces

                            "G"                  -> RWH-HEAD-TYPE
                            RRD-ACCT-GROUP       -> RWH-HEAD-NAME
                            "A"                  -> RWH-RECORD-TYPE

Glchart        GLCHART      Not Required

                            RRD-CHART-NAME       -> GCH-CHART-NAME

Glchartsum     GLCHARTSUM   Not Required

                            RRD-CHART-NAME       -> GCS-CHART-NAME
                            RRD-SUMRY-ACCT-ID    -> GCS-SUMRY-ACCT-ID

Level Group    RWHEADER     Required
                            When RRD-LEVEL-GROUP != Spaces

                            "G"                  -> RWH-HEAD-TYPE
                            RRD-LEVEL-GROUP      -> RWH-HEAD-NAME
                            "L"                  -> RWH-RECORD-TYPE

Mxlisthdr      MXLISTHDR    Not Required

                            "ACCTU"              -> MLH-OBJ-TYPE
                            RRD-MATRIX-LIST      -> MLH-MATRIX-LIST

Row Header     RWHEADER     Required

                            "R"                  -> RWH-HEAD-TYPE
                            RRD-HEAD-NAME        -> RWH-HEAD-NAME
                            RRD-RECORD-TYPE      -> RWH-RECORD-TYPE

Subacct Group  RWHEADER     Required
                            When RRD-SUB-ACCT-GRP != Spaces

                            "G"                  -> RWH-HEAD-TYPE
                            RRD-SUB-ACCT-GRP     -> RWH-HEAD-NAME
                            "S"                  -> RWH-RECORD-TYPE

                         RWROWDET FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Grp Det   RWGRPDET

                            "A"                  -> RGD-RECORD-TYPE
                            RRD-ACCT-GROUP       -> RGD-HEAD-NAME
                                                    RGD-RANGE-NUMBER

Lvl Grp Det    RWGRPDET

                            "L"                  -> RGD-RECORD-TYPE
                            RRD-LEVEL-GROUP      -> RGD-HEAD-NAME
                                                    RGD-RANGE-NUMBER

Sub Grp Det    RWGRPDET

                            "S"                  -> RGD-RECORD-TYPE
                            RRD-SUB-ACCT-GRP     -> RGD-HEAD-NAME
                                                    RGD-RANGE-NUMBER