RQPURCHCLS

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
RQ204


UPDATED BY
DR100 IC07.1 IC141 IC142 IC83.1 ICIA.1
RQ04.1 RQ10.1 RQ10.3 RQ10.4 RQ11.1 RQ13.2
RQ35.1 RQ500 RQ504 RQIA.1 RQIB.1 RQIC.1
RQIF.1 RQIG.1 RQIH.1 RQII.1 RQIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQP-COMPANY
Element: Company		Numeric 4
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.
RQ04.1
RQP-REQUESTER
Element: Requester		Alpha 10 (Lower Case)
This is the person who is limited to entering items with only these purchasing classes on a requisition.
RQ04.1
RQP-PURCH-MAJOR
Element: Major Class		Alpha 4
RQ04.1
RQP-PURCH-MINOR
Element: Minor Class		Alpha 4
RQ04.1


RQPURCHCLS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQPSET1 COMPANY
REQUESTER
PURCH-MAJOR
PURCH-MINOR
DR100 IC141
IC142 IC83.1
ICIA.1 RQ04.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ204
RQ35.1 RQ500
RQ504 RQIA.1
RQIB.1 RQIC.1
RQIF.1 RQIG.1
RQIH.1 RQII.1
RQIJ.1
RQPSET2 COMPANY
PURCH-MAJOR
PURCH-MINOR
REQUESTER
IC07.1


RQPURCHCLS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:28:40 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.