RQRQLAUDIT – Requesting Location Audit

System: Requisitions (RQ)
Prefix: RLA
Primary key: COMPANY, REQ-LOCATION, DATE, TIME, FLD-NBR
Fields: 10
Updated by: 16 programs
Referenced by: 0 programs

RQRQLAUDIT is the Requesting Location Audit table in Lawson Requisitions (prefix RLA). It is indexed by COMPANY, REQ-LOCATION, DATE, TIME, FLD-NBR (RLASET1). It is related 1:1 to ICCOMPANY and RQLOC. It is updated by AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 and 8 more. The table has 10 fields, 1 index and 2 documented relations.

About RQRQLAUDIT

No description in the Lawson data dictionary.

Fields (10)

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

Field / column	Type	Description & values	Updated by
`RLA-COMPANY` PK COMPANY	Numeric 4	—	AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
`RLA-REQ-LOCATION` PK REQ_LOCATION	Alpha 5	—	AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
`RLA-DATE` PK DATE	Numeric 8 (yyyymmdd)	—	AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
`RLA-TIME` PK TIME	Numeric 8	This field displays the system time when this was created.	AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
`RLA-FLD-NBR` PK FLD_NBR	Numeric 4	This field contains a unique number assigned to a field that identifies the description of the field.	AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
`RLA-BEFORE-IMAGE` BEFORE_IMAGE	Alpha 35	—	AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
`RLA-AFTER-IMAGE` AFTER_IMAGE	Alpha 35	This field contains the field image after the change.	AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
`RLA-OPERATOR` OPERATOR	Alpha 10	—	AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
`RLA-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	—	AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
`RLA-AUDIT-ACTION` AUDIT_ACTION	Alpha 1	— `A` Add `C` Change `D` Delete	AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more

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
`RLASET1`	`COMPANY`, `REQ-LOCATION`, `DATE`, `TIME`, `FLD-NBR`	Primary		AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +8 more

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Iccompany	ICCOMPANY	Required		`RLA-COMPANY` → `ICC-COMPANY`
Rqloc	RQLOC	Required		`RLA-COMPANY` → `RQL-COMPANY`, `RLA-REQ-LOCATION` → `RQL-REQ-LOCATION`

Programs

Updated by (16)

AP510 Vendor Conversion
IC64.1 Global Location Nbr Assignment GL/IC Company
IC64.2 Global Location Nbr Assignment IC Location
IC64.3 Global Location Number Assignment RQ Location
IC64.4 Global Location Number Assignment Manuf Code
IC64.5 Global Location Number Assignment Manuf Div
IC64.6 Global Location Number Assignment Vendor
IC64.7 Global Location Number Assignment Vendor Location
IC64.8 Global Location Number Assignment IC Bin
IC64.9 Global Location Number Assignment Buyer
IC81.1 Cart, Par Location
IC840 Cart Par Location Conversion
RQ01.1 Requesting Locations
RQ191 Requesting Location Audit Rpt
RQ810 Request Location Load
RQ91.1 Requesting Location Audit Inquiry