REQHEADER – Requisition Header

System
Requisitions (RQ)
Prefix
RQH
Primary key
COMPANY, REQ-NUMBER
Fields
134
Updated by
235 programs
Referenced by
48 programs

REQHEADER is the Requisition Header table in Lawson Requisitions (prefix RQH). It is indexed by COMPANY, REQ-NUMBER (RQHSET1); alternate indexes: RQHSET2, RQHSET3, RQHSET4, RQHSET5, RQHSET6, RQHSET7, RQHSET8 and RQHSET9. It is related 1:1 to RQAPPCODE, ICLOCATION, ICCOMPANY, MMUAVAL, PORQHUF, RQLOC, REQUESTER and RQHBOD and 1:M to RQAPPROVE, WHLOCRULE, REQLINE, RQAOCDTL and RQAUDIT. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 227 more and referenced by AM19.1, AM19.2, AP115, AP220, AP305, CX05.1, CX05.2, CX805 and 40 more. The table has 134 fields, 9 indexes and 13 documented relations.

About REQHEADER

This file contains the header information for each requisition.

Fields (134)

Column = COBOL field name without the RQH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#RQH-COMPANY PK
COMPANY		Numeric 4Enter the company number established in Company (IC01.1) or Company (MA01.1).DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-REQ-NUMBER PK
REQ_NUMBER		Numeric 7Requisition numbers are automatically assigned if the company is set up for automatic numbering in Company (IC01.1) or Company (MA01.1). Otherwise, requisition numbers are user defined. Automatically assigned requisition numbers are incremented by one from the last number used, as defined in IC01.1 or MA01.1.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-REQUESTER SET2 SET3 SET7
REQUESTER		Alpha 10 (Lower Case)This is the person, department, or area requesting items. Requesters are defined in Requesters (RQ04.1).DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-REQ-LOCATION SET2
REQ_LOCATION		Alpha 5This is the location requesting items. This location can be an inventory location defined in Location (IC02.1) or a non-inventory location. All requesting locations must be defined in Requesting Locations (RQ01.1). Requesting locations may be assigned to the requester in the Requesters (RQ04.1) Main tab. The requesting location defaults to the requisition based on the requester. You can override this with each requisition.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-REQ-DEL-DATE
REQ_DEL_DATE		Numeric 8 (yyyymmdd)This is the requested delivery date. If left blank, this field defaults to the system date. The requested delivery date is used to schedule backorder allocations (that is, requisitions with the oldest requisition delivery date having backorders are filled before later dated requisitions for the same item). You can override this date.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +15 more
#RQH-CREATION-DATE SET9
CREATION_DATE		Numeric 8 (yyyymmdd)This is the date that this line was added to the requisition.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-REFERENCE-NO SET5
REFERENCE_NO		Alpha 10 (Right Justified)—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-REQ-DESC SET6
REQ_DESC		Alpha 30 (Lower Case)—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-FROM-COMPANY SET4
FROM_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.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +14 more
#RQH-FROM-LOCATION SET4
FROM_LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DELIVER-TO
DELIVER_TO		Alpha 30 (Lower Case)This is additional information regarding where the requested items are to be delivered. This is a user-defined field that displays online and on the delivery ticket.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-BUYER-CODE
BUYER_CODE		Alpha 3The user defined buyer code defined in Buyer (PO04.1).DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-VENDOR
VENDOR		Alpha 9 (Right Justified)Enter the suggested vendor code for the requisition. The vendor code defaults to all subsequent requisition lines. The suggested vendor prints on the requisition when you run Print Requisitions (RQ111).The vendor can be changed when a purchase order is created. The vendor must be defined in Vendor (AP10.1).DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4Enter the suggested purchase from location for the entered vendor. Vendors can have multiple purchase from locations. The purchase from location code prints on the requisition when you run Print Requisitions (RQ111). As with the vendor code, the purchase from location can be changed when a purchase order is created for the requisition. The purchase from location code must be defined in Vendor Location (AP10.2).DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-VENDOR-NAME
VENDOR_NAME		Alpha 30Enter the recommended vendor's name for the requisition. If left blank, this defaults to the vendor's name defined in the Accounts Payable (AP) Vendor form.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-PRINT-REQ-FL
PRINT_REQ_FL		Alpha 1This flag indicates whether you want to print the requisition in RQ111 (Print Requisitions). This flag defaults based on the approval assigned to the requester. It can be overridden when the requisition is created. Once the requisition has been printed, this flag is changed to No, do not print the requisition. You can print the requisition after it has been printed by specifying the requisition in RQ111 (Print Requisitions).
  • N No
  • Y Yes
DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +14 more
#RQH-LAST-LINE-NBR
LAST_LINE_NBR		Numeric 6The number of the last line item added to the requisition. This number determines what the next line number is when you add another item.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-LAST-DEL-SEQ
LAST_DEL_SEQ		Numeric 3This field contains the record sequence number.DR100, IC141, IC142, IC83.1, PO30.1, PO30.2, PO30.3, PO30.4 +18 more
#RQH-RETURN-SEQ
RETURN_SEQ		Numeric 3This number indicates the number of times a return has been made against a requisition.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-STATUS SET4
STATUS		Numeric 1This is the processing status of the requisition as described below. in RQ10.1 (Requisition). released in RQ10.1 (Requisition). delivered or backorders are canceled. requisition. This closes the requisition, which cannot be reopened. fully approved.
  • Released Requisition has been released
  • Unreleased Requisition added but not
  • Closed Every requisition line is fully
  • Rejected The approver has rejected the
  • Processed The requisition has been
  • 0 Unreleased
  • 1 Released
  • 5 In Process
  • 9 Processed
  • 8 Rejected
DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.2 +17 more
#RQH-PO-USER-FLD-1
PO_USER_FLD_1		Alpha 1Purchase Order header user field one.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-PO-USER-FLD-3
PO_USER_FLD_3		Alpha 30Purchase Order header user field three.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-PO-USER-FLD-5
PO_USER_FLD_5		Alpha 30 (Lower Case)Purchase Order header user field five.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-USER-DATE-1
USER_DATE_1		Numeric 8 (yyyymmdd)This field displays the system date when this was created.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-USER-DATE-2
USER_DATE_2		Numeric 8 (yyyymmdd)This field displays the system date when this was created.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-LAST-APRV-DT
LAST_APRV_DT		Numeric 8 (yyyymmdd)This is the last approval date for the requisition. Requisitions are approved in RQ12.1 (Approval Review).DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +14 more
#RQH-APPROVED-FL
APPROVED_FL		Alpha 1This flag indicates that this requisition has been approved at all required approval levels. Required approval levels are defined by amount in RQ02.1 (Approval Codes).
  • N No
  • Y Yes
DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +14 more
#RQH-ATTAIN-LEVEL
ATTAIN_LEVEL		Numeric 1This is the highest approval level required for the requisition. The requisition must be approved at this level for further processing.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +14 more
#RQH-APRV-LEVEL
APRV_LEVEL		Numeric 1This is the approval level that this requisition has attained so far in RQ12.1 (Approval Review).DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +14 more
#RQH-NBR-LINES
NBR_LINES		Numeric 6This is the number of detail lines.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-CLOSED-LINES
CLOSED_LINES		Numeric 6This is the number of closed detail lines on the requisition. When the number of closed lines equals the number of lines, the requisition status is set to closed in RQ120 (Delivery Ticket).RQD1.1
#RQH-CLOSED-FL
CLOSED_FL		Alpha 1The Closed Flag.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQH-I-TOTAL
I_TOTAL		Signed 18.2—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-N-TOTAL
N_TOTAL		Signed 18.2—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-X-S-TOTAL
X_S_TOTAL		Signed 18.2—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-PRINTED-FL
PRINTED_FL		Alpha 1This flag indicates whether the requisition has been printed in RQ111 (Print Requisitions).DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +14 more
#RQH-ALLOC-PRI
ALLOC_PRI		Numeric 2This is the allocation priority for this requisition. Valid values are from 0 to 99, with 99 being the highest. This field defaults to 50. This field is used in the Warehouse module to determine the order in which inventory demand gets allocated.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-QUOTE-FL
QUOTE_FL		Alpha 1This flag indicates if the buyer should get quotes for this requisition before it is turned into a purchase order.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-RETURN-NOTE
RETURN_NOTE		Alpha 12This is a user defined field available for data entry in RQ35.1 (Requisition Returns).DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-RETURN-DATE
RETURN_DATE		Numeric 8 (yyyymmdd)This is the return transaction date for a requisition item processed in RQ35.1 (Requisition Returns).DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruDR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-BILL-CATEGORY
BILL_CATEGORY		Alpha 32—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-ACCT-UNIT
ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-ACCOUNT
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SUB-ACCT
SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DIST-COMPANY
DIST_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.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-ASSET
ASSET		Numeric 10The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-ASSET-TEMPLATE
ASSET_TEMPLATE		Alpha 10A user-defined asset template identifies general asset creation parameters that you can use to quickly add assets with minimal keying. Using a template lets you default many data items associated with a new asset. You can use an asset template to process quick asset additions in AM20.1 (Quick Addition) and to create assets and asset books from Accounts Payable and Activity Management interface information. Asset templates are required if you define new assets as a result of transactions interfaced from the Lawson Purchase Order or Accounts Payable systems.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-PURCH-TAX-CD
PURCH_TAX_CD		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-PURCH-TAX-FL
PURCH_TAX_FL		Alpha 1This field indicates if this item is taxable when it is purchased for this location. Valid values are:
  • N Nontaxable. Default value.
  • Y Taxable.
DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-OPERATOR-ID
OPERATOR_ID		Alpha 10This is the terminal signon identifier when this requisition was added to the database.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DROPSHIP-FL
DROPSHIP_FL		Alpha 1This flag indicates whether goods being shipped by the vendor directly to a non standard location need to have the receiving process performed.
  • Y Yes
  • N No
DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-NAME
SH_NAME		Alpha 30 (Lower Case)Displays the company description.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-ADDR1
SH_ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-ADDR2
SH_ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-ADDR3
SH_ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-ADDR4
SH_ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-CITY-ADDR5
SH_CITY_ADDR5		Alpha 18 (Lower Case)This field contains the city of the address.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-STATE-PROV
SH_STATE_PROV		Alpha 2The state or province.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-POST-CODE
SH_POST_CODE		Alpha 10 (Lower Case)This is the ship to mail code.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-COUNTRY-CD
SH_COUNTRY_CD		Alpha 2—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-COUNTRY
SH_COUNTRY		Alpha 30 (Lower Case)This field contains the country of the address, or it can be used for additional information such as an attention name.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-COUNTY
SH_COUNTY		Alpha 25 (Lower Case)The county for the company address.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-PHONE-PREF
SH_PHONE_PREF		Alpha 6The telephone number country code.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-PHONE
SH_PHONE		Alpha 15Phone number.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-PHONE-EXT
SH_PHONE_EXT		Alpha 5This field contains the telephone extension number.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-SH-CONTACT
SH_CONTACT		Alpha 30 (Lower Case)This is the name of the main contact.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-CAPITAL-TOTAL
CAPITAL_TOTAL		Signed 15.4——
#RQH-TECH-TOTAL
TECH_TOTAL		Signed 15.4——
#RQH-CAP-TECH-TOTAL
CAP_TECH_TOTAL		Signed 15.4——
#RQH-RECORD-SOURCE
RECORD_SOURCE		Numeric 2—
  • 01 RQ10
  • 02 E-Requisitions
  • 03 RQ500
  • 04 IC83
  • 05 IC142
—
#RQH-PFLOW-APRV-LVL
PFLOW_APRV_LVL		Alpha 20—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +14 more
#RQH-APPROVAL-TYPE
APPROVAL_TYPE		Alpha 1The type of approval record.
  • 0 Header approval-Approval codes
  • 1 Header approval-Process Flow
  • 2 Line approval
  • 3 No approval required
DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-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.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-BASE-CURR-CODE
BASE_CURR_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-TRAN-CURR-CODE
TRAN_CURR_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-POB-NAME
POB_NAME		Alpha 30 (Lower Case)Displays the company description.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-POB-ADDR1
POB_ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-POB-ADDR2
POB_ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-POB-ADDR3
POB_ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-POB-ADDR4
POB_ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-POB-CITY-ADDR5
POB_CITY_ADDR5		Alpha 18 (Lower Case)This field contains the city of the address.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-POB-STATE-PROV
POB_STATE_PROV		Alpha 2The state or province.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-POB-POSTAL-CD
POB_POSTAL_CD		Alpha 10 (Lower Case)This field contains the postal code.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-POB-COUNTRY-CD
POB_COUNTRY_CD		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-POB-COUNTY
POB_COUNTY		Alpha 25 (Lower Case)The county for the company address.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-POB-CONTACT
POB_CONTACT		Alpha 30 (Lower Case)This is the name of the main contact.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-RQ-SOURCE
RQ_SOURCE		Numeric 2—
  • 00 Upgrade
  • 01 IC142
  • 02 IC141
  • 03 IC83
  • 04 RQ35
  • 05 RQ500
  • 06 RQC
  • 07 RQ10
  • 08 DR100
  • 99 Mobile Requisitions
  • 97 Perfect Commerce
  • 98 SciQuest
DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-ONE-SRC-ONE-PO
ONE_SRC_ONE_PO		Numeric 10 1
  • 2 One Requisition to One PO
DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-PCARD-NBR
PCARD_NBR		Alpha 16——
#RQH-SS-EVENT-REQD
SS_EVENT_REQD		Numeric 1—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-APPROVAL-VAL
APPROVAL_VAL		DerivedThis field is a sum of the three item total fields (I Total, N Total, and S X Total amount fields). This value is the total value of the requisition. It is used for approval processing.—
#RQH-WF-CO-REQ-NBR
WF_CO_REQ_NBR		DerivedUsed for Enterprise Workflow drill around.—
#RQH-DER-STATUS
DER_STATUS		Derived——
#RQH-POB-PHONE-PREF
POB_PHONE_PREF		Alpha 6—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-POB-PHONE
POB_PHONE		Alpha 15—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-POB-PHONE-EXT
POB_PHONE_EXT		Alpha 5—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-POB-EMAIL-ADDR
POB_EMAIL_ADDR		Alpha 60 (Lower Case)—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-LOCATION-RULE
LOCATION_RULE		Alpha 12—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-RELEASED-DATE
RELEASED_DATE		Numeric 8 (yyyymmdd)—DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.2 +16 more
#RQH-RELEASED-TIME
RELEASED_TIME		Numeric 8—DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.2 +16 more
#RQH-REL-OPER-ID
REL_OPER_ID		Alpha 10—DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.2 +16 more
#RQH-APR-REJ-DATE
APR_REJ_DATE		Numeric 8 (yyyymmdd)—DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.2 +16 more
#RQH-APR-REJ-TIME
APR_REJ_TIME		Numeric 8—DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.2 +16 more
#RQH-APR-REJ-OPR-ID
APR_REJ_OPR_ID		Alpha 10—DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.2 +16 more
#RQH-PO-USER-FLD-7
PO_USER_FLD_7		Alpha 10 (Lower Case)——
#RQH-CREATION-TIME
CREATION_TIME		Numeric 8—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-CREATED-BY
CREATED_BY		Alpha 10—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ11.1, RQ13.2 +5 more
#RQH-LAST-UPDT-DATE SET9
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQH-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQH-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQH-DFLT-PAT-ID
DFLT_PAT_ID		Alpha 20—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-VISIT-NBR
DFLT_VISIT_NBR		Alpha 20—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-CASE-NBR
DFLT_CASE_NBR		Alpha 20—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-PROC
DFLT_PROC		Alpha 20—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-PROC-DATE
DFLT_PROC_DATE		Numeric 8 (yyyymmdd)—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-PHYS-NAME
DFLT_PHYS_NAME		Alpha 30—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-NRS-COORD
DFLT_NRS_COORD		Alpha 30—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-SALES-REP
DFLT_SALES_REP		Alpha 30—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-ORD-NBR
DFLT_ORD_NBR		Alpha 20—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-REQUESTOR
DFLT_REQUESTOR		Alpha 30—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-USERDEF1
DFLT_USERDEF1		Alpha 30—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-USERDEF2
DFLT_USERDEF2		Alpha 30—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-CN-CODE
DFLT_CN_CODE		Alpha 2—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-GLBL-DOC-TYPE
GLBL_DOC_TYPE		Alpha 10—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-LAST-NAME
DFLT_LAST_NAME		Alpha 60—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-FIRST-NM
DFLT_FIRST_NM		Alpha 60—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-MIDDLE-NM
DFLT_MIDDLE_NM		Alpha 60—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-BIRTHDATE
DFLT_BIRTHDATE		Numeric 8 (yyyymmdd)—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-GENDER
DFLT_GENDER		Alpha 1—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-SSN
DFLT_SSN		Alpha 20—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-DFLT-PROC-MOD
DFLT_PROC_MOD		Alpha 2—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
#RQH-AOC-TOTAL
AOC_TOTAL		Signed 18.2—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more

Indexes (9)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RQHSET1
  1. COMPANY
  2. REQ-NUMBER
PrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
RQHSET2
  1. COMPANY
  2. REQ-LOCATION
  3. REQUESTER
  4. REQ-NUMBER
KeyChangeDR100, IC141, RQ01.1, RQ111, RQ140, RQ260, RQ300, RQ40.1
RQHSET3
  1. REQUESTER
  2. REQ-NUMBER ↓
  3. COMPANY
IC83.1, RQ10.1, RQ35.1, RQ500, RQIF.1
RQHSET4
  1. FROM-COMPANY
  2. FROM-LOCATION
  3. STATUS
  4. COMPANY
  5. REQ-NUMBER
KeyChangeRQ41.1
RQHSET5
  1. COMPANY
  2. REFERENCE-NO
  3. REQ-NUMBER
KeyChange, SubsetWhere REFERENCE-NO != Spaces—
RQHSET6
  1. COMPANY
  2. REQ-DESC
  3. REQ-NUMBER
KeyChange, SubsetWhere REQ-DESC != Spaces—
RQHSET7
  1. REQUESTER
  2. REQ-NUMBER
  3. COMPANY
IC83.1, RQ04.1, RQ10.1, RQ500, RQCP.1, RQD1.1, RQIF.1, RQII.1 +1 more
RQHSET8
  1. COMPANY
  2. REQ-NUMBER
SubsetWhere STATUS = ZeroesRQ02.1
RQHSET9
  1. COMPANY
  2. REQ-NUMBER
  3. CREATION-DATE
  4. LAST-UPDT-DATE
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
RQAPPCODEICLOCATIONICCOMPANYMMUAVALPORQHUFRQLOCREQUESTERRQHBODRQAPPROVEWHLOCRULEREQLINERQAOCDTLRQAUDITREQHEADER

One to one (8) — lookups and parents

RelationTableRulesConditionField map
Approve CodeRQAPPCODERequired
RQH-COMPANY→RAC-COMPANY (RACSET1)
REQ-APPROVE-CD→RAC-APPROVE-CD
From LocationICLOCATIONRequired
RQH-FROM-COMPANY→ICL-COMPANY
RQH-FROM-LOCATION→ICL-LOCATION
Ic CompanyICCOMPANYRequired
RQH-FROM-COMPANY→ICC-COMPANY
MmuavalMMUAVALNot Required
RQH-COMPANY→MUA-COMPANY
"RQ"→MUA-SYSTEM-CD
RQH-FROM-LOCATION→MUA-LOCATION
"RQ"→MUA-DOC-TYPE
Spaces→MUA-DOC-NUMBER
RQH-REQ-NUMBER→MUA-DOC-NBR-NUM
Spaces→MUA-PO-CODE
Zeroes→MUA-LINE-NBR
Zeroes→MUA-API-OBJ-ID
Zeroes→MUA-SEQ-NBR
PorqhufPORQHUFNot Required, Delete Cascades
RQH-COMPANY→UFH-COMPANY
RQH-REQ-NUMBER→UFH-REQ-NUMBER
Req LocationRQLOCRequired
RQH-COMPANY→RQL-COMPANY
RQH-REQ-LOCATION→RQL-REQ-LOCATION
RequesterREQUESTERRequired
RQH-REQUESTER→REQ-REQUESTER
RqhbodRQHBODNot Required, Delete Cascades
RQH-COMPANY→RBB-COMPANY
RQH-REQ-NUMBER→RBB-REQ-NUMBER

One to many (5) — child tables

RelationTableRulesConditionField map
ApprovalsRQAPPROVEDelete Cascades
RQH-COMPANY→RAP-COMPANY
RQH-REQ-NUMBER→RAP-REQ-NUMBER
—→RAP-APRV-LEVEL
Location RuleWHLOCRULE
RQH-FROM-COMPANY→WHU-COMPANY
RQH-LOCATION-RULE→WHU-LOCATION-RULE
—→WHU-LEVEL
Req LinesREQLINEDelete Cascades
RQH-COMPANY→RLN-COMPANY
RQH-REQ-NUMBER→RLN-REQ-NUMBER
—→RLN-LINE-NBR
RqaocmiscRQAOCDTL
RQH-COMPANY→RAO-COMPANY
RQH-REQ-NUMBER→RAO-REQ-NUMBER
Zeroes→RAO-LINE-NBR
—→RAO-AOC-CODE
RqauditRQAUDIT
"HD"→RHA-AUDIT-TYPE
RQH-COMPANY→RHA-COMPANY
RQH-REQ-NUMBER→RHA-REQ-NUMBER
—→RHA-LINE-NBR
—→RHA-LINE-SEQ
—→RHA-BIN
—→RHA-LOT-SERIAL
—→RHA-UOM
—→RHA-DATE
—→RHA-TIME
—→RHA-FLD-NBR

Programs

Updated by (235)

Referenced by (48)