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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RWHSET1HEAD-TYPE, HEAD-NAME, RECORD-TYPEPrimaryAC34.1, ACVW.1, ATVW.1, CA10.1, CA10.7, FB01.1, FB01.2, FB141 +22 more (list truncated in source)
RWHSET2FOLDER-NAME, HEAD-TYPE, HEAD-NAME, RECORD-TYPEKeyChangeRW01.1, RW01.2, RW201, RW260
RWHSET3HEAD-NAME, HEAD-TYPE, RECORD-TYPEAC34.1, AD290, AD50.1, AD95.1, AD96.1, AD97.1, AD97.2, AD97.3 +22 more (list truncated in source)
RWHSET4FOLDER-NAME, RECORD-TYPE, HEAD-NAMEKeyChange, SubsetWhere HEAD-TYPE = "G"RW240
RWHSET5FOLDER-NAME, HEAD-NAME, RECORD-TYPEKeyChange, SubsetWhere HEAD-TYPE = "R"RW11.1, RW11.2, RW11.3, RW210
RWHSET6FOLDER-NAME, HEAD-NAME, RECORD-TYPEKeyChange, SubsetWhere HEAD-TYPE = "T"RW260
RWHSET7RECORD-TYPE, FOLDER-NAME, HEAD-NAMEKeyChange, SubsetWhere HEAD-TYPE = "R"RW210
RWHSET8HEAD-TYPE, RECORD-TYPE, HEAD-NAMERW210, RW298
RWHSET9HEAD-TYPE, HEAD-NAMEFB01.1, FB01.2, FB20.2, FB201, GL256, RW01.1, RW01.2, RW03.1 +10 more

Relations

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
RwheadauRWHEADAURWH-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)