Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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    WH20.7    IC07.1

UPDATED BY

RQ04.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RQP-COMPANY          Numeric 4                                   RQ04.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.


RQP-REQUESTER        Alpha 10  (Lower Case)                      RQ04.1
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
Purch Major          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
Purch Minor          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
                                                                 RQ204   RQ35.1
                                                                 RQ500   RQIA.1
                                                                 RQIB.1  RQIC.1
                                                                 RQIF.1  RQIG.1
                                                                 RQIH.1  WH20.7

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