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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| 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 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 |
|---|---|---|---|---|
RQPSET1 |
| Primary | DR100, IC141, IC142, IC83.1, ICIA.1, RQ04.1, RQ10.1, RQ10.3 +16 more | |
RQPSET2 |
| IC07.1 |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Iccompany | ICCOMPANY | Required |
| |||||||||||||
| Purch Major | MAJORCL | Required |
| |||||||||||||
| Purch Minor | MINORCL | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Rqreqaudit | RQREQAUDIT |
|
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