Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             REQHEADER FILE

                           Requisition Header

This file contains the header information for each requisition.

REFERENCED BY

IC243     MA40.1    MA40.2    MA41.1    MA41.2    MA41.5
MA41.6    MA43.1    MA43.2    MA43.3    MA52.1    MA530
MA540     PO100     PO122     PO20.1    PO21.3    PO22.2
PO22.3    PO30.1    PO31.1    PO34.1    PO35.1    PO52.1
PO530     RQ125     RQ39.1    RQ39.2    RQ39.3    RQ44.1
RQ44.2    WH20.7    WH20.2    WH222     RQ240     RQ40.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     OE113     OE129     OE14.4    OE15.1    OE15.2
OE15.3    OE15.4    OE15.5    OE15.7    OE510     OE810
OE920     PO221     RQ41.1    RQ04.1

UPDATED BY

BL92.1    DR100     IC141     IC142     IC83.1    OE114
RQ10.1    RQ10.3    RQ10.4    RQ11.1    RQ111     RQ12.1
RQ120     RQ13.1    RQ20.1    RQ300     RQ35.1    RQ500
RQ960     RQ961     WH130     WH132     WH190     WH30.1
WH30.2    WH30.3    WH31.1    WH31.2    WH31.3    WH32.1
WH32.2    WH32.3    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

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
                     Setup).                                     RQ11.1  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   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  RQ20.1
                     or MA00.1 (Company Setup). Otherwise,       RQ35.1  RQ500
                     requisition numbers are user defined.       RQ960   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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   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  RQ20.1
                     a noninventory location. All requesting     RQ35.1  RQ500
                     locations must be defined in RQ01.1         RQ960   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  RQ20.1
                     the system date. The requested delivery     RQ35.1  RQ500
                     date is used to schedule backorder          RQ960   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-DELIVER-DATE     Numeric 8  (yyyymmdd)                       BL92.1  DR100
Delivering Date      This is the estimated delivery date of      IC141   IC142
                     the first delivery. It is the delivery      IC83.1  OE114
                     date the Purchase Order system uses as      RQ10.1  RQ10.3
                     the estimated delivery date if this         RQ11.1  RQ20.1
                     requisition is converted to a purchase      RQ35.1  RQ500
                     order.                                      RQ960   WH130
                                                                 WH132   WH190
                                                                 WH20.7  WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 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

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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   WH20.7

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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   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  RQ20.1
                     items.                                      RQ35.1  RQ500
                                                                 RQ960   WH20.7

RQH-DELIVER-TO       Alpha 30                                    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  RQ20.1
                     field that displays online and on the       RQ35.1  RQ500
                     delivery ticket printed by RQ120            RQ960   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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   WH20.7

RQH-VENDOR           Alpha 9                                     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  RQ20.1
                     suggested vendor prints on the              RQ35.1  RQ500
                     requisition when you run RQ111 (Print       RQ960   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  RQ20.1
                     locations. The purchase from location       RQ35.1  RQ500
                     code prints on the requisition when you     RQ960   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  RQ20.1
                     the Accounts Payable (AP) Vendor form.      RQ35.1  RQ500
                                                                 RQ960   WH20.7

RQH-ORDER-NAME       Alpha 10                                    DR100   IC141
Standard Order Name  The user defined Standard Order name.       IC142   IC83.1
                     The Standard Order name is defined in       RQ10.1  RQ10.3
                     the Purchase Order system.                  RQ11.1  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   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             RQ20.1  RQ35.1
                     requester. It can be overridden when the    RQ500   RQ960
                     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-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  RQ20.1
                     N = No                                      RQ35.1  RQ500
                     Y = Yes                                     RQ960   WH20.7

RQH-CONTRACT-NBR     Alpha 14                                    DR100   IC141
Contract Number      Enter the contract number for the           IC142   IC83.1
                     requisition.  This contract number is       RQ10.1  RQ10.3
                     used to default unit costs to               RQ11.1  RQ20.1
                     requisition lines, and potentially PO       RQ35.1  RQ500
                     lines when PO's are created. This           RQ960   WH20.7
                     default will happen if the contract
                     number and requisition line item are
                     tied  to a contract type standard order
                     in the PO system.

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  RQ20.1
                     when you add another item.                  RQ35.1  RQ500
                                                                 RQ960   WH20.7

RQH-LAST-HDR-SEQ     Numeric 3                                   DR100   IC141
Last Header Comment  This is the sequence number of the last     IC142   IC83.1
Sequence             header comment line.                        RQ10.1  RQ10.3
                                                                 RQ10.4  RQ11.1
                                                                 RQ20.1  RQ35.1
                                                                 RQ500   RQ960
                                                                 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    RQ10.1  RQ10.3
                     time a delivery is processed for a          RQ11.1  RQ120
                     requisition. This number is used to keep    RQ20.1  RQ35.1
                     Requisition Transaction records unique      RQ500   RQ960
                     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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   WH20.7

RQH-STATUS           Numeric 1                                   BL92.1  DR100
Status               This is the processing status of the        IC141   IC142
                     requisition as described below.             IC83.1  OE114
                                                                 RQ10.1  RQ10.3
                     Released = Requisition has been             RQ11.1  RQ12.1
                     released in RQ10.1 (Requisition).           RQ120   RQ13.1
                                                                 RQ20.1  RQ35.1
                     Unreleased = Requisition added but not      RQ500   RQ960
                     released in RQ10.1 (Requisition).           WH130   WH132
                                                                 WH190   WH20.7
                     Closed = Every requisition line is          WH30.1  WH30.2
                     fully delivered or backorders are           WH30.3  WH31.1
                     canceled.                                   WH31.2  WH31.3
                                                                 WH32.1  WH32.2
                     Rejected = The approver has rejected        WH32.3  WH33.1
                     the requisition. This closes the            WH33.2  WH33.3
                     requisition, which cannot be reopened.      WH33.4  WH33.5
                     0 = Unreleased                              WH33.6  WH33.8
                     1 = Released                                WH33.9  WH34.1
                     9 = Closed                                  WH34.2  WH34.3
                     8 = Rejected                                WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   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  RQ20.1
                     RQ02.1 (Approval Codes).                    RQ35.1  RQ500
                     N = No                                      RQ960   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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   WH20.7

RQH-NBR-LINES        Numeric 6                                   DR100   IC141
Number of Lines      This is the number of detail lines.         IC142   IC83.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   WH20.7

RQH-CLOSED-LINES     Numeric 6                                   BL92.1  DR100
Closed Lines         This is the number of closed detail         IC141   IC142
                     lines on the requisition. When the          IC83.1  OE114
                     number of closed lines equals the number    RQ10.1  RQ10.3
                     of lines, the requisition status is set     RQ11.1  RQ120
                     to closed in RQ120 (Delivery Ticket).       RQ20.1  RQ35.1
                                                                 RQ500   RQ960
                                                                 WH130   WH132
                                                                 WH190   WH20.7
                                                                 WH30.1  WH30.2
                                                                 WH30.3  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH32.1  WH32.2
                                                                 WH32.3  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

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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   RQ961
                                                                 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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   RQ961
                                                                 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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   RQ961
                                                                 WH20.7

RQH-PRINTED-FL       Alpha 1                                     RQ111   RQ960
Printed Flag         This flag indicates whether the
                     requisition has been printed in RQ111
                     (Print Requisitions).

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  RQ20.1
                     field defaults to 50.  This field is        RQ35.1  RQ500
                     used in the Warehouse module to             RQ960   WH20.7
                     determine the order in which inventory
                     demand gets allocated.

RQH-RETURN-NOTE      Alpha 12                                    DR100   IC141
Requisition Return   This is a user defined field available      IC142   IC83.1
Note                 for data entry in RQ35.1 (Requisition       RQ10.1  RQ10.3
                     Returns).                                   RQ11.1  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   WH20.7

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  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   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  RQ20.1
                     and so on) are the reasons for              RQ35.1  RQ500
                     performing the activity. Activities and     RQ960   WH20.7
                     cost object activities are used
                     synonymously in the Activity Management
                     system. Direct costs are posted to
                     activities, and indirect costs are
                     allocated to activities based on
                     activity drivers.

                     Activities are grouped or organized by
                     activity levels. There are two kinds of
                     activities: "posting allowed" and
                     "summary only." Use posting level
                     activities to budget and maintain all
                     posted transactions. Summary activities
                     or macro activities combine information
                     and balances from lower level activities
                     for reporting and inquiries.

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  RQ20.1
                     for activities in the Activity              RQ35.1  RQ500
                     Management system. All transactions are     RQ960   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  RQ20.1
                     Account Master file, the accounting unit    RQ35.1  RQ500
                     must be defined in the General Ledger       RQ960   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  RQ20.1
                     account information is stored.              RQ35.1  RQ500
                                                                 RQ960   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  RQ20.1
                     on this record.                             RQ35.1  RQ500
                                                                 RQ960   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  RQ20.1
                     from the Tax file based on this tax         RQ35.1  RQ500
                     code.                                       RQ960   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  RQ20.1
                     N = Nontaxable.  Default value.             RQ35.1  RQ500
                     Y = Taxable.                                RQ960   WH20.7

RQH-OPERATOR-ID      Alpha 10                                    DR100   IC141
Operator             This is the terminal sign-on identifier     IC142   IC83.1
Identification Code  when this requisition was added to the      RQ10.1  RQ10.3
                     database.                                   RQ11.1  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 RQ960   WH20.7

RQH-REQ-NUMBER-A     Derived
Req Number A         This field is used to connect Warehouse
                     system demand records with the
                     requisitions to facilitate Drill Around
                     activity.

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.

                         REQHEADER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RQHSET1   COMPANY       This index is used to access             BL92.1  DR100
          REQ-NUMBER    requisition header records for a         IC141   IC142
                        specific company  and requisition        IC243   IC83.1
                        number.                                  MA40.1  MA40.2
                                                                 MA41.1  MA41.2
                                                                 MA41.5  MA41.6
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA52.1
                                                                 MA530   MA540
                                                                 OE114   PO100
                                                                 PO122   PO20.1
                                                                 PO21.3  PO22.2
                                                                 PO22.3  PO30.1
                                                                 PO31.1  PO34.1
                                                                 PO35.1  PO52.1
                                                                 ...

RQHSET2   COMPANY       This index is used to access             DR100   IC141
          REQ-LOCATION  requisition header records by            RQ240   RQ40.1
          REQUESTER     requisition number for a requester at a
          REQ-NUMBER    specific company and requesting
                        location.
                        KeyChange

RQHSET3   REQUESTER
          REQ-NUMBER*
          COMPANY

RQHSET4   FROM-COMPANY  This index is used to access             BL92.1  OE10.1
          FROM-LOCATION requisition header records that have a   OE10.2  OE10.3
          STATUS        specific requisition number, status,     OE10.4  OE10.5
          REQ-NUMBER    from company, and from location.         OE10.6  OE10.7
                        KeyChange                                OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE113   OE114
                                                                 OE129   OE14.4
                                                                 OE15.1  OE15.2
                                                                 OE15.3  OE15.4
                                                                 OE15.5  OE15.7
                                                                 OE510   OE810
                                                                 OE920   PO100
                                                                 PO20.1  PO22.2
                                                                 ...

RQHSET5   COMPANY       This index is used to access a           RQ20.1
          BUYER-CODE    requisition header record issued for a
          STATUS        specific  company buyer and having a
          REQ-NUMBER    specific requisition number and status.
                        KeyChange

RQHSET7   REQUESTER     This index is used to access a           IC83.1  RQ04.1
          REQ-NUMBER    requisition header record for a specific RQ10.1
          COMPANY       company, requester, and requisition
                        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

Buyer          BUYER        Required
                            When RQH-BUYER-CODE != Spaces

                            RQH-COMPANY          -> BUY-COMPANY
                            RQH-BUYER-CODE       -> BUY-BUYER-CODE

From Location  ICLOCATION   Required

                            RQH-FROM-COMPANY     -> ICL-COMPANY
                            RQH-FROM-LOCATION    -> ICL-LOCATION

Ic Company     ICCOMPANY    Required

                            RQH-COMPANY          -> ICC-COMPANY

Mmuaval        MMUAVAL      Not Required

                            RQH-COMPANY          -> MUA-COMPANY
                            "RQ"                 -> MUA-SYSTEM-CD
                            Spaces               -> MUA-LOCATION
                            "IS"                 -> MUA-DOC-TYPE
                            Spaces               -> MUA-DOC-NBR
                            RQH-REQ-NUMBER       -> MUA-DOC-NBR-NUM
                            Zeroes               -> MUA-LINE-NBR

Req Location   RQLOC        Required

                            RQH-COMPANY          -> RQL-COMPANY
                            RQH-REQ-LOCATION     -> RQL-REQ-LOCATION

Requester      REQUESTER    Required

                            RQH-COMPANY          -> REQ-COMPANY
                            RQH-REQUESTER        -> REQ-REQUESTER

Whdemndhdr     WHDEMNDHDR   Not Required

                            RQH-COMPANY          -> WDH-COMPANY
                            "RQ"                 -> WDH-SYSTEM-CD
                            RQH-REQ-NUMBER       -> WDH-DOC-NBR-NUM

                         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

Hdr Comments   RQCOMMENTS   Delete Cascades

                            RQH-COMPANY          -> RCM-COMPANY
                            RQH-REQ-NUMBER       -> RCM-REQ-NUMBER
                            Zeroes               -> RCM-LINE-NBR
                                                    RCM-SEQ

Req Lines      REQLINE      Delete Cascades

                            RQH-COMPANY          -> RLN-COMPANY
                            RQH-REQ-NUMBER       -> RLN-REQ-NUMBER
                                                    RLN-LINE-NBR

Wfhiswkunit    WFHISWKUNI

                            "RQHSET1        "    -> WFI-OBJECT-NAME
                            RQH-WF-CO-REQ-NBR    -> WFI-KEY-STRING
                                                    WFI-WORKUNIT

Wfworkunit     WFWORKUNIT

                            "RQHSET1        "    -> WFW-OBJECT-NAME
                            RQH-WF-CO-REQ-NBR    -> WFW-KEY-STRING
                                                    WFW-WORKUNIT

Whshipment     WHSHIPMENT

                            RQH-FROM-COMPANY     -> WHS-COMPANY
                            "R"                  -> WHS-SYSTEM-CD
                            WDH-DOC-NBR          -> WHS-DOC-NBR
                                                    WHS-SHIPMENT-NBR
                                                    WHS-LOCATION