RQAPPROVE – Requisition Approvals

System: Requisitions (RQ)
Prefix: RAP
Primary key: COMPANY, AUTH-ID, APPROVE-CD, REQ-NUMBER
Fields: 5
Updated by: 9 programs
Referenced by: 3 programs

RQAPPROVE is the Requisition Approvals table in Lawson Requisitions (prefix RAP). It is indexed by COMPANY, AUTH-ID, APPROVE-CD, REQ-NUMBER (RAPSET1); alternate indexes: RAPSET2. It is related 1:1 to RQAPPCODE, ICCOMPANY, REQUESTER and REQHEADER and 1:M to REQLINE. It is updated by IC83.1, RQ04.1, RQ10.1, RQ12.1, RQ13.1, RQ13.2, RQ35.1, RQ500 and 1 more and referenced by RQ02.1, RQ111 and RQ44.2. The table has 5 fields, 2 indexes and 5 documented relations.

About RQAPPROVE

This is the file of open approval records needing to be approved. These records are created when a new or changed requisition is released. Records are created for each approval amount level that is less than the requisition total value. These records are deleted when the approver approves the requisition at a level.

Fields (5)

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

Field / column	Type	Description & values	Updated by
`RAP-COMPANY` PK COMPANY	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.	IC83.1, RQ10.1, RQ35.1, RQ500, RQIF.1
`RAP-AUTH-ID` PK AUTH_ID	Alpha 10	This is the authorization identifier for the approver to access the requisitions that need approving at this level.	IC83.1, RQ10.1, RQ35.1, RQ500, RQIF.1
`RAP-APPROVE-CD` PK APPROVE_CD	Alpha 5	This is a code to identify the approval process (levels) that a requisition has to pass before it can be picked or purchased.	IC83.1, RQ10.1, RQ35.1, RQ500, RQIF.1
`RAP-REQ-NUMBER` PK REQ_NUMBER	Numeric 7	This is the assigned number to identify this requisition.	IC83.1, RQ10.1, RQ35.1, RQ500, RQIF.1
`RAP-APRV-LEVEL` APRV_LEVEL	Numeric 1	This is the approval level number within the approval code at which this requisition has to be approved.	IC83.1, RQ10.1, RQ35.1, RQ500, RQIF.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
`RAPSET1`	`COMPANY`, `AUTH-ID`, `APPROVE-CD`, `REQ-NUMBER`	Primary		IC83.1, RQ02.1, RQ04.1, RQ10.1, RQ12.1, RQ35.1, RQ500, RQIF.1
`RAPSET2`	`COMPANY`, `REQ-NUMBER`, `APRV-LEVEL`			IC83.1, RQ10.1, RQ111, RQ12.1, RQ13.1, RQ13.2, RQ44.2, RQIF.1

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Approve Code	RQAPPCODE	Required	`RAP-COMPANY` → `RAC-COMPANY`, `RAP-APPROVE-CD` → `RAC-APPROVE-CD`
Ic Company	ICCOMPANY	Required	`RAP-COMPANY` → `ICC-COMPANY`
Requester	REQUESTER	Not Required	`RAP-COMPANY` → `REQ-COMPANY`, `RQH-REQUESTER` → `REQ-REQUESTER`
Requisition	REQHEADER	Required	`RAP-COMPANY` → `RQH-COMPANY`, `RAP-REQ-NUMBER` → `RQH-REQ-NUMBER`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Req Lines	REQLINE			`RAP-COMPANY` → `RLN-COMPANY`, `RAP-REQ-NUMBER` → `RLN-REQ-NUMBER`, → `RLN-LINE-NBR`

Programs

Updated by (9)

IC83.1 Par Location Counts
RQ04.1 Requesters
RQ10.1 Requisition
RQ12.1 Approval Review
RQ13.1 Direct Approval
RQ13.2 Direct Line Approval
RQ35.1 Requisition Returns
RQ500 Requisition Interface
RQIF.1 RQRLNUPD Invoke Object

Referenced by (3)

RQ02.1 Approval Codes
RQ111 Print Requisitions
RQ44.2 Requisition Detail Inquiry