Requisition Header

This file contains the header information for each requisition.

REFERENCED BY

POI6.1

UPDATED BY

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	API2.1
MA41.1	MA41.2	MA41.4	MA41.7	MA43.1	MA43.2
MA43.3	MA43.4	MA43.6	MA43.7	MAI1.1	PO136
PO190	PO300	PO520	POCP.1	POI3.1	POII.1
POIJ.1	RQ300	POI4.1	RQ01.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
RQH-COMPANY Element: Company	Numeric 4 Enter the company number established in Company (IC01.1) or Company (MA01.1).
RQH-REQ-NUMBER Element: Req Number	Numeric 7 Requisition 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.
RQH-REQUESTER Element: Requester	Alpha 10 (Lower Case) This is the person, department, or area requesting items. Requesters are defined in Requesters (RQ04.1).
RQH-REQ-LOCATION Element: Req Location	Alpha 5 This 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.
RQH-REQ-DEL-DATE Element: 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.
RQH-CREATION-DATE Element: Creation Date	Numeric 8 (yyyymmdd) This is the date that this line was added to the requisition.
RQH-REFERENCE-NO Element: Reference No	Alpha 10 (Right Justified)
RQH-REQ-DESC Element: Req Desc	Alpha 30 (Lower Case)
RQH-FROM-COMPANY Element: Company	Numeric 4 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.
RQH-FROM-LOCATION Element: Location	Alpha 5 This field contains a valid stocking location within the company inventory.
RQH-DELIVER-TO Element: 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.
RQH-BUYER-CODE Element: Buyer	Alpha 3 The user defined buyer code defined in Buyer (PO04.1).
RQH-VENDOR Element: 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).
RQH-PURCH-FR-LOC Element: Purch Fr Loc	Alpha 4 Enter 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).
RQH-VENDOR-NAME Element: Vendor Name	Alpha 30 Enter 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.
RQH-PRINT-REQ-FL Element: All Flag	Alpha 1 This 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
RQH-LAST-LINE-NBR Element: Line Nbr	Numeric 6 The number of the last line item added to the requisition. This number determines what the next line number is when you add another item.
RQH-LAST-DEL-SEQ Element: Seq	Numeric 3 This field contains the record sequence number.
RQH-RETURN-SEQ Element: Seq	Numeric 3 This number indicates the number of times a return has been made against a requisition.
RQH-STATUS Element: Status	Numeric 1 This is the processing status of the requisition as described below. Released = Requisition has been released in RQ10.1 (Requisition). Unreleased = Requisition added but not released in RQ10.1 (Requisition). Closed = Every requisition line is fully delivered or backorders are canceled. Rejected = The approver has rejected the requisition. This closes the requisition, which cannot be reopened. Processed = The requisition has been fully approved. 0 = Unreleased 1 = Released 5 = In Process 9 = Processed 8 = Rejected
RQH-PO-USER-FLD-1 Element: Po User Fld 1	Alpha 1 Purchase Order header user field one.
RQH-PO-USER-FLD-3 Element: User Field2	Alpha 30 Purchase Order header user field three.
RQH-PO-USER-FLD-5 Element: User Fld2	Alpha 30 (Lower Case) Purchase Order header user field five.
RQH-USER-DATE-1 Element: Date	Numeric 8 (yyyymmdd) This field displays the system date when this was created.
RQH-USER-DATE-2 Element: Date	Numeric 8 (yyyymmdd) This field displays the system date when this was created.
RQH-LAST-APRV-DT Element: Date	Numeric 8 (yyyymmdd) This is the last approval date for the requisition. Requisitions are approved in RQ12.1 (Approval Review).
RQH-APPROVED-FL Element: All Flag	Alpha 1 This 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
RQH-ATTAIN-LEVEL Element: Aprv Level	Numeric 1 This is the highest approval level required for the requisition. The requisition must be approved at this level for further processing.
RQH-APRV-LEVEL Element: Aprv Level	Numeric 1 This is the approval level that this requisition has attained so far in RQ12.1 (Approval Review).
RQH-NBR-LINES Element: Nbr Lines	Numeric 6 This is the number of detail lines.
RQH-CLOSED-LINES Element: Closed Lines	Numeric 6 This 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).
RQH-CLOSED-FL Element: Closed Fl	Alpha 1 The Closed Flag. Y = Yes N = No	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 API2.1 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136 PO190 PO300 PO520 POCP.1 POI3.1 POII.1 POIJ.1 RQ300
RQH-I-TOTAL Element: Intl Amt	Signed 18.2
RQH-N-TOTAL Element: Intl Amt	Signed 18.2
RQH-X-S-TOTAL Element: Intl Amt	Signed 18.2
RQH-PRINTED-FL Element: Printed Fl	Alpha 1 This flag indicates whether the requisition has been printed in RQ111 (Print Requisitions).
RQH-ALLOC-PRI Element: Alloc Pri	Numeric 2 This 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.
RQH-QUOTE-FL Element: Quote Fl	Alpha 1 This flag indicates if the buyer should get quotes for this requisition before it is turned into a purchase order.
RQH-RETURN-NOTE Element: Note	Alpha 12 This is a user defined field available for data entry in RQ35.1 (Requisition Returns).
RQH-RETURN-DATE Element: Date	Numeric 8 (yyyymmdd) This is the return transaction date for a requisition item processed in RQ35.1 (Requisition Returns).
RQH-ACTIVITY Element: Activity	Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
RQH-ACCT-CATEGORY Element: Acct Category	Alpha 5 Account 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 thru
RQH-BILL-CATEGORY Element: Bill Category	Alpha 32
RQH-ACCT-UNIT Element: Acct Unit	Alpha 15 The 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.
RQH-ACCOUNT Element: Account	Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
RQH-SUB-ACCT Element: Sub Acct	Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
RQH-DIST-COMPANY Element: Company	Numeric 4 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.
RQH-ASSET Element: Asset	Numeric 10 The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.
RQH-ASSET-TEMPLATE Element: Asset Template	Alpha 10 A 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.
RQH-PURCH-TAX-CD Element: Tax Code	Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code.
RQH-PURCH-TAX-FL Element: Purch Tax Fl	Alpha 1 This field indicates if this item is taxable when it is purchased for this location. Valid values are: N = Nontaxable. Default value. Y = Taxable.
RQH-OPERATOR-ID Element: Operator	Alpha 10 This is the terminal signon identifier when this requisition was added to the database.
RQH-DROPSHIP-FL Element: Dropship Fl	Alpha 1 This 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
RQH-SH-NAME Element: Name	Alpha 30 (Lower Case) Displays the company description.
RQH-SH-ADDR1 Element: Addr1	Alpha 30 (Lower Case) This field contains the first line of address information.
RQH-SH-ADDR2 Element: Addr1	Alpha 30 (Lower Case) This field contains the first line of address information.
RQH-SH-ADDR3 Element: Addr1	Alpha 30 (Lower Case) This field contains the first line of address information.
RQH-SH-ADDR4 Element: Addr1	Alpha 30 (Lower Case) This field contains the first line of address information.
RQH-SH-CITY-ADDR5 Element: City	Alpha 18 (Lower Case) This field contains the city of the address.
RQH-SH-STATE-PROV Element: State Prov	Alpha 2 The state or province.
RQH-SH-POST-CODE Element: Sh Post Code	Alpha 10 (Lower Case) This is the ship to mail code.
RQH-SH-COUNTRY-CD Element: Sh Country Cd	Alpha 2
RQH-SH-COUNTRY Element: 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.
RQH-SH-COUNTY Element: County	Alpha 25 (Lower Case) The county for the company address.
RQH-SH-PHONE-PREF Element: Phone Prefix	Alpha 6 The telephone number country code.
RQH-SH-PHONE Element: Phone	Alpha 15 Phone number.
RQH-SH-PHONE-EXT Element: Phone Ext	Alpha 5 This field contains the telephone extension number.
RQH-SH-CONTACT Element: Addr Contact	Alpha 30 (Lower Case) This is the name of the main contact.
RQH-CAPITAL-TOTAL Element: Capital Total	Signed 15.4
RQH-TECH-TOTAL Element: Tech Total	Signed 15.4
RQH-CAP-TECH-TOTAL Element: Cap Tech Total	Signed 15.4
RQH-RECORD-SOURCE Element: Record Source	Numeric 2 01 = RQ10 02 = E-Requisitions 03 = RQ500 04 = IC83 05 = IC142
RQH-PFLOW-APRV-LVL Element: Pflow Aprv Lvl	Alpha 20
RQH-APPROVAL-TYPE Element: Approval Type	Alpha 1 The type of approval record. 0 = Header approval-Approval codes 1 = Header approval-Process Flow 2 = Line approval 3 = No approval required
RQH-APPROVE-CD Element: Approve Cd	Alpha 5 This is a code to identify the approval process (levels) that a requisition has to pass before it can be picked or purchased.
RQH-BASE-CURR-CODE Element: Currency Code	Alpha 5 This field contains the company base currency code established in Company (GL10.1 ).
RQH-TRAN-CURR-CODE Element: Currency Code	Alpha 5 This field contains the company base currency code established in Company (GL10.1 ).
RQH-POB-NAME Element: Name	Alpha 30 (Lower Case) Displays the company description.
RQH-POB-ADDR1 Element: Addr1	Alpha 30 (Lower Case) This field contains the first line of address information.
RQH-POB-ADDR2 Element: Addr1	Alpha 30 (Lower Case) This field contains the first line of address information.
RQH-POB-ADDR3 Element: Addr1	Alpha 30 (Lower Case) This field contains the first line of address information.
RQH-POB-ADDR4 Element: Addr1	Alpha 30 (Lower Case) This field contains the first line of address information.
RQH-POB-CITY-ADDR5 Element: City	Alpha 18 (Lower Case) This field contains the city of the address.
RQH-POB-STATE-PROV Element: State Prov	Alpha 2 The state or province.
RQH-POB-POSTAL-CD Element: Postal Code	Alpha 10 (Lower Case) This field contains the postal code.
RQH-POB-COUNTRY-CD Element: Country Code	Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
RQH-POB-COUNTY Element: County	Alpha 25 (Lower Case) The county for the company address.
RQH-POB-CONTACT Element: Addr Contact	Alpha 30 (Lower Case) This is the name of the main contact.
RQH-RQ-SOURCE Element: Rq Source	Numeric 2 00 = Upgrade 01 = IC142 02 = IC141 03 = IC83 04 = RQ35 05 = RQ500 06 = RSS 07 = RQ10 08 = DR100
RQH-ONE-SRC-ONE-PO Element: One Src One Po	Numeric 1 0 1 2 = One Requisition to One PO
RQH-PCARD-NBR Element: Pcard Nbr	Alpha 16
RQH-SS-EVENT-REQD Element: Ss Event Reqd	Numeric 1
RQH-APPROVAL-VAL Element: Approval Val	Derived This 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 Element: Wf Co Req Nbr	Derived Used for Enterprise Workflow drill around.
RQH-DER-STATUS Element: Der Status	Derived
RQH-POB-PHONE-PREF Element: Phone Prefix	Alpha 6
RQH-POB-PHONE Element: Phone	Alpha 15
RQH-POB-PHONE-EXT Element: Phone Ext	Alpha 5
RQH-POB-EMAIL-ADDR Element: Email Address	Alpha 60 (Lower Case)
RQH-LOCATION-RULE Element: Rule Name	Alpha 12
RQH-RELEASED-DATE Element: Date	Numeric 8 (yyyymmdd)
RQH-RELEASED-TIME Element: Time	Numeric 8
RQH-REL-OPER-ID Element: Operator	Alpha 10
RQH-APR-REJ-DATE Element: Date	Numeric 8 (yyyymmdd)
RQH-APR-REJ-TIME Element: Time	Numeric 8
RQH-APR-REJ-OPR-ID Element: Operator	Alpha 10
RQH-PO-USER-FLD-7 Element: User Fld 7	Alpha 10 (Lower Case)
RQH-CREATION-TIME Element: Time	Numeric 8

REQHEADER FILE INDEX

REQHEADER FILE RELATIONS

ONE TO ONE RELATIONS

REQHEADER FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.