|
|
REQUESTER FILE
Requester
This is the file of valid requesters. This file determines the approval
hierarchy for the requester.
REFERENCED BY
DR100 IC141 IC142 IC83.1 PO30.1 RQ10.1
RQ10.3 RQ11.1 RQ20.1 RQ204 RQ35.1 RQ44.2
RQ500 RQ02.1 RQ111 RQ12.1 RQ120 RQ15.1
RQ215 RQ40.1 SEA2.1 WH20.7
UPDATED BY
RQ04.1 RQ962
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REQ-COMPANY Numeric 4 RQ04.1 RQ962
Company The company number represents an
established company and is entered on
all function codes.
REQ-REQUESTER Alpha 10 (Lower Case) RQ04.1 RQ962
Requester This is the person, department, or area
who can place requisitions.
REQ-NAME Alpha 30 (Lower Case) RQ04.1 RQ962
Name This is the name or description of the
requester.
REQ-APPROVE-CD Alpha 5 RQ04.1 RQ962
Approval Code This is a code to identify the approval
process (levels) that a requisition has
to pass before it can be picked or
purchased. Approval codes are defined in
RQ02.1 (Approval Codes). Each requester
is required to have an approval code
assigned to it. Depending on the total
amount of the order, the requisition may
need to be approved by the necessary
approval levels.
REQ-REQ-LOCATION Alpha 5 RQ04.1 RQ962
To Location This is the location requesting the
items. This can be an inventory
location defined in IC02.1 (Location) or
a noninventory location. Requesting
location must be defined in RQ01.1
(Requesting Locations). The requesting
location assigned to the requester can
be overridden when the requisition is
created.
REQ-ACTIVE-STATUS Alpha 1 RQ04.1 RQ962
Status The status of the requester. If
Inactive, no requisitions can be added
by this requester.
A = Active
I = Inactive
REQUESTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
REQSET1 COMPANY This index is used to access the record DR100 IC141
REQUESTER for a specific company requester. IC142 IC83.1
PO30.1 RQ04.1
RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ204 RQ35.1
RQ44.2 RQ500
REQSET2 REQUESTER This index is used to access requester DR100 IC141
records by requester. IC142 IC83.1
KeyChange RQ02.1 RQ04.1
RQ10.1 RQ10.3
RQ11.1 RQ111
RQ12.1 RQ120
RQ15.1 RQ20.1
RQ215 RQ35.1
RQ40.1 RQ500
SEA2.1 WH20.7
REQUESTER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Approval Code RQAPPCODE Required
REQ-COMPANY -> RAC-COMPANY
REQ-APPROVE-CD -> RAC-APPROVE-CD
Ic Company ICCOMPANY Required
REQ-COMPANY -> ICC-COMPANY
Req Location RQLOC Required
When REQ-REQ-LOCATION != Spaces
REQ-COMPANY -> RQL-COMPANY
REQ-REQ-LOCATION -> RQL-REQ-LOCATION
User WFUSRPROFL Not Required
REQ-REQUESTER -> WFU-USER
REQUESTER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Unit RQACCTU Delete Cascades
REQ-COMPANY -> RQU-COMPANY
REQ-REQUESTER -> RQU-REQUESTER
RQU-ACCT-UNIT
Purchase Class RQPURCHCLS Delete Cascades
REQ-COMPANY -> RQP-COMPANY
REQ-REQUESTER -> RQP-REQUESTER
RQP-PURCH-MAJOR
RQP-PURCH-MINOR
|