RWGRPDET – Report Writer Group Detail

System
General Ledger (GL)
Prefix
RGD
Primary key
RECORD-TYPE, HEAD-NAME, RANGE-NUMBER
Fields
11
Updated by
17 programs
Referenced by
190 programs

RWGRPDET is the Report Writer Group Detail table in Lawson General Ledger (prefix RGD). It is indexed by RECORD-TYPE, HEAD-NAME, RANGE-NUMBER (RGDSET1). It is related 1:1 to GLSYSTEM and RWHEADER and 1:M to RWGRPDETAU. It is updated by AD290, AD50.1, AD95.1, AD96.1, AD97.1, AD97.2, AD97.3, AD98.1 and 9 more and referenced by AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 and 182 more. The table has 11 fields, 1 index and 3 documented relations.

About RWGRPDET

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.

Fields (11)

Column = COBOL field name without the RGD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
RGD-RECORD-TYPE PK
RECORD_TYPE		Alpha 1This field indicates the type of group record this is.
  • A Account Group
  • S Subaccount Group
  • L Level Group
RW40.1, RW40.3, RW40.4
RGD-HEAD-NAME PK
HEAD_NAME		Alpha 12This identifies the name of the group.RW40.1, RW40.3, RW40.4, RW40.5
RGD-RANGE-NUMBER PK
RANGE_NUMBER		Numeric 3This is the sequence number of the range.RW40.1, RW40.3, RW40.4
RGD-FR-COMPANY
FR_COMPANY		Numeric 4This is the beginning company number in a range of companies.RW40.1
RGD-FR-VAR-LEVELS
FR_VAR_LEVELS		Alpha 30This is the beginning variable level for a range of levels. If it is Level Group, this field defaults to all zeros.RW40.1
RGD-TH-COMPANY
TH_COMPANY		Numeric 4This is the ending company number for a range of companies.RW40.1
RGD-TH-VAR-LEVELS
TH_VAR_LEVELS		Alpha 30This is the ending variable level for a range of levels.RW40.1
RGD-FR-ACCOUNT
FR_ACCOUNT		Numeric 6This is the beginning account number of a range of accounts.GL146, GL197, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8, GL44.1 +2 more
RGD-TH-ACCOUNT
TH_ACCOUNT		Numeric 6This is the ending account number for a range of accounts.GL146, GL197, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8, GL44.1 +2 more
RGD-FR-SUB-ACCT
FR_SUB_ACCT		Numeric 4This is the beginning subaccount for a range of subaccounts.RW40.4
RGD-TH-SUB-ACCT
TH_SUB_ACCT		Numeric 4This is the ending subaccount for a range of subaccounts.RW40.4

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RGDSET1RECORD-TYPE, HEAD-NAME, RANGE-NUMBERPrimaryAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMRequiredWhen RGD-FR-COMPANY != ZeroesRGD-FR-COMPANY → GLS-COMPANY
RwheaderRWHEADERRequired"G" → RWH-HEAD-TYPE, RGD-HEAD-NAME → RWH-HEAD-NAME, RGD-RECORD-TYPE → RWH-RECORD-TYPE

One to many (1) — child tables

RelationTableRulesConditionField map
RwgrpdetauRWGRPDETAURGD-RECORD-TYPE → RGA-RECORD-TYPE, RGD-HEAD-NAME → RGA-HEAD-NAME, RGD-RANGE-NUMBER → RGA-RANGE-NUMBER, → RGA-UNIQUE-I-D

Programs

Updated by (17)

Referenced by (190)