|
|
RQPURCHCLS FILE
Requester's Purchasing Classes
This file contains the list of valid purchasing major classes that a
requester can enter items for on a requisition.
REFERENCED BY
DR100 IC141 IC142 IC83.1 RQ10.1 RQ10.3
RQ11.1 RQ13.2 RQ204 RQ35.1 RQ500 RQIA.1
RQIB.1 RQIC.1 RQIF.1 RQIG.1 RQIH.1 RQII.1
RQIJ.1 IC07.1
UPDATED BY
RQ04.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQP-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.
RQP-REQUESTER Alpha 10 (Lower Case) RQ04.1
Element: Requester This is the person who is limited to
entering items with only these
purchasing classes on a requisition.
RQP-PURCH-MAJOR Alpha 4 RQ04.1
Element: Major Class This is the purchasing major class
code. This field is user defined in the
Inventory Control system. Entering this
field will limit the requester to
ordering only items within this major
class.
RQP-PURCH-MINOR Alpha 4 RQ04.1
Element: Minor Class This is the purchasing minor class
code. This code is user defined in the
Inventory Control system. Entering a
value in this field will limit the
requester to ordering only items within
this minor class within the major class.
RQPURCHCLS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQPSET1 COMPANY This index is used to access purchasing DR100 IC141
REQUESTER class records for requester. IC142 IC83.1
PURCH-MAJOR RQ04.1 RQ10.1
PURCH-MINOR RQ10.3 RQ11.1
RQ13.2 RQ204
RQ35.1 RQ500
RQIA.1 RQIB.1
RQIC.1 RQIF.1
RQIG.1 RQIH.1
RQII.1 RQIJ.1
RQPSET2 COMPANY IC07.1
PURCH-MAJOR
PURCH-MINOR
REQUESTER
RQPURCHCLS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
RQP-COMPANY -> ICC-COMPANY
Purch Major MAJORCL Required
ICC-ITEM-GROUP -> MAJ-ITEM-GROUP
"P" -> MAJ-CLASS-TYPE
RQP-PURCH-MAJOR -> MAJ-MAJOR-CLASS
Purch Minor MINORCL Required
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"P" -> MIN-CLASS-TYPE
RQP-PURCH-MAJOR -> MIN-MAJOR-CLASS
RQP-PURCH-MINOR -> MIN-MINOR-CLASS
|
