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 RQ204
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 RQ204
PURCH-MINOR
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
|
