Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RQPURCHCLS


                            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    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   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
Element: Minor Class   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  RQ10.1
          PURCH-MINOR                                            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

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