REQUESTER – Requester

System
Requisitions (RQ)
Prefix
REQ
Primary key
COMPANY, REQUESTER
Fields
49
Updated by
1 program
Referenced by
245 programs

REQUESTER is the Requester table in Lawson Requisitions (prefix REQ). It is indexed by COMPANY, REQUESTER (REQSET1); alternate indexes: REQSET2 and REQSET3. It is related 1:1 to RQAPPCODE, ICCOMPANY, MXLISTHDR, RQLOC and REQBOD and 1:M to RQACCTU, RQPURCHCLS, REQHEADER and RQREQAUDIT. It is updated by RQ04.1 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 237 more. The table has 49 fields, 3 indexes and 9 documented relations.

About REQUESTER

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

Fields (49)

Column = COBOL field name without the REQ- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
REQ-COMPANY PK
COMPANY		Numeric 4Identifies 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
REQ-REQUESTER PK
REQUESTER		Alpha 10 (Lower Case)This is the person, department, or area that can place requisitions.RQ04.1
REQ-NAME
NAME		Alpha 30 (Lower Case)This is the name or description of the requester.RQ04.1
REQ-APPROVE-CD
APPROVE_CD		Alpha 5This 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.RQ04.1
REQ-REQ-LOCATION
REQ_LOCATION		Alpha 5This 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.RQ04.1
REQ-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of the requester. If Inactive, no requisitions can be added by this requester.
  • A Active
  • I Inactive
RQ04.1
REQ-MAN-OVER-ALWD
MAN_OVER_ALWD		Alpha 1If 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
RQ04.1
REQ-ENTRY-FL
ENTRY_FL		Alpha 1—
  • 1 Item
  • 2 UPC
  • 3 UPN1
  • 4 UPN2
  • 5 NDC
  • 6 sku
RQ04.1
REQ-OVER-AGRMT
OVER_AGRMT		Alpha 1Enter 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
RQ04.1
REQ-OVER-LC-LP
OVER_LC_LP		Alpha 1Enter 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.RQ04.1
REQ-SET-DROPSHIP
SET_DROPSHIP		Alpha 1—
  • Y Yes
  • N No
RQ04.1
REQ-RQ-SEARCH-CAT
RQ_SEARCH_CAT		Numeric 1—RQ04.1
REQ-RQ-SHOP-LIST
RQ_SHOP_LIST		Numeric 1—RQ04.1
REQ-RQ-EXPRESS-ORD
RQ_EXPRESS_ORD		Numeric 1—RQ04.1
REQ-RQ-SPEC-SERV
RQ_SPEC_SERV		Numeric 1—RQ04.1
REQ-RQ-GLOM
RQ_GLOM		Numeric 1—RQ04.1
REQ-RQ-CATEGORIES
RQ_CATEGORIES		Numeric 1—RQ04.1
REQ-RQ-SELECT-ALL
RQ_SELECT_ALL		Alpha 1" " = Default from Company
  • D Display
  • H Hide
—
REQ-CONTRACTS-ONLY
CONTRACTS_ONLY		Alpha 1" " = Default to Company Level
  • Y Yes
  • N No
  • I IC12 Setup
RQ04.1
REQ-INTERNAL-ONLY
INTERNAL_ONLY		Alpha 1" " = Default to Company Level
  • Y Yes
  • N No
  • I IC12 Setup
RQ04.1
REQ-MANUAL-FL
MANUAL_FL		Alpha 1——
REQ-PFLOW-APRV-FL
PFLOW_APRV_FL		Alpha 1—
  • Y Yes
  • N No
—
REQ-APPROVAL-TYPE
APPROVAL_TYPE		Alpha 1The 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
RQ04.1
REQ-REQUIRE-VENDOR
REQUIRE_VENDOR		Numeric 1—
  • 0 No
  • 1 Yes
RQ04.1
REQ-ADDR1
ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.RQ04.1
REQ-ADDR2
ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.RQ04.1
REQ-ADDR3
ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.RQ04.1
REQ-ADDR4
ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.RQ04.1
REQ-CITY-ADDR5
CITY_ADDR5		Alpha 18 (Lower Case)This field contains the city of the address.RQ04.1
REQ-STATE-PROV
STATE_PROV		Alpha 2The state or province.RQ04.1
REQ-POSTAL-CODE
POSTAL_CODE		Alpha 10 (Lower Case)This field contains the postal code.RQ04.1
REQ-COUNTY
COUNTY		Alpha 25 (Lower Case)The county for the company address.RQ04.1
REQ-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).RQ04.1
REQ-PHONE-PREFIX
PHONE_PREFIX		Alpha 6The telephone number country code.RQ04.1
REQ-PHONE
PHONE		Alpha 15Phone number.RQ04.1
REQ-PHONE-EXT
PHONE_EXT		Alpha 5This field contains the telephone extension number.RQ04.1
REQ-FAX-PREFIX
FAX_PREFIX		Alpha 6The telephone number country code.RQ04.1
REQ-FAX-NUMBER
FAX_NUMBER		Alpha 15Phone number.RQ04.1
REQ-FAX-EXT
FAX_EXT		Alpha 5This field contains the telephone extension number.RQ04.1
REQ-EMAIL-ADDRESS
EMAIL_ADDRESS		Alpha 60 (Lower Case)e-mail address.RQ04.1
REQ-OVER-1SRC-1PO
OVER_1SRC_1PO		Numeric 1—
  • 0 Override Allowed
  • 1 Override Not Allowed
RQ04.1
REQ-REQ-COMM-CODE
REQ_COMM_CODE		Numeric 1—
  • 0 Commodity Code Not Required
  • 1 Commodity Code Required
RQ04.1
REQ-PCARD-NBR
PCARD_NBR		Alpha 16——
REQ-OVER-PCARD
OVER_PCARD		Numeric 1——
REQ-SET-PO-BILL-TO
SET_PO_BILL_TO		Alpha 1—RQ04.1
REQ-ACCT-UNIT-FLAG
ACCT_UNIT_FLAG		Numeric 1This field is used in indicate whether the accounting units in the RQACCTU table or the accounting units list are to be included or excluded from the ones the requester is allowed to enter.
  • 0 Include
  • 1 Exclude
—
REQ-PURCH-CLS-FLAG
PURCH_CLS_FLAG		Numeric 1This indicates whether the purchase classes entered in RQPURCHCLS table are to be included or excluded in the ones the requester is allowed to enter.
  • 0 Include
  • 1 Exclude
—
REQ-ACCT-UNIT-LIST
ACCT_UNIT_LIST		Alpha 12This is the account unit list used to include or exclude for a requester.—
REQ-DISP-PROC-INFO
DISP_PROC_INFO		Alpha 1—RQ04.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
REQSET1COMPANY, REQUESTERPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
REQSET2REQUESTERKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
REQSET3COMPANY, REQ-LOCATION, REQUESTERKeyChangeRQ01.1

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
Approval CodeRQAPPCODERequiredREQ-COMPANY → RAC-COMPANY, REQ-APPROVE-CD → RAC-APPROVE-CD
Ic CompanyICCOMPANYRequiredREQ-COMPANY → ICC-COMPANY
MxlisthdrMXLISTHDRNot RequiredValid When REQ-ACCT-UNIT-LIST != Spaces"ACCTU" → MLH-OBJ-TYPE, REQ-ACCT-UNIT-LIST → MLH-MATRIX-LIST
Req LocationRQLOCRequiredWhen REQ-REQ-LOCATION != SpacesREQ-COMPANY → RQL-COMPANY, REQ-REQ-LOCATION → RQL-REQ-LOCATION
ReqbodREQBODNot Required, Delete CascadesREQ-COMPANY → RBA-COMPANY, REQ-REQUESTER → RBA-REQUESTER

One to many (4) — child tables

RelationTableRulesConditionField map
Acct UnitRQACCTUDelete CascadesREQ-COMPANY → RQU-COMPANY, REQ-REQUESTER → RQU-REQUESTER, → RQU-ACCT-UNIT, → RQU-DIST-COMPANY
Purchase ClassRQPURCHCLSDelete CascadesREQ-COMPANY → RQP-COMPANY, REQ-REQUESTER → RQP-REQUESTER, → RQP-PURCH-MAJOR, → RQP-PURCH-MINOR
ReqheaderREQHEADERREQ-REQUESTER → RQH-REQUESTER, → RQH-REQ-NUMBER, → RQH-COMPANY
RqreqauditRQREQAUDITREQ-COMPANY → RQA-COMPANY, REQ-REQUESTER → RQA-REQUESTER, Spaces → RQA-PURCH-MAJOR, Spaces → RQA-PURCH-MINOR, Spaces → RQA-ACCT-UNIT, Zeroes → RQA-DIST-COMPANY, → RQA-DATE, → RQA-TIME, → RQA-FLD-NBR

Programs

Updated by (1)

Referenced by (245)