REQUESTER

Requester

This is the file of valid requesters. This file determines the approval hierarchy for the requester.

REFERENCED BY
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 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1 PO15.1 PO15.2 PO15.4


UPDATED BY
RQ01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REQ-COMPANY
Element: Company
Numeric 4
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
Element: Requester
Alpha 10 (Lower Case)
This is the person, department, or area that can place requisitions.
REQ-NAME
Element: Name
Alpha 30 (Lower Case)
This is the name or description of the requester.
REQ-APPROVE-CD
Element: Approve Cd
Alpha 5
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
Element: Req Location
Alpha 5
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
Element: Active Status
Alpha 1
The status of the requester. If Inactive, no requisitions can be added by this requester.
A = Active
I = Inactive
REQ-MAN-OVER-ALWD
Element: Man Over Alwd
Alpha 1
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
Element: Entry Fl
Alpha 1

1 = Item
2 = UPC
3 = UPN1
4 = UPN2
5 = NDC
6 = sku
REQ-OVER-AGRMT
Element: Over Agrmt
Alpha 1
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
Element: Over Lc Lp
Alpha 1
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
Element: Set Dropship
Alpha 1

Y = Yes
N = No
REQ-RQ-SEARCH-CAT
Element: Rq Search Cat
Numeric 1
REQ-RQ-SHOP-LIST
Element: Rq Shop List
Numeric 1
REQ-RQ-EXPRESS-ORD
Element: Rq Express Ord
Numeric 1
REQ-RQ-SPEC-SERV
Element: Rq Spec Serv
Numeric 1
REQ-RQ-GLOM
Element: Rq Glom
Numeric 1
REQ-RQ-CATEGORIES
Element: Rq Categories
Numeric 1
REQ-RQ-SELECT-ALL
Element: Rq Select All
Alpha 1

D = Display
H = Hide
" " = Default from Company
REQ-CONTRACTS-ONLY
Element: Contracts Only
Alpha 1

" " = Default to Company Level
Y = Yes
N = No
I = IC12 Setup
REQ-INTERNAL-ONLY
Element: Internal Only
Alpha 1

" " = Default to Company Level
Y = Yes
N = No
I = IC12 Setup
REQ-MANUAL-FL
Element: All Flag
Alpha 1
REQ-PFLOW-APRV-FL
Element: Pflow Aprv Fl
Alpha 1

Y = Yes
N = No
REQ-APPROVAL-TYPE
Element: Approval Type
Alpha 1
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
Element: Require Vendor
Numeric 1

0 = No
1 = Yes
REQ-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
REQ-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
REQ-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
REQ-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
REQ-CITY-ADDR5
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
REQ-STATE-PROV
Element: State Prov
Alpha 2
The state or province.
REQ-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal code.
REQ-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
REQ-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
REQ-PHONE-PREFIX
Element: Phone Prefix
Alpha 6
The telephone number country code.
REQ-PHONE
Element: Phone
Alpha 15
Phone number.
REQ-PHONE-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number.
REQ-FAX-PREFIX
Element: Phone Prefix
Alpha 6
The telephone number country code.
REQ-FAX-NUMBER
Element: Phone
Alpha 15
Phone number.
REQ-FAX-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number.
REQ-EMAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
e-mail address.
REQ-OVER-1SRC-1PO
Element: Over 1src 1po
Numeric 1

0 = Override Allowed
1 = Override Not Allowed
REQ-REQ-COMM-CODE
Element: Req Comm Code
Numeric 1

0 = Commodity Code Not Required
1 = Commodity Code Required
REQ-PCARD-NBR
Element: Pcard Nbr
Alpha 16
REQ-OVER-PCARD
Element: Over Pcard
Numeric 1
REQ-SET-PO-BILL-TO
Element: All Flag
Alpha 1


REQUESTER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
REQSET1 COMPANY
REQUESTER
...
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
REQSET3 COMPANY
REQ-LOCATION
REQUESTER
KeyChange
RQ01.1


REQUESTER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Reqheader REQHEADER
REQ-REQUESTER->RQH-REQUESTER
  RQH-REQ-NUMBER
  RQH-COMPANY


File created: Wed Jun 08 20:51:35 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.