RQPURCHCLS

Requesters 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 ICIA.1 RQ10.1
RQ10.3 RQ10.4 RQ10.5 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 IC07.1


UPDATED BY
RQ04.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 RQ10.5
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


RQPURCHCLS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Rqreqaudit RQREQAUDIT
RQP-COMPANY->RQA-COMPANY
RQP-REQUESTER->RQA-REQUESTER
RQP-PURCH-MAJOR->RQA-PURCH-MAJOR
RQP-PURCH-MINOR->RQA-PURCH-MINOR
Spaces->RQA-ACCT-UNIT
Zeroes->RQA-DIST-COMPANY
  RQA-DATE
  RQA-TIME
  RQA-FLD-NBR

File created: Thu Jun 09 02:32:09 2016

Home
Contact Us



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