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 RQ204 RQ35.1 RQ500 RQIA.1 RQIB.1
RQIC.1 RQIF.1 RQIG.1 RQIH.1 WH20.7 IC07.1
UPDATED BY
RQ04.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQP-COMPANY Numeric 4 RQ04.1
Company The company number represents an
established company and is entered on
all function codes.
RQP-REQUESTER Alpha 10 (Lower Case) RQ04.1
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
Purch Major 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
Purch Minor 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
RQ204 RQ35.1
RQ500 RQIA.1
RQIB.1 RQIC.1
RQIF.1 RQIG.1
RQIH.1 WH20.7
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
|
