Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RWGRPDET


                             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    AC37.1    AC490
ACVW.1    ATVW.1    AM180     CA10.1    CA10.5    CA10.7
CA110     FB100     FB101     FB11.1    FB111     FB141
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    GL191     GL256     GL292     GL293
GL294     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    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
SNGL.1    SNOA.1    SNRA.1    SNSA.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
Element: 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
Element: Heading       This identifies the name of the group.    RW40.4  RW40.5

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


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


RGD-FR-VAR-LEVELS      Alpha 30                                  RW40.1
Element: From Variable 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
Element: Through CompanThis 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
Element: From Account  This is the beginning account number of
                       a range of accounts.


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


RGD-FR-SUB-ACCT        Numeric 4                                 RW40.4
Element: From SubaccounThis is the beginning subaccount for a
                       range of subaccounts.


RGD-TH-SUB-ACCT        Numeric 4                                 RW40.4
Element: Through SubaccThis 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
                                                                 AC37.1  AC490
                                                                 ACVW.1  ATVW.1
                                                                 AM180   CA10.1
                                                                 CA10.5  CA10.7
                                                                 CA110   FB100
                                                                 FB101   FB11.1
                                                                 FB111   FB141
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 ...

                         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