RWHEADAU – Report Writer Header Audit

System
General Ledger (GL)
Prefix
HEA
Primary key
HEAD-TYPE, HEAD-NAME, RECORD-TYPE, ACTION, DATE, TIME, UNIQUE-I-D
Fields
13
Updated by
43 programs
Referenced by
3 programs

RWHEADAU is the Report Writer Header Audit table in Lawson General Ledger (prefix HEA). It is indexed by HEAD-TYPE, HEAD-NAME, RECORD-TYPE, ACTION, DATE, TIME, UNIQUE-I-D (HEASET1); alternate indexes: HEASET2, HEASET3, HEASET4, HEASET5 and HEAUID. It is related 1:1 to RWHEADER. It is updated by FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 and 35 more and referenced by RW278, RW91.2 and RW91.9. The table has 13 fields, 6 indexes and 1 documented relation.

About RWHEADAU

No description in the Lawson data dictionary.

Fields (13)

Column = COBOL field name without the HEA- 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
#HEA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
#HEA-HEAD-TYPE PK
HEAD_TYPE		Alpha 1—FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 +34 more
#HEA-HEAD-NAME PK
HEAD_NAME		Alpha 12—FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 +34 more
#HEA-RECORD-TYPE PK
RECORD_TYPE		Alpha 1—FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 +34 more
#HEA-ACTION PK
ACTION		Alpha 1—
  • A Add
  • C Change
  • D Delete
FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 +34 more
#HEA-OPERATOR SET2
OPERATOR		Alpha 10—FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 +34 more
#HEA-DATE PK
DATE		Numeric 8 (yyyymmdd)—FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 +34 more
#HEA-TIME PK
TIME		Numeric 6 (hhmmss)—FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 +34 more
#HEA-PROGRAM
PROGRAM		Alpha 5—FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 +34 more
#HEA-FIELD-NAME SET4
FIELD_NAME		Alpha 15—FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 +34 more
#HEA-FIELD-ID
FIELD_ID		Numeric 3—FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 +34 more
#HEA-OLD-VALUE
OLD_VALUE		Alpha 60 (Lower Case)—FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 +34 more
#HEA-NEW-VALUE
NEW_VALUE		Alpha 60 (Lower Case)—FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL95.4, GL99.1 +34 more

Indexes (6)

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
HEASET1
  1. HEAD-TYPE
  2. HEAD-NAME
  3. RECORD-TYPE
  4. ACTION
  5. DATE
  6. TIME
  7. UNIQUE-I-D
PrimaryRW278, RW305, RW91.2, RW91.9
HEASET2
  1. HEAD-NAME
  2. OPERATOR
  3. ACTION
  4. DATE
  5. TIME
  6. HEAD-TYPE
  7. RECORD-TYPE
  8. UNIQUE-I-D
RW278
HEASET3
  1. HEAD-NAME
  2. DATE
  3. TIME
  4. ACTION
  5. HEAD-TYPE
  6. RECORD-TYPE
  7. UNIQUE-I-D
RW278, RW305
HEASET4
  1. HEAD-NAME
  2. FIELD-NAME
  3. ACTION
  4. DATE
  5. TIME
  6. HEAD-TYPE
  7. RECORD-TYPE
  8. UNIQUE-I-D
RW278
HEASET5
  1. HEAD-NAME
  2. ACTION
  3. DATE
  4. TIME
  5. HEAD-TYPE
  6. RECORD-TYPE
  7. UNIQUE-I-D
RW278
HEAUID
  1. UNIQUE-I-D
—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
RwheaderRWHEADERRequired
HEA-HEAD-TYPE→RWH-HEAD-TYPE (RWHSET1)
HEA-HEAD-NAME→RWH-HEAD-NAME
HEA-RECORD-TYPE→RWH-RECORD-TYPE

Programs

Updated by (43)

Referenced by (3)