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