|
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
RQ10.1 RQ12.1 RQ35.1 RQ500 RQIF.1 RQ13.1
RQ13.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RAP-COMPANY Numeric 4 RQ10.1 RQ35.1
Element: Company Identifies the AP company if the RQ500 RQIF.1
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
RAP-AUTH-ID Alpha 10 RQ10.1 RQ35.1
Element: Auth Id This is the authorization identifier RQ500 RQIF.1
for the approver to access the
requisitions that need approving at this
level.
RAP-APPROVE-CD Alpha 5 RQ10.1 RQ35.1
Element: Approve Cd This is a code to identify the approval RQ500 RQIF.1
process (levels) that a requisition has
to pass before it can be picked or
purchased.
RAP-REQ-NUMBER Numeric 7 RQ10.1 RQ35.1
Element: Req Number This is the assigned number to identify RQ500 RQIF.1
this requisition.
RAP-APRV-LEVEL Numeric 1 RQ10.1 RQ35.1
Element: Aprv Level This is the approval level number RQ500 RQIF.1
within the approval code at which this
requisition has to be approved.
RQAPPROVE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RAPSET1 COMPANY RQ02.1 RQ10.1
AUTH-ID RQ12.1 RQ35.1
APPROVE-CD RQ500 RQIF.1
REQ-NUMBER
RAPSET2 COMPANY RQ10.1 RQ111
REQ-NUMBER RQ12.1 RQ13.1
APRV-LEVEL RQ13.2 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
|