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.

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
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
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
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
REFERENCE_NO
Alpha 10 (Right Justified)DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-REQ-DESC
REQ_DESC
Alpha 30 (Lower Case)DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-FROM-COMPANY
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
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
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.2DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-N-TOTAL
N_TOTAL
Signed 18.2DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-X-S-TOTAL
X_S_TOTAL
Signed 18.2DR100, 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 32DR100, 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 2DR100, 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 20DR100, 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 1DR100, 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 6DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-POB-PHONE
POB_PHONE
Alpha 15DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-POB-PHONE-EXT
POB_PHONE_EXT
Alpha 5DR100, 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 12DR100, 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 8DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.2 +16 more
RQH-REL-OPER-ID
REL_OPER_ID
Alpha 10DR100, 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 8DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.2 +16 more
RQH-APR-REJ-OPR-ID
APR_REJ_OPR_ID
Alpha 10DR100, 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 8DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-CREATED-BY
CREATED_BY
Alpha 10DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ11.1, RQ13.2 +5 more
RQH-LAST-UPDT-DATE
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 8AP125, 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 10AP125, 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 20DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-VISIT-NBR
DFLT_VISIT_NBR
Alpha 20DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-CASE-NBR
DFLT_CASE_NBR
Alpha 20DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-PROC
DFLT_PROC
Alpha 20DR100, 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 30DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-NRS-COORD
DFLT_NRS_COORD
Alpha 30DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-SALES-REP
DFLT_SALES_REP
Alpha 30DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-ORD-NBR
DFLT_ORD_NBR
Alpha 20DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-REQUESTOR
DFLT_REQUESTOR
Alpha 30DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-USERDEF1
DFLT_USERDEF1
Alpha 30DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-USERDEF2
DFLT_USERDEF2
Alpha 30DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-CN-CODE
DFLT_CN_CODE
Alpha 2DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-GLBL-DOC-TYPE
GLBL_DOC_TYPE
Alpha 10DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-LAST-NAME
DFLT_LAST_NAME
Alpha 60DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-FIRST-NM
DFLT_FIRST_NM
Alpha 60DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-MIDDLE-NM
DFLT_MIDDLE_NM
Alpha 60DR100, 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 1DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-SSN
DFLT_SSN
Alpha 20DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-DFLT-PROC-MOD
DFLT_PROC_MOD
Alpha 2DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more
RQH-AOC-TOTAL
AOC_TOTAL
Signed 18.2DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 +13 more

Indexes (9)

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

IndexKeysFlagsConditionUsed in
RQHSET1COMPANY, REQ-NUMBERPrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
RQHSET2COMPANY, REQ-LOCATION, REQUESTER, REQ-NUMBERKeyChangeDR100, IC141, RQ01.1, RQ111, RQ140, RQ260, RQ300, RQ40.1
RQHSET3REQUESTER, REQ-NUMBER*, COMPANYIC83.1, RQ10.1, RQ35.1, RQ500, RQIF.1
RQHSET4FROM-COMPANY, FROM-LOCATION, STATUS, COMPANY, REQ-NUMBERKeyChangeRQ41.1
RQHSET5COMPANY, REFERENCE-NO, REQ-NUMBERKeyChange, SubsetWhere REFERENCE-NO != Spaces
RQHSET6COMPANY, REQ-DESC, REQ-NUMBERKeyChange, SubsetWhere REQ-DESC != Spaces
RQHSET7REQUESTER, REQ-NUMBER, COMPANYIC83.1, RQ04.1, RQ10.1, RQ500, RQCP.1, RQD1.1, RQIF.1, RQII.1 +1 more
RQHSET8COMPANY, REQ-NUMBERSubsetWhere STATUS = ZeroesRQ02.1
RQHSET9COMPANY, REQ-NUMBER, CREATION-DATE, LAST-UPDT-DATEKeyChange

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
Approve CodeRQAPPCODERequiredRQH-COMPANYRAC-COMPANY (RACSET1), REQ-APPROVE-CDRAC-APPROVE-CD
From LocationICLOCATIONRequiredRQH-FROM-COMPANYICL-COMPANY, RQH-FROM-LOCATIONICL-LOCATION
Ic CompanyICCOMPANYRequiredRQH-FROM-COMPANYICC-COMPANY
MmuavalMMUAVALNot RequiredRQH-COMPANYMUA-COMPANY, "RQ"MUA-SYSTEM-CD, RQH-FROM-LOCATIONMUA-LOCATION, "RQ"MUA-DOC-TYPE, SpacesMUA-DOC-NUMBER, RQH-REQ-NUMBERMUA-DOC-NBR-NUM, SpacesMUA-PO-CODE, ZeroesMUA-LINE-NBR, ZeroesMUA-API-OBJ-ID, ZeroesMUA-SEQ-NBR
PorqhufPORQHUFNot Required, Delete CascadesRQH-COMPANYUFH-COMPANY, RQH-REQ-NUMBERUFH-REQ-NUMBER
Req LocationRQLOCRequiredRQH-COMPANYRQL-COMPANY, RQH-REQ-LOCATIONRQL-REQ-LOCATION
RequesterREQUESTERRequiredRQH-REQUESTERREQ-REQUESTER
RqhbodRQHBODNot Required, Delete CascadesRQH-COMPANYRBB-COMPANY, RQH-REQ-NUMBERRBB-REQ-NUMBER

One to many (5) — child tables

RelationTableRulesConditionField map
ApprovalsRQAPPROVEDelete CascadesRQH-COMPANYRAP-COMPANY, RQH-REQ-NUMBERRAP-REQ-NUMBER, RAP-APRV-LEVEL
Location RuleWHLOCRULERQH-FROM-COMPANYWHU-COMPANY, RQH-LOCATION-RULEWHU-LOCATION-RULE, WHU-LEVEL
Req LinesREQLINEDelete CascadesRQH-COMPANYRLN-COMPANY, RQH-REQ-NUMBERRLN-REQ-NUMBER, RLN-LINE-NBR
RqaocmiscRQAOCDTLRQH-COMPANYRAO-COMPANY, RQH-REQ-NUMBERRAO-REQ-NUMBER, ZeroesRAO-LINE-NBR, RAO-AOC-CODE
RqauditRQAUDIT"HD"RHA-AUDIT-TYPE, RQH-COMPANYRHA-COMPANY, RQH-REQ-NUMBERRHA-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)