|
|
REQUESTER FILE
Requester
This is the file of valid requesters. This file determines the approval
hierarchy for the requester.
REFERENCED BY
PO30.1 PO30.2 PO30.3 PO33.1 PO34.1 POIE.1
POII.1 POIJ.1 RQ10.1 RQ10.3 RQ10.2 RQ11.1
RQ13.2 RQ204 RQ35.1 RQ44.2 RQ500 RQD1.1
RQIB.1 RQIC.1 RQIF.1 RQIG.1 RQIH.1 RQII.1
RQIJ.1 WH130 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.4
API1.1 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 IC02.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.7 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA66.3 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PO100 PO101
PO115 PO122 PO131 PO15.1 PO15.2 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO300 PO31.1 PO31.2 PO32.2
PO32.4 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
POI3.1 POID.1 RQ02.1 RQ111 RQ12.1 RQ40.1
RQIA.1 RQID.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
that 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: Approve Cd 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: Req Location This is the location requesting the
items. This can be an inventory
location defined in Location (IC02.1) or
a non-inventory location. Requesting
locations must be defined in Requesting
Locations (RQ01.1). The requesting
location assigned to the requester can
be overridden when the requisition is
created.
REQ-ACTIVE-STATUS Alpha 1 RQ04.1
Element: Active 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
REQ-REQUIRE-VENDOR Numeric 1 RQ04.1
Element: Require Vendor0 = No
1 = Yes
REQ-ADDR1 Alpha 30 (Lower Case) RQ04.1
Element: Addr1 This field contains the first line of
address information.
REQ-ADDR2 Alpha 30 (Lower Case) RQ04.1
Element: Addr1 This field contains the first line of
address information.
REQ-ADDR3 Alpha 30 (Lower Case) RQ04.1
Element: Addr1 This field contains the first line of
address information.
REQ-ADDR4 Alpha 30 (Lower Case) RQ04.1
Element: Addr1 This field contains the first line of
address information.
REQ-CITY-ADDR5 Alpha 18 (Lower Case) RQ04.1
Element: City This field contains the city of the
address.
REQ-STATE-PROV Alpha 2 RQ04.1
Element: State Prov The state or province.
REQ-POSTAL-CODE Alpha 10 (Lower Case) RQ04.1
Element: Postal Code This field contains the postal code.
REQ-COUNTY Alpha 25 (Lower Case) RQ04.1
Element: County The county for the company address.
REQ-COUNTRY-CODE Alpha 2 RQ04.1
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
REQ-PHONE-PREFIX Alpha 6 RQ04.1
Element: Phone Prefix The telephone number country code.
REQ-PHONE Alpha 15 RQ04.1
Element: Phone Phone number.
REQ-PHONE-EXT Alpha 5 RQ04.1
Element: Phone Ext This field contains the telephone
extension number.
REQ-FAX-PREFIX Alpha 6 RQ04.1
Element: Phone Prefix The telephone number country code.
REQ-FAX-NUMBER Alpha 15 RQ04.1
Element: Phone Phone number.
REQ-FAX-EXT Alpha 5 RQ04.1
Element: Phone Ext This field contains the telephone
extension number.
REQ-EMAIL-ADDRESS Alpha 60 (Lower Case) RQ04.1
Element: Email Address e-mail address.
REQ-OVER-1SRC-1PO Numeric 1 RQ04.1
Element: Over 1src 1po 0 = Override Allowed
1 = Override Not Allowed
REQ-REQ-COMM-CODE Numeric 1 RQ04.1
Element: Req Comm Code 0 = Commodity Code Not Required
1 = Commodity Code Required
REQ-PCARD-NBR Alpha 16
Element: Pcard Nbr
REQ-OVER-PCARD Numeric 1
Element: Over Pcard
REQUESTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
REQSET1 COMPANY PO30.1 PO33.1
REQUESTER PO34.1 POIE.1
POII.1 POIJ.1
RQ04.1 RQ10.1
RQ10.3 RQ11.1
RQ13.2 RQ204
RQ35.1 RQ44.2
RQ500 RQD1.1
RQIB.1 RQIC.1
RQIF.1 RQIG.1
RQIH.1 RQII.1
RQIJ.1 WH130
REQSET2 REQUESTER KeyChange AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC02.1
...
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
|
