|
|
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
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
RQP-PURCH-MINOR Alpha 4 RQ04.1
Element: Minor Class
RQPURCHCLS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQPSET1 COMPANY RQ04.1 RQ10.1
REQUESTER RQ10.3 RQ11.1
PURCH-MAJOR RQ13.2 RQ204
PURCH-MINOR 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
|
