Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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     AC130     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC32.1    AC34.1    AC490     ACVW.1
AM180     CA10.1    CA10.5    CA10.7    CA110     FB100
FB101     FB11.1    FB141     FB20.1    FB20.6    FB20.7
FB21.1    FB211     FB296     FB95.1    FB95.2    FB95.3
FB95.4    FB95.5    FB95.6    GL191     GL256     GL292
GL293     GL294     GL298     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    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    GL00.3    GL16.2    GL16.4
GLAV.1    GLCV.1    GLDM.3    GLOP.1    GLVW.1    SLVW.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                                              AC130   AC20.1
          RANGE-NUMBER                                           AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC34.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.1
                                                                 CA10.5  CA10.7
                                                                 CA110   FB100
                                                                 FB101   FB11.1
                                                                 FB141   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB95.1
                                                                 FB95.2  FB95.3
                                                                 ...

                         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