REQHEADER

Requisition Header

This file contains the header information for each requisition.

REFERENCED BY
CX05.1 CX05.2 CX805 IC216 IC243 ICIA.1
POI6.1 RQ02.1 RQ270 RQ39.1 RQ39.2 RQ39.3
RQCP.1 RQIC.1 RQID.1 RQIG.1 RQIH.1 RQII.1
WH110 WH120 WH21.1 WH21.2 WH21.3 WH21.4
WH210 WH22.1 WH224


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
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC140
IC141 IC142 IC66.1 IC83.1 MA180 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA43.7
MA44.1 MA44.2 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 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 PO122 PO131 PO136 PO150
PO190 PO20.1 PO20.6 PO20.9 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO28.2 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 PO54.5 POCP.1 POI3.1 POI4.1 POID.1
POII.1 POIJ.1 RQ01.1 RQ04.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ11.1 RQ111 RQ12.1 RQ13.1
RQ13.2 RQ140 RQ260 RQ300 RQ35.1 RQ40.1
RQ41.1 RQ44.1 RQ44.2 RQ500 RQD0.1 RQD1.1
RQIB.1 RQIF.1 RQIJ.1 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH25.1 WH25.2 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 WHD2.1 ZW130

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).
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.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).
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1 WH132
WH222
RQH-CREATION-DATE
Element: 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.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-REFERENCE-NO
Element: Reference No
Alpha 10 (Right Justified)
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-REQ-DESC
Element: Req Desc
Alpha 30 (Lower Case)
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ260
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-FROM-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-BUYER-CODE
Element: Buyer
Alpha 3
The user defined buyer code defined in Buyer (PO04.1).
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.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).
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.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).
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ111 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-LAST-DEL-SEQ
Element: Seq
Numeric 3
This field contains the record sequence number.
DR100 IC141
IC142 IC83.1
PO30.1 PO30.2
PO30.3 PO30.4
POID.1 RQ10.1
RQ10.3 RQ10.4
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-RETURN-SEQ
Element: Seq
Numeric 3
This number indicates the number of times a return has been made against a requisition.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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
DR100 IC141
IC142 IC83.1
PO100 PO23.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ12.1 RQ13.1
RQ13.2 RQ35.1
RQ500 RQD1.1
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-PO-USER-FLD-1
Element: Po User Fld 1
Alpha 1
Purchase Order header user field one.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-PO-USER-FLD-3
Element: User Field2
Alpha 30
Purchase Order header user field three.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-PO-USER-FLD-5
Element: User Fld2
Alpha 30 (Lower Case)
Purchase Order header user field five.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-USER-DATE-1
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-USER-DATE-2
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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).
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ12.1 RQ13.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ12.1 RQ13.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ12.1 RQ13.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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).
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ12.1 RQ13.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-NBR-LINES
Element: Nbr Lines
Numeric 6
This is the number of detail lines.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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).
RQD1.1
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC141 IC142
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
RQH-I-TOTAL
Element: Intl Amt
Signed 18.2
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-N-TOTAL
Element: Intl Amt
Signed 18.2
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-X-S-TOTAL
Element: Intl Amt
Signed 18.2
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-PRINTED-FL
Element: Printed Fl
Alpha 1
This flag indicates whether the requisition has been printed in RQ111 (Print Requisitions).
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ111 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-RETURN-NOTE
Element: Note
Alpha 12
This is a user defined field available for data entry in RQ35.1 (Requisition Returns).
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-RETURN-DATE
Element: 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.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-BILL-CATEGORY
Element: Bill Category
Alpha 32
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-PURCH-TAX-CD
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-OPERATOR-ID
Element: Operator
Alpha 10
This is the terminal signon identifier when this requisition was added to the database.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-NAME
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-CITY-ADDR5
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-STATE-PROV
Element: State Prov
Alpha 2
The state or province.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-POST-CODE
Element: Sh Post Code
Alpha 10 (Lower Case)
This is the ship to mail code.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-COUNTRY-CD
Element: Sh Country Cd
Alpha 2
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-PHONE-PREF
Element: Phone Prefix
Alpha 6
The telephone number country code.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-PHONE
Element: Phone
Alpha 15
Phone number.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-PHONE-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-CONTACT
Element: Addr Contact
Alpha 30 (Lower Case)
This is the name of the main contact.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
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
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-BASE-CURR-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-TRAN-CURR-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-POB-NAME
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-POB-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-POB-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-POB-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-POB-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-POB-CITY-ADDR5
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-POB-STATE-PROV
Element: State Prov
Alpha 2
The state or province.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-POB-POSTAL-CD
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal code.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
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).
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-POB-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-POB-CONTACT
Element: Addr Contact
Alpha 30 (Lower Case)
This is the name of the main contact.
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-RQ-SOURCE
Element: Rq Source
Numeric 2

00 = Upgrade
01 = IC142
02 = IC141
03 = IC83
04 = RQ35
05 = RQ500
06 = RQC
07 = RQ10
08 = DR100
97 = Perfect Commerce
98 = SciQuest
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-ONE-SRC-ONE-PO
Element: One Src One Po
Numeric 1

0
1
2 = One Requisition to One PO
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-PCARD-NBR
Element: Pcard Nbr
Alpha 16
RQH-SS-EVENT-REQD
Element: Ss Event Reqd
Numeric 1
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.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
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-POB-PHONE
Element: Phone
Alpha 15
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-POB-PHONE-EXT
Element: Phone Ext
Alpha 5
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-POB-EMAIL-ADDR
Element: Email Address
Alpha 60 (Lower Case)
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-LOCATION-RULE
Element: Rule Name
Alpha 12
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-RELEASED-DATE
Element: Date
Numeric 8 (yyyymmdd)
DR100 IC141
IC142 IC83.1
PO100 PO23.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ12.1 RQ13.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-RELEASED-TIME
Element: Time
Numeric 8
DR100 IC141
IC142 IC83.1
PO100 PO23.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ12.1 RQ13.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-REL-OPER-ID
Element: Operator
Alpha 10
DR100 IC141
IC142 IC83.1
PO100 PO23.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ12.1 RQ13.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-APR-REJ-DATE
Element: Date
Numeric 8 (yyyymmdd)
DR100 IC141
IC142 IC83.1
PO100 PO23.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ12.1 RQ13.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-APR-REJ-TIME
Element: Time
Numeric 8
DR100 IC141
IC142 IC83.1
PO100 PO23.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ12.1 RQ13.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-APR-REJ-OPR-ID
Element: Operator
Alpha 10
DR100 IC141
IC142 IC83.1
PO100 PO23.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ12.1 RQ13.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-PO-USER-FLD-7
Element: User Fld 7
Alpha 10 (Lower Case)
RQH-CREATION-TIME
Element: Time
Numeric 8
DR100 IC141
IC142 IC83.1
RQ10.1 RQ10.3
RQ10.4 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1


REQHEADER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQHSET1 COMPANY
REQ-NUMBER
...
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
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
RQHSET2 COMPANY
REQ-LOCATION
REQUESTER
REQ-NUMBER
KeyChange
DR100 IC141
RQ01.1 RQ111
RQ140 RQ260
RQ300 RQ40.1
RQHSET3 REQUESTER
REQ-NUMBER*
COMPANY
IC83.1 RQ10.1
RQ35.1 RQ500
RQIF.1
RQHSET4 FROM-COMPANY
FROM-LOCATION
STATUS
COMPANY
REQ-NUMBER
KeyChange
RQ41.1
RQHSET5 COMPANY
REFERENCE-NO
REQ-NUMBER
KeyChange, Subset
WhereREFERENCE-NO !=Spaces
RQHSET6 COMPANY
REQ-DESC
REQ-NUMBER
KeyChange, Subset
WhereREQ-DESC !=Spaces
RQHSET7 REQUESTER
REQ-NUMBER
COMPANY
IC83.1 RQ04.1
RQ10.1 RQ500
RQCP.1 RQD1.1
RQIF.1 RQII.1
RQIJ.1
RQHSET8 COMPANY
REQ-NUMBER
Subset
WhereSTATUS =Zeroes
RQ02.1


REQHEADER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Approve Code RQAPPCODE Required
RQH-COMPANY->RAC-COMPANY
REQ-APPROVE-CD->RAC-APPROVE-CD
From Location ICLOCATION Required
RQH-FROM-COMPANY->ICL-COMPANY
RQH-FROM-LOCATION->ICL-LOCATION
Ic Company ICCOMPANY Required
RQH-FROM-COMPANY->ICC-COMPANY
Mmuaval MMUAVAL Not 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
Porqhuf PORQHUF Not Required, Delete Cascades
RQH-COMPANY->UFH-COMPANY
RQH-REQ-NUMBER->UFH-REQ-NUMBER
Req Location RQLOC Required
RQH-COMPANY->RQL-COMPANY
RQH-REQ-LOCATION->RQL-REQ-LOCATION
Requester REQUESTER Required
RQH-REQUESTER->REQ-REQUESTER


REQHEADER FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Approvals RQAPPROVE Delete Cascades
RQH-COMPANY->RAP-COMPANY
RQH-REQ-NUMBER->RAP-REQ-NUMBER
  RAP-APRV-LEVEL
Location Rule WHLOCRULE
RQH-FROM-COMPANY->WHU-COMPANY
RQH-LOCATION-RULE->WHU-LOCATION-RULE
  WHU-LEVEL
Req Lines REQLINE Delete Cascades
RQH-COMPANY->RLN-COMPANY
RQH-REQ-NUMBER->RLN-REQ-NUMBER
  RLN-LINE-NBR


File created: Thu Jun 09 11:28:35 2016

Home
Contact Us



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