 |
Lawson Insight Technical Documentation |
|
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 CXCP.1 IC243 IC28.1 MA180 MA43.9
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.3 MA67.1 MA67.2 MA70.1 MAI1.1 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 RQ42.1 RQCP.1 RQIC.1 RQID.1
RQIG.1 RQIH.1 WH110 WH120 WH130 WH132
WH190 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 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.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 RQ04.1
UPDATED BY
DR100 IC141 IC142 IC83.1 POID.1 RQ10.1
RQ10.3 RQ11.1 RQ111 RQ12.1 RQ13.1 RQ140
RQ300 RQ35.1 RQ40.1 RQ41.1 RQ44.1 RQ44.2
RQ500 RQIB.1 RQIF.1 WH25.1 WH25.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQH-COMPANY Numeric 4 DR100 IC141
Company Enter the company number established in IC142 IC83.1
IC01.1 (Company) or MA00.1 (Company). RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-REQ-NUMBER Numeric 7 DR100 IC141
Requisition Number Requisition 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 RQ35.1
or MA00.1 (Company). Otherwise, RQ500 RQIB.1
requisition numbers are user defined. RQIF.1 WH20.7
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
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 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-REQ-LOCATION Alpha 5 DR100 IC141
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 RQ35.1
a noninventory location. All requesting RQ500 RQIB.1
locations must be defined in RQ01.1 RQIF.1 WH20.7
(Requesting Locations). Requesting
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
Requested Delivery This is the requested delivery date. IC142 IC83.1
Date RQ10.1 RQ10.3
If left blank, this field defaults to RQ11.1 RQ35.1
the system date. The requested delivery RQ500 RQIB.1
date is used to schedule backorder RQIF.1 WH132
allocations (that is, requisitions with WH20.7 WH222
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 Numeric 8 (yyyymmdd) DR100 IC141
Creation Date This is the date that this line was IC142 IC83.1
added to the requisition. RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-REFERENCE-NO Alpha 10 (Right Justified) RQ500 RQIB.1
Reference No RQIF.1
RQH-REQ-DESC Alpha 30 (Lower Case) RQ500 RQIB.1
Req Desc RQIF.1
RQH-FROM-COMPANY Numeric 4 DR100 IC141
From Company This is the company that is the source IC142 IC83.1
of the items. RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-FROM-LOCATION Alpha 5 DR100 IC141
From Location 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 RQ35.1
items. RQ500 RQIB.1
RQIF.1 WH20.7
RQH-DELIVER-TO Alpha 30 (Lower Case) DR100 IC141
Deliver To Name This 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 RQ35.1
field that displays online and on the RQ500 RQIB.1
delivery ticket printed by RQ120 RQIF.1 WH20.7
(Delivery Ticket).
RQH-BUYER-CODE Alpha 3 DR100 IC141
Buyer Code The user defined buyer code defined in IC142 IC83.1
MA04.1 (Buyer). RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-VENDOR Alpha 9 (Right Justified) DR100 IC141
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 RQ35.1
suggested vendor prints on the RQ500 RQIB.1
requisition when you run RQ111 (Print RQIF.1 WH20.7
Requisitions).The vendor can be changed
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 RQ35.1
locations. The purchase from location RQ500 RQIB.1
code prints on the requisition when you RQIF.1 WH20.7
run RQ111 (Print Requisitions). 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 the Accounts Payable (AP)
Alternate Location form.
RQH-VENDOR-NAME Alpha 30 DR100 IC141
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 RQ35.1
the Accounts Payable (AP) Vendor form. RQ500 RQIB.1
RQIF.1 WH20.7
RQH-PRINT-REQ-FL Alpha 1 DR100 IC141
Print Requisition This flag indicates whether you want to IC142 IC83.1
Flag print the requisition in RQ111 (Print RQ10.1 RQ10.3
Requisitions). This flag defaults based RQ11.1 RQ111
on the approval assigned to the RQ35.1 RQ500
requester. It can be overridden when the RQIB.1 RQIF.1
requisition is created. WH20.7
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
Last 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 RQ35.1
when you add another item. RQ500 RQIB.1
RQIF.1 WH20.7
RQH-LAST-DEL-SEQ Numeric 3 DR100 IC141
Last Del Seq This 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 RQ35.1 RQ500
Requisition Transaction records unique RQIB.1 RQIF.1
if one line has multiple deliveries. WH20.7
RQH-RETURN-SEQ Numeric 3 DR100 IC141
Return Seq This number indicates the number of IC142 IC83.1
times a return has been made against a RQ10.1 RQ10.3
requisition. RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-STATUS Numeric 1 DR100 IC141
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 RQ11.1 RQ12.1
released in RQ10.1 (Requisition). RQ13.1 RQ35.1
RQ500 RQIB.1
Unreleased = Requisition added but not RQIF.1 WH20.7
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.
0 = Unreleased
1 = Released
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 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-PO-USER-FLD-3 Alpha 10 (Lower Case) DR100 IC141
Purchase Order User Purchase Order header user field three. IC142 IC83.1
Field 3 RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-PO-USER-FLD-5 Alpha 30 (Lower Case) DR100 IC141
Purchase Order User Purchase Order header user field five. IC142 IC83.1
Field 5 RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-USER-DATE-1 Numeric 8 (yyyymmdd) DR100 IC141
User Date 1 IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-USER-DATE-2 Numeric 8 (yyyymmdd) DR100 IC141
User Date 2 IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-LAST-APRV-DT Numeric 8 (yyyymmdd) DR100 IC141
Last Approval 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 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-APPROVED-FL Alpha 1 DR100 IC141
Approved 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 RQ35.1
RQ02.1 (Approval Codes). RQ500 RQIB.1
N = No RQIF.1 WH20.7
Y = Yes
RQH-ATTAIN-LEVEL Numeric 1 DR100 IC141
Approval Levels to This is the highest approval level IC142 IC83.1
Attain 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 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-APRV-LEVEL Numeric 1 DR100 IC141
Approval Level This 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 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-NBR-LINES Numeric 6
Number of Lines This is the number of detail lines.
RQH-CLOSED-LINES Numeric 6
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 DR100 IC141
Closed Flag The Closed Flag. IC142 IC83.1
Y = Yes RQ10.1 RQ10.3
N = No RQ11.1 RQ140
RQ300 RQ35.1
RQ40.1 RQ41.1
RQ44.1 RQ44.2
RQ500 RQIB.1
RQIF.1 WH20.7
WH25.1 WH25.2
RQH-I-TOTAL Signed 15.4 DR100 IC141
I Total Total amount (quantity times unit cost) IC142 IC83.1
of all inventory items on the RQ10.1 RQ10.3
requisition. RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-N-TOTAL Signed 15.4 DR100 IC141
N Total Total amount (quantity times unit cost) IC142 IC83.1
of all non stock items on the RQ10.1 RQ10.3
requisition. RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-X-S-TOTAL Signed 15.4 DR100 IC141
X S Total Total amount (quantity times unit cost) IC142 IC83.1
of all special and service items on the RQ10.1 RQ10.3
requisition. RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-PRINTED-FL Alpha 1 DR100 IC141
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
RQ35.1 RQ500
RQIB.1 RQIF.1
WH20.7
RQH-ALLOC-PRI Numeric 2 DR100 IC141
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 RQ35.1
field defaults to 50. This field is RQ500 RQIB.1
used in the Warehouse module to RQIF.1 WH20.7
determine the order in which inventory
demand gets allocated.
RQH-QUOTE-FL Alpha 1 DR100 IC141
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 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-RETURN-NOTE Alpha 12 AP125 AP126
Requisition Return This is a user defined field available AP131 AP25.1
Note for data entry in RQ35.1 (Requisition AP25.2 AP26.1
Returns). AP27.1 DR100
IC141 IC142
IC28.1 IC83.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
...
RQH-RETURN-DATE Numeric 8 (yyyymmdd) DR100 IC141
Date Returned 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 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-ACTIVITY Alpha 15 DR100 IC141
Activity Activities are the processes or IC142 IC83.1
procedures that produce work. Cost RQ10.1 RQ10.3
objects (products, services, customers, RQ11.1 RQ35.1
and so on) are the reasons for RQ500 RQIB.1
performing the activity. RQIF.1 WH20.7
RQH-ACCT-CATEGORY Alpha 5 DR100 IC141
Account Category Account 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 RQ35.1
for activities in the Activity RQ500 RQIB.1
Management system. All transactions are RQIF.1 WH20.7
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.
RQH-ACCT-UNIT Alpha 15 DR100 IC141
Accounting Unit The 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 RQ35.1
Account Master file, the accounting unit RQ500 RQIB.1
must be defined in the General Ledger RQIF.1 WH20.7
Names file as a posting accounting unit.
RQH-ACCOUNT Numeric 6 DR100 IC141
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 RQ35.1
account information is stored. RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SUB-ACCT Numeric 4 DR100 IC141
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 RQ35.1
on this record. RQ500 RQIB.1
RQIF.1 WH20.7
RQH-PURCH-TAX-CD Alpha 10 DR100 IC141
Purchasing Tax This code is used to determine if this IC142 IC83.1
Table Code item is taxable when purchased at this RQ10.1 RQ10.3
location and to extract the tax data RQ11.1 RQ35.1
from the Tax file based on this tax RQ500 RQIB.1
code. RQIF.1 WH20.7
RQH-PURCH-TAX-FL Alpha 1 DR100 IC141
Purchasing Tax Flag This 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 RQ35.1
N = Nontaxable. Default value. RQ500 RQIB.1
Y = Taxable. RQIF.1 WH20.7
RQH-OPERATOR-ID Alpha 10 DR100 IC141
Operator This is the terminal signon identifier IC142 IC83.1
Identification Code when this requisition was added to the RQ10.1 RQ10.3
database. RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-DROPSHIP-FL Alpha 1 DR100 IC141
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 RQ35.1
receiving process performed. RQ500 RQIB.1
Y = Yes RQIF.1 WH20.7
N = No
RQH-DROPSH-REQ-LOC Alpha 1 DR100 IC141
Dropsh Req Loc Y = Yes IC142 IC83.1
N = No RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-NAME Alpha 30 (Lower Case) DR100 IC141
Ship To Name This is the ship to name for a non IC142 IC83.1
standard ship to address. RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-ADDR1 Alpha 30 (Lower Case) DR100 IC141
Ship To Address This is the ship to address line one. IC142 IC83.1
Line 1 RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-ADDR2 Alpha 30 (Lower Case) DR100 IC141
Ship To Address This is the ship to address line two. IC142 IC83.1
Line 2 RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-ADDR3 Alpha 30 (Lower Case) DR100 IC141
Ship To Address This is the ship to address line IC142 IC83.1
Line 3 three. RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-ADDR4 Alpha 30 (Lower Case) DR100 IC141
Ship To Address This is the ship to address line four. IC142 IC83.1
Line 4 RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-CITY-ADDR5 Alpha 18 (Lower Case) DR100 IC141
Ship To City or This is the ship to city or the IC142 IC83.1
Address Line 5 ship to address line five. RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-STATE-PROV Alpha 2 DR100 IC141
Ship To State or This is the ship to state or the IC142 IC83.1
Province ship to province. RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-POST-CODE Alpha 10 (Lower Case) DR100 IC141
Ship To Postal Code This is the ship to mail code. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-COUNTRY-CD Alpha 2 DR100 IC141
Sh Country Cd IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-COUNTRY Alpha 30 (Lower Case) DR100 IC141
Ship To Country Ship to country. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-COUNTY Alpha 25 (Lower Case) DR100 IC141
Sh County IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-PHONE-PREF Alpha 6 DR100 IC141
Ship To Telephone This is the ship to phone number IC142 IC83.1
Country Code prefix. RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-PHONE Alpha 15 DR100 IC141
Ship To Telephone This is the ship to phone number. IC142 IC83.1
Number RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-PHONE-EXT Alpha 5 DR100 IC141
Ship To Telephone IC142 IC83.1
Extension RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-SH-CONTACT Alpha 30 (Lower Case) DR100 IC141
Ship To Contact Ship to contact. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 WH20.7
RQH-APPROVAL-VAL Derived
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
Wf Co Req Nbr Used for Enterprise Workflow drill
around.
RQH-DER-STATUS Derived
Der Status
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 CXCP.1
DR100 IC141
IC142 IC243
IC28.1 IC83.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
...
RQHSET2 COMPANY This index is used to access DR100 IC141
REQ-LOCATION requisition header records by RQ140 RQ40.1
REQUESTER requisition number for a requester at a
REQ-NUMBER specific company and requesting
location.
KeyChange
RQHSET3 REQUESTER Used for SEA database lookups
REQ-NUMBER*
COMPANY
RQHSET4 FROM-COMPANY This index is used to access RQ41.1
FROM-LOCATION requisition header records that have a
STATUS specific requisition number, status,
REQ-NUMBER from company, and from location.
KeyChange
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
number.
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
|