RQAPPROVE

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
RQ04.1


UPDATED BY
IC83.1 RQ02.1 RQ10.1 RQ111 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ44.2 RQ500 RQIF.1

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


RQAPPROVE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RAPSET1 COMPANY
AUTH-ID
APPROVE-CD
REQ-NUMBER
IC83.1 RQ02.1
RQ04.1 RQ10.1
RQ12.1 RQ35.1
RQ500 RQIF.1
RAPSET2 COMPANY
REQ-NUMBER
APRV-LEVEL
IC83.1 RQ10.1
RQ111 RQ12.1
RQ13.1 RQ13.2
RQ44.2 RQIF.1


RQAPPROVE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Req Lines REQLINE
RAP-COMPANY->RLN-COMPANY
RAP-REQ-NUMBER->RLN-REQ-NUMBER
  RLN-LINE-NBR


File created: Thu Jun 09 11:28:39 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.