REQUESTER FILE
Requester
This is the file of valid requesters. This file determines the approval
hierarchy for the requester.
REFERENCED BY
IC83.1 POIJ.1 RQ204 RQ40.1 RQ44.2 WH130
DR100 IC141 IC142 PO15.1 PO15.2 RQ02.1
RQ11.1 RQ111 RQ12.1 SEA2.1
UPDATED BY
PO780 RQ04.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REQ-COMPANY Numeric 4 RQ04.1
Company The company number represents an
established company and is entered on
all function codes.
REQ-REQUESTER Alpha 10 (Lower Case) RQ04.1
Requester This is the person, department, or area
who can place requisitions.
REQ-NAME Alpha 30 (Lower Case) RQ04.1
Name This is the name or description of the
requester.
REQ-APPROVE-CD Alpha 5 RQ04.1
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
To Location This is the location requesting the
items. This can be an inventory
location defined in IC02 (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
Status The status of the requester. If
Inactive, no requisitions can be added
by this requester.
A = Active
I = Inactive
REQ-MAN-OVER-ALWD Alpha 1
Man Over Alwd If set to "Y", this field indicates
that unit costs manually entered for a
Requisition will be "held" when handed
off to the PO system, and not overridden
by the cost default routine.
Y = Yes
N = No
REQ-ENTRY-FL Alpha 1 RQ04.1
Entry Fl 1 = Item
2 = UPC
3 = UPN1
4 = UPN2
5 = NDC
6 = sku
REQ-OVER-AGRMT Alpha 1 PO780 RQ04.1
Over Agrmt Enter a Y to indicate the user can
manually enter a cost which will not be
overridden by an existing price
agreement.
REQ-OVER-LC-LP Alpha 1 PO780 RQ04.1
Over Lc Lp Enter a Y to indicate the user can
manually enter a cost which will not be
overridden by a last cost or last PO
created cost default.
REQ-SET-COST-OPT Alpha 1 PO780 RQ04.1
Set Cost Opt Enter a Y to indicate the user is
allowed to enter a cost option 2 (no
charge) or 3 (vendor determined).
REQ-SET-DROPSHIP Alpha 1
Set Dropship Y = Yes
N = No
REQ-RQ-SEARCH-CAT Numeric 1
Rq Search Cat
REQ-RQ-SHOP-LIST Numeric 1
Rq Shop List
REQ-RQ-EXPRESS-ORD Numeric 1
Rq Express Ord
REQ-RQ-SPEC-SERV Numeric 1
Rq Spec Serv
REQ-RQ-GLOM Numeric 1
Rq Glom
REQ-RQ-SELECT-ALL Alpha 1
Rq Select All
REQUESTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
REQSET1 COMPANY This index is used to access the record IC83.1 POIJ.1
REQUESTER for a specific company requester. RQ04.1 RQ204
RQ40.1 RQ44.2
WH130
REQSET2 REQUESTER This index is used to access requester DR100 IC141
records by requester. IC142 IC83.1
KeyChange PO15.1 PO15.2
PO780 POIJ.1
RQ02.1 RQ04.1
RQ11.1 RQ111
RQ12.1 SEA2.1
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
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
Reqheader REQHEADER
REQ-REQUESTER -> RQH-REQUESTER
RQH-REQ-NUMBER
RQH-COMPANY
|
