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    AC30.2    AC30.3    AC32.1    AC34.1
AC490     ACVW.1    AM180     CA10.1    CA10.5    CA10.7
CA110     FB100     FB101     FB141     FB20.1    FB20.6
FB20.7    FB21.1    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
GL00.3    GL16.2    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
                                                                 AC30.2  AC30.3
                                                                 AC32.1  AC34.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.1
                                                                 CA10.5  CA10.7
                                                                 CA110   FB100
                                                                 FB101   FB141
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 ...

                         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