RQAPPROVE FILE
Requisition Approvals
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.
REFERENCED BY
RQ02.1 RQ111 RQ44.2
UPDATED BY
IC83.1 RQ10.1 RQ10.3 RQ11.1 RQ12.1 RQ35.1
RQ500 RQIF.1 RQ13.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RAP-COMPANY Numeric 4 IC83.1 RQ10.1
Element: Company The company number represents an RQ10.3 RQ11.1
established company and is entered on RQ35.1 RQ500
all function codes. RQIF.1
RAP-AUTH-ID Alpha 10 IC83.1 RQ10.1
Authorization This is the authorization identifier RQ10.3 RQ11.1
Identification for the approver to access the RQ35.1 RQ500
requisitions that need approving at this RQIF.1
level.
RAP-APPROVE-CD Alpha 5 IC83.1 RQ10.1
Element: Approval Code This is a code to identify the approval RQ10.3 RQ11.1
process (levels) that a requisition has RQ35.1 RQ500
to pass before it can be picked or RQIF.1
purchased.
RAP-REQ-NUMBER Numeric 7 IC83.1 RQ10.1
Element: Requisition NuThis is the assigned number to identify RQ10.3 RQ11.1
this requisition. RQ35.1 RQ500
RQIF.1
RAP-APRV-LEVEL Numeric 1 IC83.1 RQ10.1
Element: Approval LevelThis is the approval level number RQ10.3 RQ11.1
within the approval code at which this RQ35.1 RQ500
requisition has to be approved. RQIF.1
RQAPPROVE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RAPSET1 COMPANY This index is used to access an open IC83.1 RQ02.1
AUTH-ID requisition approval record for a RQ10.1 RQ10.3
APPROVE-CD specific requisition number assigned a RQ11.1 RQ12.1
REQ-NUMBER specific authorization identifier and RQ35.1 RQ500
approve code. RQIF.1
RAPSET2 COMPANY This index is used to access a IC83.1 RQ10.1
REQ-NUMBER requisition approval record for a RQ10.3 RQ11.1
APRV-LEVEL specific company requisition number by RQ111 RQ12.1
approval level. RQ13.1 RQ35.1
RQ44.2 RQ500
RQIF.1
RQAPPROVE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
RQAPPROVE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Req Lines REQLINE
RAP-COMPANY -> RLN-COMPANY
RAP-REQ-NUMBER -> RLN-REQ-NUMBER
RLN-LINE-NBR
|
