RWHEADER – Report Writer Header

System
General Ledger (GL)
Prefix
RWH
Primary key
HEAD-TYPE, HEAD-NAME, RECORD-TYPE
Fields
9
Updated by
21 programs
Referenced by
148 programs

RWHEADER is the Report Writer Header table in Lawson General Ledger (prefix RWH). It is indexed by HEAD-TYPE, HEAD-NAME, RECORD-TYPE (RWHSET1); alternate indexes: RWHSET2, RWHSET3, RWHSET4, RWHSET5, RWHSET6, RWHSET7, RWHSET8 and RWHSET9. It is related 1:1 to GLCODES and 1:M to RWGRPDET, RWUSER, FBHEADER, RWREQUEST, RWROWDET, GLCODES and RWHEADAU. It is updated by FB01.2, RW03.2, RW10.2, RW10.3, RW10.4, RW10.8, RW11.1, RW11.2 and 13 more and referenced by AC34.1, ACVW.1, AD290, AD50.1, AD95.1, AD96.1, AD97.1, AD97.2 and 140 more. The table has 9 fields, 9 indexes and 12 documented relations.

About RWHEADER

This file maintains Report Writer header information for Account Rows, Level Rows, or Both Type Rows, Level Group, Account Group, Subaccount Group, Total Range, or User Class.

Fields (9)

Column = COBOL field name without the RWH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#RWH-HEAD-TYPE PK
HEAD_TYPE		Alpha 1This field identifies if it is a Row Type, User Class, Total Range, or Group.
  • G Level, Acct or Subacct Group
  • R Row File
  • T Total Range
  • U User Class
  • B Budget User Class
FB01.2, RW03.2, RW10.2, RW10.3, RW10.4, RW11.1, RW11.2, RW11.3 +4 more
#RWH-HEAD-NAME PK
HEAD_NAME		Alpha 12This is the name of a level, account or subaccount group; row name; total range; or user class.FB01.2, RW03.2, RW10.2, RW10.3, RW10.4, RW10.8, RW11.1, RW11.2 +7 more
#RWH-RECORD-TYPE PK
RECORD_TYPE		Alpha 1This field identifies the type of record defined.
  • A Accounts
  • B Both Levels and Accts
  • L Levels
  • R Total Ranges
  • S Subaccounts
RW10.2, RW10.3, RW10.4, RW11.1, RW11.2, RW11.3, RW40.6, RW40.7 +2 more
#RWH-RECORD-TYPE-1
RECORD_TYPE_1		DerivedThis field is used for drill around. It displays the Record Type field values.—
#RWH-FOLDER-NAME SET2 SET4 SET5 SET6 SET7
FOLDER_NAME		Alpha 12This is the folder name as defined in RW01.1 (Folder).RW10.2, RW10.3, RW10.4, RW10.8, RW11.1, RW11.2, RW11.3, RW40.5 +5 more
#RWH-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the folder description.FB01.2, RW03.2, RW10.2, RW10.3, RW10.4, RW10.8, RW100, RW11.1 +8 more
#RWH-PERSON-RESP
PERSON_RESP		Alpha 15 (Lower Case)This is the name of the person responsible for this record.RW100, RW40.6
#RWH-NBR-LINES
NBR_LINES		Numeric 6This is the number of detail lines.RW10.2, RW10.3, RW10.4, RW11.4, RW40.1, RW40.3, RW40.4, RW60.1
#RWH-LINE-NBR
LINE_NBR		Numeric 6This is the detail line number.RW10.2, RW10.3, RW10.4, RW11.4, RW210, RW40.1, RW40.3, RW40.4 +4 more

Indexes (9)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RWHSET1
  1. HEAD-TYPE
  2. HEAD-NAME
  3. RECORD-TYPE
PrimaryAC34.1, ACVW.1, ATVW.1, CA10.1, CA10.7, FB01.1, FB01.2, FB141 +22 more (list truncated in source)
RWHSET2
  1. FOLDER-NAME
  2. HEAD-TYPE
  3. HEAD-NAME
  4. RECORD-TYPE
KeyChangeRW01.1, RW01.2, RW201, RW260
RWHSET3
  1. HEAD-NAME
  2. HEAD-TYPE
  3. RECORD-TYPE
AC34.1, AD290, AD50.1, AD95.1, AD96.1, AD97.1, AD97.2, AD97.3 +22 more (list truncated in source)
RWHSET4
  1. FOLDER-NAME
  2. RECORD-TYPE
  3. HEAD-NAME
KeyChange, SubsetWhere HEAD-TYPE = "G"RW240
RWHSET5
  1. FOLDER-NAME
  2. HEAD-NAME
  3. RECORD-TYPE
KeyChange, SubsetWhere HEAD-TYPE = "R"RW11.1, RW11.2, RW11.3, RW210
RWHSET6
  1. FOLDER-NAME
  2. HEAD-NAME
  3. RECORD-TYPE
KeyChange, SubsetWhere HEAD-TYPE = "T"RW260
RWHSET7
  1. RECORD-TYPE
  2. FOLDER-NAME
  3. HEAD-NAME
KeyChange, SubsetWhere HEAD-TYPE = "R"RW210
RWHSET8
  1. HEAD-TYPE
  2. RECORD-TYPE
  3. HEAD-NAME
RW210, RW298
RWHSET9
  1. HEAD-TYPE
  2. HEAD-NAME
FB01.1, FB01.2, FB20.2, FB201, GL256, RW01.1, RW01.2, RW03.1 +10 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLCODESRWGRPDETRWUSERFBHEADERRWREQUESTRWROWDETGLCODESRWHEADAURWHEADER

One to one (1) — lookups and parents

RelationTableRulesConditionField map
FolderGLCODESRequired
"F"→GCD-RECORD-TYPE
RWH-FOLDER-NAME→GCD-FOLDER-NAME
Spaces→GCD-PROCESS-GROUP
Spaces→GCD-SYSTEM
Zeroes→GCD-COMPANY

One to many (11) — child tables

RelationTableRulesConditionField map
Account GroupRWGRPDETDelete CascadesValid When RWH-HEAD-TYPE = "G"
"A"→RGD-RECORD-TYPE
RWH-HEAD-NAME→RGD-HEAD-NAME
—→RGD-RANGE-NUMBER
Buduser ClassRWUSERValid When RWH-HEAD-TYPE = "B"
RWH-HEAD-NAME→RWU-USER-CLASS
—→RWU-USERNAME
FbheaderFBHEADERValid When RWH-HEAD-TYPE = "B"
RWH-HEAD-NAME→FBH-USER-CLASS
—→FBH-COMPANY
—→FBH-FISCAL-YEAR
—→FBH-BUDGET-NBR
Level GroupRWGRPDETDelete CascadesValid When RWH-HEAD-TYPE = "G"
"L"→RGD-RECORD-TYPE
RWH-HEAD-NAME→RGD-HEAD-NAME
—→RGD-RANGE-NUMBER
Row RequestRWREQUESTDelete RestrictedValid When RWH-HEAD-TYPE = "R"
RWH-HEAD-NAME→RWR-ROW-FILE-NAME
—→RWR-REQUEST-NAME
RowdetailRWROWDETDelete CascadesValid When RWH-HEAD-TYPE = "R"
RWH-RECORD-TYPE→RRD-RECORD-TYPE
RWH-HEAD-NAME→RRD-HEAD-NAME
—→RRD-LINE-NBR
RwfolderGLCODESDelete RestrictedValid When RWH-HEAD-TYPE = "U"
RWH-HEAD-NAME→GCD-USER-CLASS
—→GCD-FOLDER-NAME
RwheadauRWHEADAU
RWH-HEAD-TYPE→HEA-HEAD-TYPE
RWH-HEAD-NAME→HEA-HEAD-NAME
RWH-RECORD-TYPE→HEA-RECORD-TYPE
—→HEA-ACTION
—→HEA-DATE
—→HEA-TIME
—→HEA-UNIQUE-I-D
Subacct GroupRWGRPDETDelete CascadesValid When RWH-HEAD-TYPE = "G"
"S"→RGD-RECORD-TYPE
RWH-HEAD-NAME→RGD-HEAD-NAME
—→RGD-RANGE-NUMBER
Total RangesRWROWDETDelete CascadesValid When RWH-HEAD-TYPE = "T"
"R"→RRD-RECORD-TYPE
RWH-HEAD-NAME→RRD-HEAD-NAME
—→RRD-LINE-NBR
User ClassRWUSERDelete CascadesValid When RWH-HEAD-TYPE = "U"
RWH-HEAD-NAME→RWU-USER-CLASS
—→RWU-USERNAME

Programs

Updated by (21)

Referenced by (148)