Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

REQUESTER


                             REQUESTER FILE

                               Requester

This is the file of valid requesters. This file determines the approval
hierarchy for the requester.

REFERENCED BY

PO30.1    PO30.2    PO30.3    PO33.1    PO34.1    POIE.1
POII.1    POIJ.1    RQ10.1    RQ10.3    RQ10.2    RQ11.1
RQ13.2    RQ204     RQ35.1    RQ44.2    RQ500     RQD1.1
RQIB.1    RQIC.1    RQIF.1    RQIG.1    RQIH.1    RQII.1
RQIJ.1    WH130     AP125     AP126     AP131     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP21.1
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    AP30.4
API1.1    BL120     BL122     BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    IC02.1    MA180     MA41.1    MA41.2    MA41.4
MA41.7    MA43.1    MA43.2    MA43.3    MA43.7    MA530
MA531     MA60.2    MA60.3    MA60.5    MA61.1    MA66.2
MA66.3    MA67.2    MA67.3    MA68.2    MA68.3    MA68.5
MA70.1    MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2
PD130     PD20.1    PD20.2    PD20.3    PO100     PO101
PO115     PO122     PO131     PO15.1    PO15.2    PO20.1
PO21.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO23.1    PO24.1    PO25.1    PO25.5    PO25.6    PO25.7
PO27.2    PO29.1    PO300     PO31.1    PO31.2    PO32.2
PO32.4    PO35.1    PO36.1    PO36.2    PO38.1    PO39.1
PO39.2    PO44.1    PO50.1    PO52.1    PO520     PO536
POI3.1    POID.1    RQ02.1    RQ111     RQ12.1    RQ40.1
RQIA.1    RQID.1    WH20.2    WH20.7    RQ01.1

UPDATED BY

RQ04.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

REQ-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.

REQ-REQUESTER          Alpha 10  (Lower Case)                    RQ04.1
Element: Requester     This is the person, department, or area
                       that can place requisitions.

REQ-NAME               Alpha 30  (Lower Case)                    RQ04.1
Element: Name          This is the name or description of the
                       requester.

REQ-APPROVE-CD         Alpha 5                                   RQ04.1
Element: Approve Cd    This is a code to identify the approval
                       process (levels) that a requisition has
                       to pass before it can be picked or
                       purchased. Approval codes are defined in
                       RQ02.1 (Approval Codes). Each requester
                       is required to have an approval code
                       assigned to it. Depending on the total
                       amount of the order, the requisition may
                       need to be approved by the necessary
                       approval levels.

REQ-REQ-LOCATION       Alpha 5                                   RQ04.1
Element: Req Location  This is the location requesting the
                       items.  This can be an inventory
                       location defined in Location (IC02.1) or
                       a non-inventory location. Requesting
                       locations must be defined in Requesting
                       Locations (RQ01.1).  The requesting
                       location assigned to the requester can
                       be overridden when the requisition is
                       created.

REQ-ACTIVE-STATUS      Alpha 1                                   RQ04.1
Element: Active Status The status of the requester. If
                       Inactive, no requisitions can be added
                       by this requester.
                       A = Active
                       I = Inactive

REQ-MAN-OVER-ALWD      Alpha 1                                   RQ04.1
Element: Man Over Alwd If set to "Y", this field indicates
                       that unit costs manually entered for a
                       Requisition will be "held" when handed
                       off to the PO system, and not overridden
                       by the cost default routine.
                       Y = Yes
                       N = No

REQ-ENTRY-FL           Alpha 1                                   RQ04.1
Element: Entry Fl      1 = Item
                       2 = UPC
                       3 = UPN1
                       4 = UPN2
                       5 = NDC
                       6 = sku

REQ-OVER-AGRMT         Alpha 1                                   RQ04.1
Element: Over Agrmt    Enter a Y to indicate the user can
                       manually enter a cost which will not be
                        overridden by an existing price
                       agreement.
                       Y = Yes
                       N = No

REQ-OVER-LC-LP         Alpha 1                                   RQ04.1
Element: Over Lc Lp    Enter a Y to indicate the user can
                       manually enter a cost which will not be
                       overridden by a last cost or last PO
                       created cost default.

REQ-SET-DROPSHIP       Alpha 1                                   RQ04.1
Element: Set Dropship  Y = Yes
                       N = No

REQ-RQ-SEARCH-CAT      Numeric 1                                 RQ04.1
Element: Rq Search Cat

REQ-RQ-SHOP-LIST       Numeric 1                                 RQ04.1
Element: Rq Shop List

REQ-RQ-EXPRESS-ORD     Numeric 1                                 RQ04.1
Element: Rq Express Ord

REQ-RQ-SPEC-SERV       Numeric 1                                 RQ04.1
Element: Rq Spec Serv

REQ-RQ-GLOM            Numeric 1                                 RQ04.1
Element: Rq Glom

REQ-RQ-CATEGORIES      Numeric 1                                 RQ04.1
Element: Rq Categories

REQ-RQ-SELECT-ALL      Alpha 1
Element: Rq Select All D = Display
                       H = Hide
                       " " = Default from Company

REQ-CONTRACTS-ONLY     Alpha 1                                   RQ04.1
Element: Contracts Only

REQ-INTERNAL-ONLY      Alpha 1                                   RQ04.1
Element: Internal Only

REQ-MANUAL-FL          Alpha 1
Element: All Flag

REQ-PFLOW-APRV-FL      Alpha 1
Element: Pflow Aprv Fl Y = Yes
                       N = No

REQ-APPROVAL-TYPE      Alpha 1                                   RQ04.1
Element: Approval Type The type of approval record.
                       " " = Use value from ReqLoc or Comp
                       0 = Header approval-Approval codes
                       1 = Header approval-Process Flow
                       2 = Line approval
                       3 = No approval required

REQ-REQUIRE-VENDOR     Numeric 1                                 RQ04.1
Element: Require Vendor0 = No
                       1 = Yes

REQ-ADDR1              Alpha 30  (Lower Case)                    RQ04.1
Element: Addr1         This field contains the first line of
                       address information.

REQ-ADDR2              Alpha 30  (Lower Case)                    RQ04.1
Element: Addr1         This field contains the first line of
                       address information.

REQ-ADDR3              Alpha 30  (Lower Case)                    RQ04.1
Element: Addr1         This field contains the first line of
                       address information.

REQ-ADDR4              Alpha 30  (Lower Case)                    RQ04.1
Element: Addr1         This field contains the first line of
                       address information.

REQ-CITY-ADDR5         Alpha 18  (Lower Case)                    RQ04.1
Element: City          This field contains the city of the
                       address.

REQ-STATE-PROV         Alpha 2                                   RQ04.1
Element: State Prov    The state or province.

REQ-POSTAL-CODE        Alpha 10  (Lower Case)                    RQ04.1
Element: Postal Code   This field contains the postal code.

REQ-COUNTY             Alpha 25  (Lower Case)                    RQ04.1
Element: County        The county for the company address.

REQ-COUNTRY-CODE       Alpha 2                                   RQ04.1
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

REQ-PHONE-PREFIX       Alpha 6                                   RQ04.1
Element: Phone Prefix  The telephone number country code.

REQ-PHONE              Alpha 15                                  RQ04.1
Element: Phone         Phone number.

REQ-PHONE-EXT          Alpha 5                                   RQ04.1
Element: Phone Ext     This field contains the telephone
                       extension number.

REQ-FAX-PREFIX         Alpha 6                                   RQ04.1
Element: Phone Prefix  The telephone number country code.

REQ-FAX-NUMBER         Alpha 15                                  RQ04.1
Element: Phone         Phone number.

REQ-FAX-EXT            Alpha 5                                   RQ04.1
Element: Phone Ext     This field contains the telephone
                       extension number.

REQ-EMAIL-ADDRESS      Alpha 60  (Lower Case)                    RQ04.1
Element: Email Address e-mail address.

REQ-OVER-1SRC-1PO      Numeric 1                                 RQ04.1
Element: Over 1src 1po 0 = Override Allowed
                       1 = Override Not Allowed

REQ-REQ-COMM-CODE      Numeric 1                                 RQ04.1
Element: Req Comm Code 0 = Commodity Code Not Required
                       1 = Commodity Code Required

REQ-PCARD-NBR          Alpha 16
Element: Pcard Nbr

REQ-OVER-PCARD         Numeric 1
Element: Over Pcard

                         REQUESTER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

REQSET1   COMPANY                                                PO30.1  PO33.1
          REQUESTER                                              PO34.1  POIE.1
                                                                 POII.1  POIJ.1
                                                                 RQ04.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ13.2  RQ204
                                                                 RQ35.1  RQ44.2
                                                                 RQ500   RQD1.1
                                                                 RQIB.1  RQIC.1
                                                                 RQIF.1  RQIG.1
                                                                 RQIH.1  RQII.1
                                                                 RQIJ.1  WH130

REQSET2   REQUESTER     KeyChange                                AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC02.1
                                                                 ...

REQSET3   COMPANY       KeyChange                                RQ01.1
          REQ-LOCATION
          REQUESTER

                         REQUESTER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Approval Code  RQAPPCODE    Required

                            REQ-COMPANY         -> RAC-COMPANY
                            REQ-APPROVE-CD      -> RAC-APPROVE-CD

Ic Company     ICCOMPANY    Required

                            REQ-COMPANY         -> ICC-COMPANY

Req Location   RQLOC        Required
                            When REQ-REQ-LOCATION != Spaces

                            REQ-COMPANY         -> RQL-COMPANY
                            REQ-REQ-LOCATION    -> RQL-REQ-LOCATION

                         REQUESTER FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Unit      RQACCTU      Delete Cascades

                            REQ-COMPANY         -> RQU-COMPANY
                            REQ-REQUESTER       -> RQU-REQUESTER
                                                   RQU-ACCT-UNIT

Purchase Class RQPURCHCLS   Delete Cascades

                            REQ-COMPANY         -> RQP-COMPANY
                            REQ-REQUESTER       -> RQP-REQUESTER
                                                   RQP-PURCH-MAJOR
                                                   RQP-PURCH-MINOR

Reqheader      REQHEADER

                            REQ-REQUESTER       -> RQH-REQUESTER
                                                   RQH-REQ-NUMBER
                                                   RQH-COMPANY