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 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 The company number represents an
established company and is entered on
all function codes.
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
RQP-PURCH-MINOR Alpha 4 RQ04.1
Element: Minor 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 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
|
