RQREQAUDIT – Requester Audit

System: Requisitions (RQ)
Prefix: RQA
Primary key: COMPANY, REQUESTER, PURCH-MAJOR, PURCH-MINOR, ACCT-UNIT, DIST-COMPANY, DATE, TIME, FLD-NBR
Fields: 14
Updated by: 3 programs
Referenced by: 0 programs

RQREQAUDIT is the Requester Audit table in Lawson Requisitions (prefix RQA). It is indexed by COMPANY, REQUESTER, PURCH-MAJOR, PURCH-MINOR, ACCT-UNIT, DIST-COMPANY, DATE, TIME, FLD-NBR (RQASET1). It is related 1:1 to GLNAMES, ICCOMPANY, MAJORCL, MINORCL, REQUESTER, RQACCTU and RQPURCHCLS. It is updated by RQ04.1, RQ194 and RQ94.1. The table has 14 fields, 1 index and 7 documented relations.

About RQREQAUDIT

No description in the Lawson data dictionary.

Fields (14)

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

Field / column	Type	Description & values	Updated by
`RQA-COMPANY` PK COMPANY	Numeric 4	—	RQ04.1
`RQA-REQUESTER` PK REQUESTER	Alpha 10 (Lower Case)	—	RQ04.1
`RQA-PURCH-MAJOR` PK PURCH_MAJOR	Alpha 4	This field contains the user-defined major purchasing class identifier.	RQ04.1
`RQA-PURCH-MINOR` PK PURCH_MINOR	Alpha 4	This field contains the user-defined minor purchasing class identifier.	RQ04.1
`RQA-ACCT-UNIT` PK ACCT_UNIT	Alpha 15	—	RQ04.1
`RQA-DIST-COMPANY` PK DIST_COMPANY	Numeric 4	—	RQ04.1
`RQA-DATE` PK DATE	Numeric 8 (yyyymmdd)	—	RQ04.1
`RQA-TIME` PK TIME	Numeric 8	This field displays the system time when this was created.	RQ04.1
`RQA-FLD-NBR` PK FLD_NBR	Numeric 4	—	RQ04.1
`RQA-BEFORE-IMAGE` BEFORE_IMAGE	Alpha 60	—	RQ04.1
`RQA-AFTER-IMAGE` AFTER_IMAGE	Alpha 60	This field contains the field image after the change.	RQ04.1
`RQA-OPERATOR` OPERATOR	Alpha 10	—	RQ04.1
`RQA-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	—	RQ04.1
`RQA-AUDIT-ACTION` AUDIT_ACTION	Alpha 1	— `A` Add `C` Change `D` Delete	RQ04.1

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`RQASET1`	`COMPANY`, `REQUESTER`, `PURCH-MAJOR`, `PURCH-MINOR`, `ACCT-UNIT`, `DIST-COMPANY`, `DATE`, `TIME`, `FLD-NBR`	Primary		RQ04.1, RQ194, RQ94.1

Relations

One to one (7) — lookups and parents

Relation	Table	Rules	Field map
Glnames	GLNAMES	Not Required	`RQA-COMPANY` → `GLN-COMPANY`, `RQA-ACCT-UNIT` → `GLN-ACCT-UNIT`
Iccompany	ICCOMPANY	Required	`RQA-COMPANY` → `ICC-COMPANY`
Majorcl	MAJORCL	Not Required	`ICC-ITEM-GROUP` → `MAJ-ITEM-GROUP`, `"P"` → `MAJ-CLASS-TYPE`, `RQA-PURCH-MAJOR` → `MAJ-MAJOR-CLASS`
Minorcl	MINORCL	Not Required	`ICC-ITEM-GROUP` → `MIN-ITEM-GROUP`, `"P"` → `MIN-CLASS-TYPE`, `RQA-PURCH-MAJOR` → `MIN-MAJOR-CLASS`, `RQA-PURCH-MINOR` → `MIN-MINOR-CLASS`
Requester	REQUESTER	Required	`RQA-COMPANY` → `REQ-COMPANY`, `RQA-REQUESTER` → `REQ-REQUESTER`
Rqacctu	RQACCTU	Not Required	`RQA-COMPANY` → `RQU-COMPANY`, `RQA-REQUESTER` → `RQU-REQUESTER`, `RQA-ACCT-UNIT` → `RQU-ACCT-UNIT`, `RQA-DIST-COMPANY` → `RQU-DIST-COMPANY`
Rqpurchcls	RQPURCHCLS	Not Required	`RQA-COMPANY` → `RQP-COMPANY`, `RQA-REQUESTER` → `RQP-REQUESTER`, `RQA-PURCH-MAJOR` → `RQP-PURCH-MAJOR`, `RQA-PURCH-MINOR` → `RQP-PURCH-MINOR`

Programs

Updated by (3)

RQ04.1 Requesters
RQ194 Requester Audit Report
RQ94.1 Requester Audit Inquiry