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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#RLA-COMPANY PKCOMPANY | Numeric 4 | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more |
#RLA-REQ-LOCATION PKREQ_LOCATION | Alpha 5 | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more |
#RLA-DATE PKDATE | Numeric 8 (yyyymmdd) | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more |
#RLA-TIME PKTIME | 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 PKFLD_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-IMAGEBEFORE_IMAGE | Alpha 35 | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more |
#RLA-AFTER-IMAGEAFTER_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-OPERATOROPERATOR | Alpha 10 | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more |
#RLA-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more |
#RLA-AUDIT-ACTIONAUDIT_ACTION | Alpha 1 | —
| AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RLASET1 |
| 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
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