Requester
This is the file of valid requesters. This file determines the approval hierarchy for the requester.
REFERENCED BY
| RQ04.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 |
|
||
| REQ-ACCT-UNIT-FLAG Element: Flag Num | Numeric 1 This field is used in indicate whether the accounting units in the RQACCTU table or the accounting units list are to be included or excluded from the ones the requester is allowed to enter. 0 = Include 1 = Exclude |
|
||
| REQ-PURCH-CLS-FLAG Element: Flag Num | Numeric 1 This indicates whether the purchase classes entered in RQPURCHCLS table are to be included or excluded in the ones the requester is allowed to enter. 0 = Include 1 = Exclude |
|
||
| REQ-ACCT-UNIT-LIST Element: Matrix List | Alpha 12 This is the account unit list used to include or exclude for a requester. |
|
||
| REQ-DISP-PROC-INFO Element: Flag1 | Alpha 1 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| REQSET1 |
COMPANY REQUESTER |
|
|||||||||
| REQSET2 |
REQUESTER |
|
|||||||||
| REQSET3 |
COMPANY REQ-LOCATION REQUESTER |
|
| ||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Approval Code | RQAPPCODE |
Required
| ||||||||||||
| Ic Company | ICCOMPANY |
Required
| ||||||||||||
| Mxlisthdr | MXLISTHDR |
Not Required
| ||||||||||||
| Req Location | RQLOC |
Required
| ||||||||||||
| Reqbod | REQBOD |
Not Required, Delete Cascades
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Acct Unit | RQACCTU |
Delete Cascades
| |||||||||||||||||||||||||||
| Purchase Class | RQPURCHCLS |
Delete Cascades
| |||||||||||||||||||||||||||
| Reqheader | REQHEADER |
| |||||||||||||||||||||||||||
| Rqreqaudit | RQREQAUDIT |
|
All trademarks and registered trademarks are the property of their
respective owners.