RQPURCHCLS – Requesters Purchasing Classes
- System
- Requisitions (RQ)
- Prefix
RQP- Primary key
COMPANY,REQUESTER,PURCH-MAJOR,PURCH-MINOR- Fields
- 4
- Updated by
- 1 program
- Referenced by
- 24 programs
RQPURCHCLS is the Requesters Purchasing Classes table in Lawson Requisitions (prefix RQP). It is indexed by COMPANY, REQUESTER, PURCH-MAJOR, PURCH-MINOR (RQPSET1); alternate indexes: RQPSET2. It is related 1:1 to ICCOMPANY, MAJORCL and MINORCL and 1:M to RQREQAUDIT. It is updated by RQ04.1 and referenced by DR100, IC07.1, IC141, IC142, IC83.1, ICIA.1, RQ10.1, RQ10.3 and 16 more. The table has 4 fields, 2 indexes and 4 documented relations.
About RQPURCHCLS
This file contains the list of valid purchasing major classes that a requester can enter items for on a requisition.
Fields (4)
Column = COBOL field name without the RQP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
RQP-COMPANY PKCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | RQ04.1 |
RQP-REQUESTER PKREQUESTER | Alpha 10 (Lower Case) | This is the person who is limited to entering items with only these purchasing classes on a requisition. | RQ04.1 |
RQP-PURCH-MAJOR PKPURCH_MAJOR | Alpha 4 | — | RQ04.1 |
RQP-PURCH-MINOR PKPURCH_MINOR | Alpha 4 | — | RQ04.1 |
Indexes (2)
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 |
|---|---|---|---|---|
RQPSET1 | COMPANY, REQUESTER, PURCH-MAJOR, PURCH-MINOR | Primary | DR100, IC141, IC142, IC83.1, ICIA.1, RQ04.1, RQ10.1, RQ10.3 +16 more | |
RQPSET2 | COMPANY, PURCH-MAJOR, PURCH-MINOR, REQUESTER | IC07.1 |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Iccompany | ICCOMPANY | Required | RQP-COMPANY → ICC-COMPANY | |
| Purch Major | MAJORCL | Required | ICC-ITEM-GROUP → MAJ-ITEM-GROUP, "P" → MAJ-CLASS-TYPE, RQP-PURCH-MAJOR → MAJ-MAJOR-CLASS | |
| Purch Minor | MINORCL | Required | ICC-ITEM-GROUP → MIN-ITEM-GROUP, "P" → MIN-CLASS-TYPE, RQP-PURCH-MAJOR → MIN-MAJOR-CLASS, RQP-PURCH-MINOR → MIN-MINOR-CLASS |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Rqreqaudit | RQREQAUDIT | RQP-COMPANY → RQA-COMPANY, RQP-REQUESTER → RQA-REQUESTER, RQP-PURCH-MAJOR → RQA-PURCH-MAJOR, RQP-PURCH-MINOR → RQA-PURCH-MINOR, Spaces → RQA-ACCT-UNIT, Zeroes → RQA-DIST-COMPANY, RQA-DATE, RQA-TIME, RQA-FLD-NBR |
Programs
Updated by (1)
- RQ04.1 Requesters
Referenced by (24)
- DR100 Distribution Requirements Report
- IC07.1 Purchasing Class
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC83.1 Par Location Counts
- ICIA.1 Keyword Search INVOKED Object
- RQ10.1 Requisition
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ13.2 Direct Line Approval
- RQ204 Requester Listing
- RQ35.1 Requisition Returns
- RQ500 Requisition Interface
- RQ504 Requester Setup Extract
- RQIA.1 RQREQPD Invoke Object
- RQIB.1 RQRQHUPD Invoke Object
- RQIC.1 Get Item List Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQIG.1 Get Shopping List Invoke Object
- RQIH.1 Invoke Determine Express Data
- RQII.1 Invoke for Reqheader Inquiry
- RQIJ.1 Requisition Copy