RQAUDIT – Requisition Audit

System
Requisitions (RQ)
Prefix
RHA
Primary key
COMPANY, REQ-NUMBER, LINE-NBR, LINE-SEQ, BIN, LOT-SERIAL, UOM, DATE, TIME, FLD-NBR, AUDIT-TYPE
Fields
16
Updated by
246 programs
Referenced by
0 programs

RQAUDIT is the Requisition Audit table in Lawson Requisitions (prefix RHA). It is indexed by COMPANY, REQ-NUMBER, LINE-NBR, LINE-SEQ, BIN, LOT-SERIAL, UOM, DATE, TIME, FLD-NBR, AUDIT-TYPE (RHASET1); alternate indexes: RHASET2. It is related 1:1 to ICCOMPANY, ICVALUOM, ITSERIAL, MMDIST, PORLNUF, PORQHUF, REQHEADER, REQLINE and 1 more. It is updated by AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 and 238 more. The table has 16 fields, 2 indexes and 9 documented relations.

About RQAUDIT

No description in the Lawson data dictionary.

Fields (16)

Column = COBOL field name without the RHA- 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
#RHA-COMPANY PK
COMPANY		Numeric 4—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-REQ-NUMBER PK
REQ_NUMBER		Numeric 7—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-LINE-NBR PK
LINE_NBR		Numeric 6—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-LINE-SEQ PK
LINE_SEQ		Numeric 3This is the sequence number for a distribution.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-BIN PK
BIN		Alpha 7—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-LOT-SERIAL PK
LOT_SERIAL		Alpha 16This field contains either the serial number or the lot number for an item or any number of items.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-UOM PK
UOM		Alpha 4—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-DATE PK
DATE		Numeric 8 (yyyymmdd)—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-TIME PK
TIME		Numeric 8—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-FLD-NBR PK
FLD_NBR		Numeric 4—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-AUDIT-TYPE PK
AUDIT_TYPE		Alpha 2—
  • DS Requisition Line Distribution
  • HD Requisition Header
  • LD Requisition Line Detail
  • LN Requisition Line
AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-BEFORE-IMAGE
BEFORE_IMAGE		Alpha 60—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-AFTER-IMAGE
AFTER_IMAGE		Alpha 60This field contains the field image after the change.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-OPERATOR
OPERATOR		Alpha 10—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#RHA-AUDIT-ACTION
AUDIT_ACTION		Alpha 1—
  • A Add
  • C Change
  • D Delete
  • R Release
  • U Unrelease
  • I Issue
  • P Approve
  • E Reject
AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)

Indexes (2)

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
RHASET1
  1. COMPANY
  2. REQ-NUMBER
  3. LINE-NBR
  4. LINE-SEQ
  5. BIN
  6. LOT-SERIAL
  7. UOM
  8. DATE ↓
  9. TIME ↓
  10. FLD-NBR
  11. AUDIT-TYPE
PrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
RHASET2
  1. AUDIT-TYPE
  2. COMPANY
  3. REQ-NUMBER
  4. LINE-NBR
  5. LINE-SEQ
  6. BIN
  7. LOT-SERIAL
  8. UOM
  9. DATE ↓
  10. TIME ↓
  11. FLD-NBR
—

Relations

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

One to one (9) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequired
RHA-COMPANY→ICC-COMPANY (ICCSET1)
IcvaluomICVALUOMNot RequiredValid When RHA-UOM != Spaces
ICC-ITEM-GROUP→ICV-ITEM-GROUP
RHA-UOM→ICV-VALID-UOM
ItserialITSERIALNot RequiredValid When RHA-LOT-SERIAL != Spaces
RHA-COMPANY→SER-COMPANY
RLN-ITEM→SER-ITEM
RHA-LOT-SERIAL→SER-SERIAL
MmdistMMDISTRequiredWhen RHA-AUDIT-TYPE = "DS"
RHA-COMPANY→MMD-COMPANY
RHA-REQ-NUMBER→MMD-DOC-NBR-NUM
RHA-LINE-NBR→MMD-LINE-NBR
RHA-LINE-SEQ→MMD-LINE-SEQ
PorlnufPORLNUFNot RequiredValid When RHA-AUDIT-TYPE = "LN"
RHA-COMPANY→UFQ-COMPANY
RHA-REQ-NUMBER→UFQ-REQ-NUMBER
RHA-LINE-NBR→UFQ-LINE-NBR
PorqhufPORQHUFNot RequiredValid When RHA-AUDIT-TYPE = "HD"
RHA-COMPANY→UFH-COMPANY
RHA-REQ-NUMBER→UFH-REQ-NUMBER
ReqheaderREQHEADERRequiredWhen RHA-AUDIT-TYPE = "HD"
RHA-COMPANY→RQH-COMPANY
RHA-REQ-NUMBER→RQH-REQ-NUMBER
ReqlineREQLINERequiredWhen RHA-AUDIT-TYPE = "LN"
RHA-COMPANY→RLN-COMPANY
RHA-REQ-NUMBER→RLN-REQ-NUMBER
RHA-LINE-NBR→RLN-LINE-NBR
RqlinedtlRQLINEDTLNot RequiredValid When RHA-AUDIT-TYPE = "LD"
RHA-COMPANY→RQD-COMPANY
RHA-REQ-NUMBER→RQD-REQ-NUMBER
RHA-LINE-NBR→RQD-LINE-NBR
RHA-BIN→RQD-BIN
RHA-LOT-SERIAL→RQD-LOT-SERIAL
RHA-UOM→RQD-UOM

Programs

Updated by (246)