|
|
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
RQ204 RQ44.2 RQD1.1 RQIC.1 RQIF.1 RQIG.1
RQIH.1 WH130 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.4 API1.1
DR100 IC28.1 MA180 MA41.2 MA41.7 MA43.1
MA43.2 MA43.3 MA43.9 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 PO100
PO101 PO115 PO122 PO131 PO15.1 PO15.2
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO29.1 PO300 PO31.1 PO31.2 PO32.2 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 POI3.1 RQ02.1
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ111 RQ12.1
RQ35.1 RQ40.1 RQ500 RQIA.1 RQIB.1 RQID.1
RQIE.1 RQII.1 RQIJ.1 SEA2.1 WH20.2 WH20.7
RQ01.1
UPDATED BY
PO780 RQ04.1 RQ705
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REQ-COMPANY Numeric 4 RQ04.1
Element: Company The company number represents an
established company and is entered on
all function codes.
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: Location Code 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 RQ705
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 PO780 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 PO780 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
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 RQ204
RQ44.2 RQ705
RQD1.1 RQIC.1
RQIF.1 RQIG.1
RQIH.1 WH130
REQSET2 REQUESTER This index is used to access requester AP125 AP126
records by requester. AP131 AP20.1
KeyChange AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
...
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
|
