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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated 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 4This field contains the user-defined major purchasing class identifier.RQ04.1
#RQA-PURCH-MINOR PK
PURCH_MINOR		Alpha 4This 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 8This 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 60This 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 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
RQASET1
  1. COMPANY
  2. REQUESTER
  3. PURCH-MAJOR
  4. PURCH-MINOR
  5. ACCT-UNIT
  6. DIST-COMPANY
  7. DATE ↓
  8. TIME ↓
  9. FLD-NBR
PrimaryRQ04.1, RQ194, RQ94.1

Relations

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

One to one (7) — lookups and parents

RelationTableRulesConditionField map
GlnamesGLNAMESNot Required
RQA-COMPANY→GLN-COMPANY
RQA-ACCT-UNIT→GLN-ACCT-UNIT
IccompanyICCOMPANYRequired
RQA-COMPANY→ICC-COMPANY
MajorclMAJORCLNot Required
ICC-ITEM-GROUP→MAJ-ITEM-GROUP
"P"→MAJ-CLASS-TYPE
RQA-PURCH-MAJOR→MAJ-MAJOR-CLASS
MinorclMINORCLNot Required
ICC-ITEM-GROUP→MIN-ITEM-GROUP
"P"→MIN-CLASS-TYPE
RQA-PURCH-MAJOR→MIN-MAJOR-CLASS
RQA-PURCH-MINOR→MIN-MINOR-CLASS
RequesterREQUESTERRequired
RQA-COMPANY→REQ-COMPANY
RQA-REQUESTER→REQ-REQUESTER
RqacctuRQACCTUNot Required
RQA-COMPANY→RQU-COMPANY
RQA-REQUESTER→RQU-REQUESTER
RQA-ACCT-UNIT→RQU-ACCT-UNIT
RQA-DIST-COMPANY→RQU-DIST-COMPANY
RqpurchclsRQPURCHCLSNot 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)