|
|
REQUESTER FILE
Requester
This is the file of valid requesters. This file determines the approval
hierarchy for the requester.
REFERENCED BY
IC141 IC142 IC83.1 PO23.1 PO30.1 PO30.2
PO30.3 PO33.1 PO34.1 POIE.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.3 RQ204 RQ35.1 RQ40.1
RQ44.2 RQ500 RQIC.1 RQIF.1 RQIG.1 RQIH.1
WH130 AP125 AP126 AP131 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 DR100 IC28.1 MA180
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE111 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.4 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE530 OE81.1
OE810 OE830 OE90.1 OE90.2 PO100 PO101
PO115 PO122 PO131 PO15.1 PO15.2 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO29.1
PO300 PO31.1 PO31.2 PO32.2 PO35.1 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
POI3.1 RQ02.1 RQ11.1 RQ111 RQ12.1 RQ13.2
RQIA.1 RQIB.1 RQID.1 RQII.1 RQIJ.1 WH20.2
WH20.7 RQ01.1
UPDATED BY
RQ04.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REQ-COMPANY Numeric 4 RQ04.1
Element: Company 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.
REQ-REQUESTER Alpha 10 (Lower Case) RQ04.1
Element: Requester This is the person, department, or area
who can place requisitions.
REQ-NAME Alpha 30 (Lower Case) RQ04.1
Element: Name This is the name or description of the
requester.
REQ-APPROVE-CD Alpha 5 RQ04.1
Element: 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
Element: 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
Element: 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 RQ04.1
Element: 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
Element: Entry Fl 1 = Item
2 = UPC
3 = UPN1
4 = UPN2
5 = NDC
6 = sku
REQ-OVER-AGRMT Alpha 1 RQ04.1
Element: Over Agrmt Enter a Y to indicate the user can
manually enter a cost which will not be
overridden by an existing price
agreement.
Y = Yes
N = No
REQ-OVER-LC-LP Alpha 1 RQ04.1
Element: 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-DROPSHIP Alpha 1 RQ04.1
Element: Set Dropship Y = Yes
N = No
REQ-RQ-SEARCH-CAT Numeric 1 RQ04.1
Element: Rq Search Cat
REQ-RQ-SHOP-LIST Numeric 1 RQ04.1
Element: Rq Shop List
REQ-RQ-EXPRESS-ORD Numeric 1 RQ04.1
Element: Rq Express Ord
REQ-RQ-SPEC-SERV Numeric 1 RQ04.1
Element: Rq Spec Serv
REQ-RQ-GLOM Numeric 1 RQ04.1
Element: Rq Glom
REQ-RQ-CATEGORIES Numeric 1 RQ04.1
Element: Rq Categories
REQ-RQ-SELECT-ALL Alpha 1
Element: Rq Select All D = Display
H = Hide
" " = Default from Company
REQ-CONTRACTS-ONLY Alpha 1 RQ04.1
Element: Contracts Only
REQ-INTERNAL-ONLY Alpha 1 RQ04.1
Element: Internal Only
REQ-MANUAL-FL Alpha 1
Element: All Flag
REQ-PFLOW-APRV-FL Alpha 1
Element: Pflow Aprv Fl Y = Yes
N = No
REQ-APPROVAL-TYPE Alpha 1 RQ04.1
Element: Approval Type The type of approval record.
" " = Use value from ReqLoc or Comp
0 = Header approval-Approval codes
1 = Header approval-Process Flow
2 = Line approval
3 = No approval required
REQUESTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
REQSET1 COMPANY This index is used to access the record IC141 IC142
REQUESTER for a specific company requester. IC83.1 PO23.1
PO30.1 PO33.1
PO34.1 POIE.1
POII.1 POIJ.1
RQ04.1 RQ10.1
RQ204 RQ35.1
RQ40.1 RQ44.2
RQ500 RQIC.1
RQIF.1 RQIG.1
RQIH.1 WH130
REQSET2 REQUESTER This index is used to access requester AP125 AP126
records by requester. AP131 AP25.1
KeyChange AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
...
REQSET3 COMPANY KeyChange RQ01.1
REQ-LOCATION
REQUESTER
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
|
