Lawson Insight Technical Documentation |
|
REQHEADER
REQHEADER FILE
Requisition Header
This file contains the header information for each requisition.
REFERENCED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 CXCP.1 IC243 IC28.1 MA180 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MA75.1 MA80.1
MAI1.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE81.1 OE810 OE830
OE90.1 OE90.2 PO100 PO101 PO122 PO131
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 POCP.1 POI3.1 POI4.1 POI6.1 POIE.1
POII.1 POIJ.1 RQ39.1 RQ39.2 RQ39.3 RQCP.1
RQIC.1 RQID.1 RQIG.1 RQIH.1 WH110 WH120
WH20.1 WH20.2 WH20.3 WH20.4 WH20.5 WH20.6
WH20.7 WH21.1 WH21.2 WH21.3 WH21.4 WH210
WH22.1 WH222 WH224 WO120 WO131 WO132
WO133 WO140 WO20.1 WO30.1 WO32.1 WO32.2
WO32.3 WO32.4 WO32.5 WO40.1 WO40.2 WO40.3
WO40.4 WO40.5 WO41.1 WO41.2 WO41.3 WO41.4
WO42.1 WO42.2 WO42.3 WO42.4 WO42.5 WO45.1
WOEX.1 WOSP.1 RQ01.1 RQ04.1 RQII.1 RQ02.1
UPDATED BY
BL92.1 DR100 IC141 IC142 IC83.1 OE114
POID.1 RQ10.1 RQ10.3 RQ11.1 RQ111 RQ12.1
RQ13.1 RQ13.2 RQ140 RQ300 RQ35.1 RQ40.1
RQ41.1 RQ44.1 RQ44.2 RQ500 RQIB.1 RQIF.1
RQIJ.1 WH130 WH132 WH190 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
WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQH-COMPANY Numeric 4 DR100 IC141
Element: Company Enter the company number established in IC142 IC83.1
IC01.1 (Company) or MA00.1 (Company). RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-REQ-NUMBER Numeric 7 DR100 IC141
Element: Requisition NuRequisition numbers are automatically IC142 IC83.1
assigned if the company is set up for RQ10.1 RQ10.3
automatic numbering in IC01.1 (Company) RQ11.1 RQ13.2
or MA00.1 (Company). Otherwise, RQ35.1 RQ500
requisition numbers are user defined. RQIB.1 RQIF.1
RQII.1 RQIJ.1
Automatically assigned requisition
numbers are incremented by one from the
last number used, as defined in IC01.1
or MA00.1.
RQH-REQUESTER Alpha 10 (Lower Case) DR100 IC141
Element: Requester This is the person, department, or area IC142 IC83.1
requesting items. Requesters are defined RQ10.1 RQ10.3
in RQ04.1 (Requesters). RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-REQ-LOCATION Alpha 5 DR100 IC141
Element: To Location This is the location requesting items. IC142 IC83.1
This location can be an inventory RQ10.1 RQ10.3
location defined in IC02.1 (Location) or RQ11.1 RQ13.2
a noninventory location. All requesting RQ35.1 RQ500
locations must be defined in RQ01.1 RQIB.1 RQIF.1
(Requesting Locations). Requesting RQII.1 RQIJ.1
locations may be assigned to the
requester in the RQ04.1 (Requesters)
Main tab. The requesting location
defaults to the requisition based on the
requester. You can override this with
each requisition.
RQH-REQ-DEL-DATE Numeric 8 (yyyymmdd) DR100 IC141
Element: Date This is the requested delivery date. IC142 IC83.1
RQ10.1 RQ10.3
If left blank, this field defaults to RQ11.1 RQ13.2
the system date. The requested delivery RQ35.1 RQ500
date is used to schedule backorder RQIB.1 RQIF.1
allocations (that is, requisitions with RQII.1 RQIJ.1
the oldest requisition delivery date WH132 WH222
having backorders are filled before
later dated requisitions for the same
item). You can override this date.
RQH-CREATION-DATE Numeric 8 (yyyymmdd) DR100 IC141
Element: Creation Date This is the date that this line was IC142 IC83.1
added to the requisition. RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-REFERENCE-NO Alpha 10 (Right Justified) DR100 IC141
Element: Reference No IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-REQ-DESC Alpha 30 (Lower Case) DR100 IC141
Element: Req Desc IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-FROM-COMPANY Numeric 4 DR100 IC141
Element: Company This is the company that is the source IC142 IC83.1
of the items. RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-FROM-LOCATION Alpha 5 DR100 IC141
Element: Location Code This is the inventory location that IC142 IC83.1
supplies the items or it is the purchase RQ10.1 RQ10.3
order ship to location that receives the RQ11.1 RQ13.2
items. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-DELIVER-TO Alpha 30 (Lower Case) DR100 IC141
Element: Deliver To NamThis is additional information IC142 IC83.1
regarding where the requested items are RQ10.1 RQ10.3
to be delivered. This is a user-defined RQ11.1 RQ13.2
field that displays online and on the RQ35.1 RQ500
delivery ticket printed by RQ120 RQIB.1 RQIF.1
(Delivery Ticket). RQII.1 RQIJ.1
RQH-BUYER-CODE Alpha 3 DR100 IC141
Element: Buyer The user defined buyer code defined in IC142 IC83.1
MA04.1 (Buyer). RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-VENDOR Alpha 9 (Right Justified) DR100 IC141
Element: Vendor ID Enter the suggested vendor code for the IC142 IC83.1
requisition. The vendor code defaults to RQ10.1 RQ10.3
all subsequent requisition lines. The RQ11.1 RQ13.2
suggested vendor prints on the RQ35.1 RQ500
requisition when you run RQ111 (Print RQIB.1 RQIF.1
Requisitions).The vendor can be changed RQII.1 RQIJ.1
when a purchase order is created. The
vendor must be defined in the Accounts
Payable (AP) Vendor form.
RQH-PURCH-FR-LOC Alpha 4 DR100 IC141
Purchase From Enter the suggested purchase from IC142 IC83.1
Location Code location for the entered vendor. Vendors RQ10.1 RQ10.3
can have multiple purchase from RQ11.1 RQ13.2
locations. The purchase from location RQ35.1 RQ500
code prints on the requisition when you RQIB.1 RQIF.1
run RQ111 (Print Requisitions). As with RQII.1 RQIJ.1
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 the Accounts Payable (AP)
Alternate Location form.
RQH-VENDOR-NAME Alpha 30 DR100 IC141
Element: Vendor Name Enter the recommended vendor's name for IC142 IC83.1
the requisition. If left blank, this RQ10.1 RQ10.3
defaults to the vendor's name defined in RQ11.1 RQ13.2
the Accounts Payable (AP) Vendor form. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-PRINT-REQ-FL Alpha 1 DR100 IC141
Element: All Flag This flag indicates whether you want to IC142 IC83.1
print the requisition in RQ111 (Print RQ10.1 RQ10.3
Requisitions). This flag defaults based RQ11.1 RQ111
on the approval assigned to the RQ13.2 RQ35.1
requester. It can be overridden when the RQ500 RQIB.1
requisition is created. RQIF.1 RQII.1
RQIJ.1
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 Numeric 6 DR100 IC141
Element: Line Number The number of the last line item added IC142 IC83.1
to the requisition. This number RQ10.1 RQ10.3
determines what the next line number is RQ11.1 RQ13.2
when you add another item. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-LAST-DEL-SEQ Numeric 3 DR100 IC141
Element: Sequence NumbeThis is the last delivery sequence IC142 IC83.1
number. This number is incremented every POID.1 RQ10.1
time a delivery is processed for a RQ10.3 RQ11.1
requisition. This number is used to keep RQ13.2 RQ35.1
Requisition Transaction records unique RQ500 RQIB.1
if one line has multiple deliveries. RQIF.1 RQII.1
RQIJ.1
RQH-RETURN-SEQ Numeric 3 DR100 IC141
Element: Sequence NumbeThis number indicates the number of IC142 IC83.1
times a return has been made against a RQ10.1 RQ10.3
requisition. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-STATUS Numeric 1 DR100 IC141
Element: Status This is the processing status of the IC142 IC83.1
requisition as described below. PO100 PO23.1
RQ10.1 RQ10.3
Released = Requisition has been released RQ11.1 RQ12.1
in RQ10.1 (Requisition). RQ13.1 RQ13.2
RQ35.1 RQ500
Unreleased = Requisition added but not RQIB.1 RQIF.1
released in RQ10.1 (Requisition). RQII.1 RQIJ.1
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 Alpha 1 DR100 IC141
Purchase Order User Purchase Order header user field one. IC142 IC83.1
Field 1 RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-PO-USER-FLD-3 Alpha 30 DR100 IC141
Item Mster User Purchase Order header user field three. IC142 IC83.1
Defined Field2 RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-PO-USER-FLD-5 Alpha 30 (Lower Case) DR100 IC141
Element: User Defined FPurchase Order header user field five. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-USER-DATE-1 Numeric 8 (yyyymmdd) DR100 IC141
Element: Date IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-USER-DATE-2 Numeric 8 (yyyymmdd) DR100 IC141
Element: Date IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-LAST-APRV-DT Numeric 8 (yyyymmdd) DR100 IC141
Element: Date This is the last approval date for the IC142 IC83.1
requisition. Requisitions are approved RQ10.1 RQ10.3
in RQ12.1 (Approval Review). RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-APPROVED-FL Alpha 1 DR100 IC141
Element: All Flag This flag indicates that this IC142 IC83.1
requisition has been approved at all RQ10.1 RQ10.3
required approval levels. Required RQ11.1 RQ12.1
approval levels are defined by amount in RQ13.1 RQ13.2
RQ02.1 (Approval Codes). RQ35.1 RQ500
N = No RQIB.1 RQIF.1
Y = Yes RQII.1 RQIJ.1
RQH-ATTAIN-LEVEL Numeric 1 DR100 IC141
Element: Approval LevelThis is the highest approval level IC142 IC83.1
required for the requisition. The RQ10.1 RQ10.3
requisition must be approved at this RQ11.1 RQ12.1
level for further processing. RQ13.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-APRV-LEVEL Numeric 1 DR100 IC141
Element: Approval LevelThis is the approval level that this IC142 IC83.1
requisition has attained so far in RQ10.1 RQ10.3
RQ12.1 (Approval Review). RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-NBR-LINES Numeric 6 DR100 IC141
Element: Number of LineThis is the number of detail lines. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-CLOSED-LINES Numeric 6
Element: Closed Lines 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 Alpha 1 BL92.1 DR100
Element: Closed Flag The Closed Flag. IC141 IC142
Y = Yes IC83.1 OE114
N = No POID.1 RQ10.1
RQ10.3 RQ11.1
RQ13.2 RQ140
RQ300 RQ35.1
RQ40.1 RQ41.1
RQ44.1 RQ44.2
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1 WH130
WH132 WH190
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
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
RQH-I-TOTAL Signed 18.2 DR100 IC141
Element: Intl Amt Total amount (quantity times unit cost) IC142 IC83.1
of all inventory items on the RQ10.1 RQ10.3
requisition. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-N-TOTAL Signed 18.2 DR100 IC141
Element: Intl Amt Total amount (quantity times unit cost) IC142 IC83.1
of all non stock items on the RQ10.1 RQ10.3
requisition. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-X-S-TOTAL Signed 18.2 DR100 IC141
Element: Intl Amt Total amount (quantity times unit cost) IC142 IC83.1
of all special and service items on the RQ10.1 RQ10.3
requisition. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-PRINTED-FL Alpha 1 DR100 IC141
Element: Printed Flag This flag indicates whether the IC142 IC83.1
requisition has been printed in RQ111 RQ10.1 RQ10.3
(Print Requisitions). RQ11.1 RQ111
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-ALLOC-PRI Numeric 2 DR100 IC141
Element: Alloc Pri This is the allocation priority for IC142 IC83.1
this requisition. Valid values are from RQ10.1 RQ10.3
0 to 99, with 99 being the highest. This RQ11.1 RQ13.2
field defaults to 50. This field is RQ35.1 RQ500
used in the Warehouse module to RQIB.1 RQIF.1
determine the order in which inventory RQII.1 RQIJ.1
demand gets allocated.
RQH-QUOTE-FL Alpha 1 DR100 IC141
Element: Quote Flag This flag indicates if the buyer should IC142 IC83.1
get quotes for this requisition before RQ10.1 RQ10.3
it is turned into a purchase order. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-RETURN-NOTE Alpha 12 DR100 IC141
Element: Note This is a user defined field available IC142 IC83.1
for data entry in RQ35.1 (Requisition RQ10.1 RQ10.3
Returns). RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-RETURN-DATE Numeric 8 (yyyymmdd) DR100 IC141
Element: Date This is the return transaction date for IC142 IC83.1
a requisition item processed in RQ35.1 RQ10.1 RQ10.3
(Requisition Returns). RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-ACTIVITY Alpha 15 DR100 IC141
Element: Activity Activities are the processes or IC142 IC83.1
procedures that produce work. Cost RQ10.1 RQ10.3
objects (products, services, customers, RQ11.1 RQ13.2
and so on) are the reasons for RQ35.1 RQ500
performing the activity. RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-ACCT-CATEGORY Alpha 5 DR100 IC141
Element: Account CategoAccount categories are groupings of IC142 IC83.1
costs, revenues, or a combination of RQ10.1 RQ10.3
both used for reporting and inquiries RQ11.1 RQ13.2
for activities in the Activity RQ35.1 RQ500
Management system. All transactions are RQIB.1 RQIF.1
posted to an account category within an RQII.1 RQIJ.1
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 Alpha 32 DR100 IC141
Element: Bill Category IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-ACCT-UNIT Alpha 15 DR100 IC141
Element: Accounting UniThe accounting unit is a shorthand IC142 IC83.1
notation representing the variable level RQ10.1 RQ10.3
number. When used in the General Ledger RQ11.1 RQ13.2
Account Master file, the accounting unit RQ35.1 RQ500
must be defined in the General Ledger RQIB.1 RQIF.1
Names file as a posting accounting unit. RQII.1 RQIJ.1
RQH-ACCOUNT Numeric 6 DR100 IC141
Element: Account This field along with the accounting IC142 IC83.1
unit and subaccount make up the location RQ10.1 RQ10.3
(account) where amounts and other RQ11.1 RQ13.2
account information is stored. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SUB-ACCT Numeric 4 DR100 IC141
Element: Subaccount This field contains the subaccount from IC142 IC83.1
your general ledger chart of accounts RQ10.1 RQ10.3
that was charged with the amount carried RQ11.1 RQ13.2
on this record. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-DIST-COMPANY Numeric 4 DR100 IC141
Element: Company The company number used for posting the IC142 IC83.1
transaction. A valid intercompany RQ10.1 RQ10.3
relationship must be defined in the RQ11.1 RQ13.2
Lawson General Ledger system. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-ASSET Numeric 10 DR100 IC141
Element: Asset Number The asset number contains up to ten IC142 IC83.1
numeric characters that uniquely RQ10.1 RQ10.3
identify an asset. Assets are RQ11.1 RQ13.2
automatically numbered system-wide. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-ASSET-TEMPLATE Alpha 10 DR100 IC141
Element: Asset TemplateA user-defined asset template IC142 IC83.1
identifies general asset creation RQ10.1 RQ10.3
parameters that you can use to quickly RQ11.1 RQ13.2
add assets with minimal keying. Using a RQ35.1 RQ500
template lets you default many data RQIB.1 RQIF.1
items associated with a new asset. RQII.1 RQIJ.1
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 Alpha 10 DR100 IC141
Element: Tax Code This code is used to determine if this IC142 IC83.1
item is taxable when purchased at this RQ10.1 RQ10.3
location and to extract the tax data RQ11.1 RQ13.2
from the Tax file based on this tax RQ35.1 RQ500
code. RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-PURCH-TAX-FL Alpha 1 DR100 IC141
Element: Purchasing TaxThis field indicates if this item is IC142 IC83.1
taxable when it is purchased for this RQ10.1 RQ10.3
location. Valid values are: RQ11.1 RQ13.2
N = Nontaxable. Default value. RQ35.1 RQ500
Y = Taxable. RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-OPERATOR-ID Alpha 10 DR100 IC141
Element: Operator Code This is the terminal signon identifier IC142 IC83.1
when this requisition was added to the RQ10.1 RQ10.3
database. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-DROPSHIP-FL Alpha 1 DR100 IC141
Element: Dropship Flag This flag indicates whether goods being IC142 IC83.1
shipped by the vendor directly to a non RQ10.1 RQ10.3
standard location need to have the RQ11.1 RQ13.2
receiving process performed. RQ35.1 RQ500
Y = Yes RQIB.1 RQIF.1
N = No RQII.1 RQIJ.1
RQH-DROPSH-REQ-LOC Alpha 1 DR100 IC141
Element: Dropsh Req LocY = Yes IC142 IC83.1
N = No RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-NAME Alpha 30 (Lower Case) DR100 IC141
Element: Name This is the ship to name for a non IC142 IC83.1
standard ship to address. RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-ADDR1 Alpha 30 (Lower Case) DR100 IC141
Element: Address 1 This is the ship to address line one. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-ADDR2 Alpha 30 (Lower Case) DR100 IC141
Element: Address 1 This is the ship to address line two. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-ADDR3 Alpha 30 (Lower Case) DR100 IC141
Element: Address 1 This is the ship to address line IC142 IC83.1
three. RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-ADDR4 Alpha 30 (Lower Case) DR100 IC141
Element: Address 1 This is the ship to address line four. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-CITY-ADDR5 Alpha 18 (Lower Case) DR100 IC141
Element: City This is the ship to city or the IC142 IC83.1
ship to address line five. RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-STATE-PROV Alpha 2 DR100 IC141
Element: State or ProviThis is the ship to state or the IC142 IC83.1
ship to province. RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-POST-CODE Alpha 10 (Lower Case) DR100 IC141
Element: Ship To PostalThis is the ship to mail code. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-COUNTRY-CD Alpha 2 DR100 IC141
Element: Sh Country Cd IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-COUNTRY Alpha 30 (Lower Case) DR100 IC141
Element: Country or OthShip to country. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-COUNTY Alpha 25 (Lower Case) DR100 IC141
Element: County IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-PHONE-PREF Alpha 6 DR100 IC141
Telephone Country This is the ship to phone number IC142 IC83.1
Code prefix. RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-PHONE Alpha 15 DR100 IC141
Element: Telephone NumbThis is the ship to phone number. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-PHONE-EXT Alpha 5 DR100 IC141
Element: Telephone Extension IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-CONTACT Alpha 30 (Lower Case) DR100 IC141
Element: Contact Ship to contact. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-CAPITAL-TOTAL Signed 15.4
Element: Capital Total
RQH-TECH-TOTAL Signed 15.4
Element: Tech Total
RQH-CAP-TECH-TOTAL Signed 15.4
Element: Cap Tech Total
RQH-RECORD-SOURCE Numeric 2
Element: Record Source 01 = RQ10
02 = E-Requisitions
03 = RQ500
04 = IC83
05 = IC142
RQH-PFLOW-APRV-LVL Alpha 20 DR100 IC141
Element: Pflow Aprv Lvl IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-APPROVAL-TYPE Alpha 1 DR100 IC141
Element: Approval Type The type of approval record. IC142 IC83.1
0 = Header approval-Approval codes RQ10.1 RQ10.3
1 = Header approval-Process Flow RQ11.1 RQ13.2
2 = Line approval RQ35.1 RQ500
3 = No approval required RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-APPROVE-CD Alpha 5 DR100 IC141
Element: Approval Code This is a code to identify the approval IC142 IC83.1
process (levels) that a requisition has RQ10.1 RQ10.3
to pass before it can be picked or RQ11.1 RQ13.2
purchased. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-BASE-CURR-CODE Alpha 5
Element: Currency Code
RQH-TRAN-CURR-CODE Alpha 5
Element: Currency Code
RQH-POB-NAME Alpha 30 (Lower Case)
Element: Name
RQH-POB-ADDR1 Alpha 30 (Lower Case)
Element: Address 1
RQH-POB-ADDR2 Alpha 30 (Lower Case)
Element: Address 1
RQH-POB-ADDR3 Alpha 30 (Lower Case)
Element: Address 1
RQH-POB-ADDR4 Alpha 30 (Lower Case)
Element: Address 1
RQH-POB-CITY-ADDR5 Alpha 18 (Lower Case)
Element: City
RQH-POB-STATE-PROV Alpha 2
Element: State or Province
RQH-POB-POSTAL-CD Alpha 10 (Lower Case)
Element: Postal Code
RQH-POB-COUNTRY-CD Alpha 2
Element: Country Code
RQH-POB-COUNTY Alpha 25 (Lower Case)
Element: County
RQH-POB-CONTACT Alpha 30 (Lower Case)
Element: Contact
RQH-APPROVAL-VAL Derived
Element: Approval Val 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 Derived
Element: Wf Co Req Nbr Used for Enterprise Workflow drill
around.
RQH-DER-STATUS Derived
Element: Der Status
RQH-RQ-SOURCE Alpha 2
Element: Rq Source 1 = Upgrade
2 = IC142
3 = IC141
4 = IC83
5 = RQ35
6 = RQ500
7 = RSS
8 = RQ10
REQHEADER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQHSET1 COMPANY This index is used to access AP125 AP126
REQ-NUMBER requisition header records for a AP131 AP25.1
specific company and requisition AP25.2 AP26.1
number. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC141 IC142
IC243 IC28.1
IC83.1 MA180
MA530 MA531
...
RQHSET2 COMPANY This index is used to access DR100 IC141
REQ-LOCATION requisition header records by RQ01.1 RQ140
REQUESTER requisition number for a requester at a RQ40.1
REQ-NUMBER specific company and requesting
location.
KeyChange
RQHSET3 REQUESTER Used for SEA database lookups IC83.1 RQ10.1
REQ-NUMBER* RQ35.1 RQ500
COMPANY RQIF.1
RQHSET4 FROM-COMPANY This index is used to access RQ41.1
FROM-LOCATION requisition header records that have a
STATUS specific requisition number, status,
COMPANY from company, and from location.
REQ-NUMBER KeyChange
RQHSET5 COMPANY This index is used to access a
REFERENCE-NO requisition header record issued for a
REQ-NUMBER specific company buyer and having a
specific requisition number and status.
KeyChange, Subset
Where REFERENCE-NO != Spaces
RQHSET6 COMPANY KeyChange, Subset
REQ-DESC Where REQ-DESC != Spaces
REQ-NUMBER
RQHSET7 REQUESTER This index is used to access a IC83.1 RQ04.1
REQ-NUMBER requisition header record for a specific RQ10.1 RQ500
COMPANY company, requester, and requisition RQCP.1 RQIF.1
number. RQII.1
RQHSET8 COMPANY Subset RQ02.1
REQ-NUMBER Where STATUS = Zeroes
REQHEADER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 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
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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Approvals RQAPPROVE Delete Cascades
RQH-COMPANY -> RAP-COMPANY
RQH-REQ-NUMBER -> RAP-REQ-NUMBER
RAP-APRV-LEVEL
Req Lines REQLINE Delete Cascades
RQH-COMPANY -> RLN-COMPANY
RQH-REQ-NUMBER -> RLN-REQ-NUMBER
RLN-LINE-NBR
|