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 RQ12.1 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
all function codes.
RAP-AUTH-ID Alpha 10 DR100 IC141
Authorization This is the authorization identifier IC142 IC83.1
Identification for the approver to access the
requisitions that need approving at this
level.
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
to pass before it can be picked or
purchased.
RAP-REQ-NUMBER Numeric 7 DR100 IC141
Requisition Number This is the assigned number to identify IC142 IC83.1
this requisition.
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
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 DR100 IC141
AUTH-ID requisition approval record for a IC142 IC83.1
APPROVE-CD specific requisition number assigned a RQ02.1 RQ12.1
REQ-NUMBER specific authorization identifier and
approve code.
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 RQ111 RQ12.1
approval level. RQ13.1 RQ44.2
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
|
