|
|
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 RQ12.1 RQ35.1 RQ500 RQIF.1
RQ13.1 RQ13.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RAP-COMPANY Numeric 4 IC83.1 RQ10.1
Element: Company Identifies the AP company if the RQ35.1 RQ500
resource type = V. Identifies the HR RQIF.1
company if the resource type = E. It is
blank for type A, P or Q resources.
RAP-AUTH-ID Alpha 10 IC83.1 RQ10.1
Authorization This is the authorization identifier RQ35.1 RQ500
Identification for the approver to access the RQIF.1
requisitions that need approving at this
level.
RAP-APPROVE-CD Alpha 5 IC83.1 RQ10.1
Element: Approval Code This is a code to identify the approval RQ35.1 RQ500
process (levels) that a requisition has RQIF.1
to pass before it can be picked or
purchased.
RAP-REQ-NUMBER Numeric 7 IC83.1 RQ10.1
Element: Requisition NuThis is the assigned number to identify RQ35.1 RQ500
this requisition. RQIF.1
RAP-APRV-LEVEL Numeric 1 IC83.1 RQ10.1
Element: Approval LevelThis is the approval level number RQ35.1 RQ500
within the approval code at which this RQIF.1
requisition has to be approved.
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 RQ12.1
APPROVE-CD specific requisition number assigned a RQ35.1 RQ500
REQ-NUMBER specific authorization identifier and RQIF.1
approve code.
RAPSET2 COMPANY This index is used to access a IC83.1 RQ10.1
REQ-NUMBER requisition approval record for a RQ111 RQ12.1
APRV-LEVEL specific company requisition number by RQ13.1 RQ13.2
approval level. RQ44.2 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
|
