Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             RWGRPDET FILE

                       Report Writer Group Detail

This file contains detailed information for Report Writer groups as defined
in RW40.1 (Level Group), RW40.3 (Account Group), or RW40.4 (Subaccount Group).
Groups are sequential or nonsequential ranges of individual levels, accounts,
or subaccounts.


REFERENCED BY

AC121     AC123     AC127     AC130     AC20.1    AC20.2
AC20.3    AC20.4    AC22.1    AC30.2    AC30.3    AC32.1
ACVW.1    CA10.1    CA10.5    CA10.8    CA110     FB100
FB101     FB141     FB20.1    FB20.6    FB20.7    FB21.1
FB700     FB95.1    FB95.2    FB95.3    FB95.4    FB95.5
FB95.6    GL191     GL256     GL292     GL293     GL294
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    RW10.2
RW10.3    RW10.4    RW10.6    RW10.7    RW100     RW20.5
RW20.6    RW215     RW230     RW240     RW270     RW299
RW30.1    RW60.1    RW60.4    RW70.1    RW80.1    GL87.1
GL88.1    GLCV.1    GLOP.1    GLVW.1

UPDATED BY

RW40.1    RW40.3    RW40.4    RW40.5    RW40.6    RW40.7
RW40.8

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RGD-RECORD-TYPE      Alpha 1                                     RW40.1  RW40.3
Record Type          This field indicates the type of group      RW40.4
                     record this is.

                     A = Account Group
                     S = Subaccount Group
                     L = Level Group

RGD-HEAD-NAME        Alpha 12                                    RW40.1  RW40.3
Heading              This identifies the name of the group.      RW40.4  RW40.5

RGD-RANGE-NUMBER     Numeric 3                                   RW40.1  RW40.3
Range Number         This is the sequence number of the          RW40.4
                     range.


RGD-FR-COMPANY       Numeric 4                                   RW40.1
From Company         This is the beginning company number in
                     a range of companies.


RGD-FR-VAR-LEVELS    Alpha 30                                    RW40.1
From Variable Level  This is the beginning variable level
                     for a range of levels.

                     If it is Level Group, this field
                     defaults to all zeros.



RGD-TH-COMPANY       Numeric 4                                   RW40.1
Through Company      This is the ending company number for a
                     range of companies.


RGD-TH-VAR-LEVELS    Alpha 30                                    RW40.1
Through Variable     This is the ending variable level for a
Level                range of levels.


RGD-FR-ACCOUNT       Numeric 6                                   RW40.3
From Account         This is the beginning account number of
                     a range of accounts.


RGD-TH-ACCOUNT       Numeric 6                                   RW40.3
Through Account      This is the ending account number for a
                     range of accounts.


RGD-FR-SUB-ACCT      Numeric 4                                   RW40.4
From Subaccount      This is the beginning subaccount for a
                     range of subaccounts.


RGD-TH-SUB-ACCT      Numeric 4                                   RW40.4
Through Subaccount   This is the ending subaccount for a
                     range of subaccounts.


                         RWGRPDET FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RGDSET1   RECORD-TYPE                                            AC121   AC123
          HEAD-NAME                                              AC127   AC130
          RANGE-NUMBER                                           AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC22.1  AC30.2
                                                                 AC30.3  AC32.1
                                                                 ACVW.1  CA10.1
                                                                 CA10.5  CA10.8
                                                                 CA110   FB100
                                                                 FB101   FB141
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB700   FB95.1
                                                                 FB95.2  FB95.3
                                                                 FB95.4  FB95.5
                                                                 ...

                         RWGRPDET FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        GLSYSTEM     Required
                            When RGD-FR-COMPANY != Zeroes

                            RGD-FR-COMPANY     -> GLS-COMPANY

Rwheader       RWHEADER     Required

                            "G"                -> RWH-HEAD-TYPE
                            RGD-HEAD-NAME      -> RWH-HEAD-NAME
                            RGD-RECORD-TYPE    -> RWH-RECORD-TYPE