Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

REQHEADER


                             REQHEADER FILE

                           Requisition Header

This file contains the header information for each requisition.

REFERENCED BY

PO136     POI4.1    POI6.1    RQ39.1    RQ39.2    RQ39.3
RQCP.1    RQIC.1    RQID.1    RQIG.1    RQIH.1    WH110
WH120     WH21.1    WH21.2    WH21.3    WH21.4    WH210
WH22.1    WH224     RQ01.1    RQ04.1    RQII.1    RQ02.1


UPDATED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    CXCP.1
MA180     MA41.1    MA41.2    MA41.4    MA41.7    MA43.1
MA43.2    MA43.3    MA43.7    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA66.2    MA66.3    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
PO190     PO20.1    PO21.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO23.1    PO24.1    PO25.1    PO25.5
PO25.6    PO25.7    PO27.2    PO29.1    PO30.1    PO30.2
PO30.3    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     POCP.1    POI3.1    POID.1    POII.1    POIJ.1
RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ111     RQ12.1
RQ13.1    RQ13.2    RQ140     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    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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RQH-COMPANY            Numeric 4                                 RQ10.1  RQ10.3
Element: Company       Enter the company number established in   RQ11.1  RQ13.2
                       Company (IC01.1) or Company (MA01.1).     RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-REQ-NUMBER         Numeric 7                                 RQ10.1  RQ10.3
Element: Req Number    Requisition numbers are automatically     RQ11.1  RQ13.2
                       assigned if the company is set up for     RQ35.1  RQ500
                       automatic numbering in Company (IC01.1)   RQIB.1  RQIF.1
                       or Company (MA01.1). Otherwise,           RQII.1  RQIJ.1
                       requisition numbers are user defined.

                       Automatically assigned requisition
                       numbers are incremented by one from the
                       last number used, as defined in IC01.1
                       or MA01.1.

RQH-REQUESTER          Alpha 10  (Lower Case)                    RQ10.1  RQ10.3
Element: Requester     This is the person, department, or area   RQ11.1  RQ13.2
                       requesting items. Requesters are defined  RQ35.1  RQ500
                       in Requesters (RQ04.1).                   RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-REQ-LOCATION       Alpha 5                                   RQ10.1  RQ10.3
Element: Req Location  This is the location requesting items.    RQ11.1  RQ13.2
                       This location can be an inventory         RQ35.1  RQ500
                       location defined in Location (IC02.1) or  RQIB.1  RQIF.1
                       a non-inventory location. All requesting  RQII.1  RQIJ.1
                       locations must be defined in Requesting
                       Locations (RQ01.1). Requesting locations
                       may be assigned to the requester in the
                       Requesters (RQ04.1) Main tab. The
                       requesting location defaults to the
                       requisition based on the requester. You
                       can override this with each requisition.

RQH-REQ-DEL-DATE       Numeric 8  (yyyymmdd)                     RQ10.1  RQ10.3
Element: Date          This is the requested delivery date.      RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                       If left blank, this field defaults to     RQIB.1  RQIF.1
                       the system date. The requested delivery   RQII.1  RQIJ.1
                       date is used to schedule backorder        WH132   WH222
                       allocations (that is, requisitions with
                       the oldest requisition delivery date
                       having backorders are filled before
                       later dated requisitions for the same
                       item). You can override this date.

RQH-CREATION-DATE      Numeric 8  (yyyymmdd)                     RQ10.1  RQ10.3
Element: Creation Date This is the date that this line was       RQ11.1  RQ13.2
                       added to the requisition.                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-REFERENCE-NO       Alpha 10  (Right Justified)               RQ10.1  RQ10.3
Element: Reference No                                            RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-REQ-DESC           Alpha 30  (Lower Case)                    RQ10.1  RQ10.3
Element: Req Desc                                                RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-FROM-COMPANY       Numeric 4                                 RQ10.1  RQ10.3
Element: Company       Identifies the AP company if the          RQ11.1  RQ13.2
                       resource type = V.  Identifies the HR     RQ35.1  RQ500
                       company if the resource type = E.  It is  RQIB.1  RQIF.1
                       blank for type A, P or Q resources.       RQII.1  RQIJ.1

RQH-FROM-LOCATION      Alpha 5                                   RQ10.1  RQ10.3
Element: Location      This field contains a valid stocking      RQ11.1  RQ13.2
                       location within the company inventory.    RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-DELIVER-TO         Alpha 30  (Lower Case)                    RQ10.1  RQ10.3
Element: Deliver To    This is additional information            RQ11.1  RQ13.2
                       regarding where the requested items are   RQ35.1  RQ500
                       to be delivered. This is a user-defined   RQIB.1  RQIF.1
                       field that displays online and on the     RQII.1  RQIJ.1
                       delivery ticket.

RQH-BUYER-CODE         Alpha 3                                   RQ10.1  RQ10.3
Element: Buyer         The user defined buyer code defined in    RQ11.1  RQ13.2
                       Buyer (PO04.1).                           RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-VENDOR             Alpha 9  (Right Justified)                RQ10.1  RQ10.3
Element: Vendor        Enter the suggested vendor code for the   RQ11.1  RQ13.2
                       requisition. The vendor code defaults to  RQ35.1  RQ500
                       all subsequent requisition lines. The     RQIB.1  RQIF.1
                       suggested vendor prints on the            RQII.1  RQIJ.1
                       requisition when you run Print
                       Requisitions (RQ111).The vendor can be
                       changed when a purchase order is
                       created.  The vendor must be defined in
                       Vendor (AP10.1).

RQH-PURCH-FR-LOC       Alpha 4                                   RQ10.1  RQ10.3
Element: Purch Fr Loc  Enter the suggested purchase from         RQ11.1  RQ13.2
                       location for the entered vendor. Vendors  RQ35.1  RQ500
                       can have multiple purchase from           RQIB.1  RQIF.1
                       locations. The purchase from location     RQII.1  RQIJ.1
                       code prints on the requisition when you
                       run Print Requisitions (RQ111). As with
                       the vendor code, the purchase from
                       location can be changed when a purchase
                       order is created for the requisition.
                       The purchase from location code must be
                       defined in Vendor Location (AP10.2).

RQH-VENDOR-NAME        Alpha 30                                  RQ10.1  RQ10.3
Element: Vendor Name   Enter the recommended vendor's name for   RQ11.1  RQ13.2
                       the requisition. If left blank, this      RQ35.1  RQ500
                       defaults to the vendor's name defined in  RQIB.1  RQIF.1
                       the Accounts Payable (AP) Vendor form.    RQII.1  RQIJ.1

RQH-PRINT-REQ-FL       Alpha 1                                   RQ10.1  RQ10.3
Element: All Flag      This flag indicates whether you want to   RQ11.1  RQ111
                       print the requisition in RQ111 (Print     RQ13.2  RQ35.1
                       Requisitions). This flag defaults based   RQ500   RQIB.1
                       on the approval assigned to the           RQIF.1  RQII.1
                       requester. It can be overridden when the  RQIJ.1
                       requisition is created.

                       Once the requisition has been printed,
                       this flag is changed to No, do not print
                       the requisition. You can print the
                       requisition after it has been printed by
                       specifying the requisition in RQ111
                       (Print Requisitions).
                       N = No
                       Y = Yes

RQH-LAST-LINE-NBR      Numeric 6                                 RQ10.1  RQ10.3
Element: Line Nbr      The number of the last line item added    RQ11.1  RQ13.2
                       to the requisition. This number           RQ35.1  RQ500
                       determines what  the next line number is  RQIB.1  RQIF.1
                       when you add  another item.               RQII.1  RQIJ.1

RQH-LAST-DEL-SEQ       Numeric 3                                 PO30.1  PO30.2
Element: Seq           This field contains the record sequence   PO30.3  POID.1
                       number.                                   RQ10.1  RQ10.3
                                                                 RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-RETURN-SEQ         Numeric 3                                 RQ10.1  RQ10.3
Element: Seq           This number indicates the number of       RQ11.1  RQ13.2
                       times a return has been made against a    RQ35.1  RQ500
                       requisition.                              RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-STATUS             Numeric 1                                 PO100   PO23.1
Element: Status        This is the processing status of the      RQ10.1  RQ10.3
                       requisition as described below.           RQ11.1  RQ12.1
                                                                 RQ13.1  RQ13.2
                       Released = Requisition has been released  RQ35.1  RQ500
                       in RQ10.1 (Requisition).                  RQD1.1  RQIB.1
                                                                 RQIF.1  RQII.1
                       Unreleased = Requisition added but not    RQIJ.1
                       released in RQ10.1 (Requisition).

                       Closed = Every requisition line is fully
                       delivered or backorders are canceled.

                       Rejected = The approver has rejected the
                       requisition. This closes the
                       requisition, which cannot be reopened.

                       Processed = The requisition has been
                       fully approved.
                       0 = Unreleased
                       1 = Released
                       5 = In Process
                       9 = Processed
                       8 = Rejected

RQH-PO-USER-FLD-1      Alpha 1                                   RQ10.1  RQ10.3
Element: Po User Fld 1 Purchase Order header user field one.     RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-PO-USER-FLD-3      Alpha 30                                  RQ10.1  RQ10.3
Element: User Field2   Purchase Order header user field three.   RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-PO-USER-FLD-5      Alpha 30  (Lower Case)                    RQ10.1  RQ10.3
Element: User Fld2     Purchase Order header user field five.    RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-USER-DATE-1        Numeric 8  (yyyymmdd)                     RQ10.1  RQ10.3
Element: Date          This field displays the system date       RQ11.1  RQ13.2
                       when this was created.                    RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-USER-DATE-2        Numeric 8  (yyyymmdd)                     RQ10.1  RQ10.3
Element: Date          This field displays the system date       RQ11.1  RQ13.2
                       when this was created.                    RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-LAST-APRV-DT       Numeric 8  (yyyymmdd)                     RQ10.1  RQ10.3
Element: Date          This is the last approval date for the    RQ11.1  RQ12.1
                       requisition. Requisitions are approved    RQ13.1  RQ13.2
                       in RQ12.1 (Approval Review).              RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-APPROVED-FL        Alpha 1                                   RQ10.1  RQ10.3
Element: All Flag      This flag indicates that this             RQ11.1  RQ12.1
                       requisition has been approved at all      RQ13.1  RQ13.2
                       required approval levels. Required        RQ35.1  RQ500
                       approval levels are defined by amount in  RQIB.1  RQIF.1
                       RQ02.1 (Approval Codes).                  RQII.1  RQIJ.1
                       N = No
                       Y = Yes

RQH-ATTAIN-LEVEL       Numeric 1                                 RQ10.1  RQ10.3
Element: Aprv Level    This is the highest approval level        RQ11.1  RQ12.1
                       required for the requisition. The         RQ13.1  RQ13.2
                       requisition must be approved at this      RQ35.1  RQ500
                       level for further processing.             RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-APRV-LEVEL         Numeric 1                                 RQ10.1  RQ10.3
Element: Aprv Level    This is the approval level that this      RQ11.1  RQ12.1
                       requisition has attained so far in        RQ13.1  RQ13.2
                       RQ12.1 (Approval Review).                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-NBR-LINES          Numeric 6                                 RQ10.1  RQ10.3
Element: Nbr Lines     This is the number of detail lines.       RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-CLOSED-LINES       Numeric 6                                 RQD1.1
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                                   AP125   AP126
Element: Closed Fl     The Closed Flag.                          AP131   AP20.1
                       Y = Yes                                   AP20.2  AP20.3
                       N = No                                    AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  CXCP.1
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  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
                                                                 ...

RQH-I-TOTAL            Signed 18.2                               RQ10.1  RQ10.3
Element: Intl Amt                                                RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-N-TOTAL            Signed 18.2                               RQ10.1  RQ10.3
Element: Intl Amt                                                RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-X-S-TOTAL          Signed 18.2                               RQ10.1  RQ10.3
Element: Intl Amt                                                RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-PRINTED-FL         Alpha 1                                   RQ10.1  RQ10.3
Element: Printed Fl    This flag indicates whether the           RQ11.1  RQ111
                       requisition has been printed in RQ111     RQ13.2  RQ35.1
                       (Print Requisitions).                     RQ500   RQIB.1
                                                                 RQIF.1  RQII.1
                                                                 RQIJ.1

RQH-ALLOC-PRI          Numeric 2                                 RQ10.1  RQ10.3
Element: Alloc Pri     This is the allocation priority for       RQ11.1  RQ13.2
                       this requisition. Valid values are from   RQ35.1  RQ500
                       0 to 99, with 99 being the highest. This  RQIB.1  RQIF.1
                       field defaults to 50.  This field is      RQII.1  RQIJ.1
                       used in the Warehouse module to
                       determine the order in which inventory
                       demand gets allocated.

RQH-QUOTE-FL           Alpha 1                                   RQ10.1  RQ10.3
Element: Quote Fl      This flag indicates if the buyer should   RQ11.1  RQ13.2
                       get quotes for this requisition before    RQ35.1  RQ500
                       it is turned into a purchase order.       RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-RETURN-NOTE        Alpha 12                                  RQ10.1  RQ10.3
Element: Note          This is a user defined field available    RQ11.1  RQ13.2
                       for data entry in RQ35.1 (Requisition     RQ35.1  RQ500
                       Returns).                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-RETURN-DATE        Numeric 8  (yyyymmdd)                     RQ10.1  RQ10.3
Element: Date          This is the return transaction date for   RQ11.1  RQ13.2
                       a requisition item processed in RQ35.1    RQ35.1  RQ500
                       (Requisition Returns).                    RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-ACTIVITY           Alpha 15                                  RQ10.1  RQ10.3
Element: Activity      Activities are the processes or           RQ11.1  RQ13.2
                       procedures that produce work. Cost        RQ35.1  RQ500
                       objects (products, services, customers,   RQIB.1  RQIF.1
                       and so on) are the reasons for            RQII.1  RQIJ.1
                       performing the activity.


RQH-ACCT-CATEGORY      Alpha 5                                   RQ10.1  RQ10.3
Element: Acct Category Account categories are groupings of       RQ11.1  RQ13.2
                       costs, revenues, or a combination of      RQ35.1  RQ500
                       both used for reporting and inquiries     RQIB.1  RQIF.1
                       for activities in the Activity            RQII.1  RQIJ.1
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

RQH-BILL-CATEGORY      Alpha 32                                  RQ10.1  RQ10.3
Element: Bill Category                                           RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-ACCT-UNIT          Alpha 15                                  RQ10.1  RQ10.3
Element: Acct Unit     The accounting unit is a shorthand        RQ11.1  RQ13.2
                       notation representing the variable level  RQ35.1  RQ500
                       number. When used in the General Ledger   RQIB.1  RQIF.1
                       Account Master file, the accounting unit  RQII.1  RQIJ.1
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


RQH-ACCOUNT            Numeric 6                                 RQ10.1  RQ10.3
Element: Account       This field along with the accounting      RQ11.1  RQ13.2
                       unit and subaccount make up the location  RQ35.1  RQ500
                       (account) where amounts and other         RQIB.1  RQIF.1
                       account information is stored.            RQII.1  RQIJ.1

RQH-SUB-ACCT           Numeric 4                                 RQ10.1  RQ10.3
Element: Sub Acct      This field contains the subaccount from   RQ11.1  RQ13.2
                       your general ledger chart of accounts     RQ35.1  RQ500
                       that was charged with the amount carried  RQIB.1  RQIF.1
                       on this record.                           RQII.1  RQIJ.1

RQH-DIST-COMPANY       Numeric 4                                 RQ10.1  RQ10.3
Element: Company       Identifies the AP company if the          RQ11.1  RQ13.2
                       resource type = V.  Identifies the HR     RQ35.1  RQ500
                       company if the resource type = E.  It is  RQIB.1  RQIF.1
                       blank for type A, P or Q resources.       RQII.1  RQIJ.1

RQH-ASSET              Numeric 10                                RQ10.1  RQ10.3
Element: Asset         The asset number contains up to ten       RQ11.1  RQ13.2
                       numeric characters that uniquely          RQ35.1  RQ500
                       identify an asset. Assets are             RQIB.1  RQIF.1
                       automatically numbered system-wide.       RQII.1  RQIJ.1

RQH-ASSET-TEMPLATE     Alpha 10                                  RQ10.1  RQ10.3
Element: Asset TemplateA user-defined asset template             RQ11.1  RQ13.2
                       identifies general asset creation         RQ35.1  RQ500
                       parameters that you can use to quickly    RQIB.1  RQIF.1
                       add assets with minimal keying. Using a   RQII.1  RQIJ.1
                       template lets you default many data
                       items associated with a new asset.

                       You can use an asset template to
                       process quick asset additions in AM20.1
                       (Quick Addition) and to create assets
                       and asset books from Accounts Payable
                       and Activity Management interface
                       information. Asset templates are
                       required if you define new assets as a
                       result of transactions interfaced from
                       the Lawson Purchase Order or Accounts
                       Payable systems.

RQH-PURCH-TAX-CD       Alpha 10                                  RQ10.1  RQ10.3
Element: Tax Code      This field contains a code representing   RQ11.1  RQ13.2
                       specific tax information.  This must be   RQ35.1  RQ500
                       valid Tax Code.                           RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-PURCH-TAX-FL       Alpha 1                                   RQ10.1  RQ10.3
Element: Purch Tax Fl  This field indicates if this item is      RQ11.1  RQ13.2
                       taxable when it is purchased for this     RQ35.1  RQ500
                       location. Valid values are:               RQIB.1  RQIF.1
                       N = Nontaxable.  Default value.           RQII.1  RQIJ.1
                       Y = Taxable.

RQH-OPERATOR-ID        Alpha 10                                  RQ10.1  RQ10.3
Element: Operator      This is the terminal signon identifier    RQ11.1  RQ13.2
                       when this requisition was added to the    RQ35.1  RQ500
                       database.                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-DROPSHIP-FL        Alpha 1                                   RQ10.1  RQ10.3
Element: Dropship Fl   This flag indicates whether goods being   RQ11.1  RQ13.2
                       shipped by the vendor directly to a non   RQ35.1  RQ500
                       standard location need to have the        RQIB.1  RQIF.1
                       receiving process performed.              RQII.1  RQIJ.1
                       Y = Yes
                       N = No

RQH-SH-NAME            Alpha 30  (Lower Case)                    RQ10.1  RQ10.3
Element: Name          Displays the company description.         RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-SH-ADDR1           Alpha 30  (Lower Case)                    RQ10.1  RQ10.3
Element: Addr1         This field contains the first line of     RQ11.1  RQ13.2
                       address information.                      RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-SH-ADDR2           Alpha 30  (Lower Case)                    RQ10.1  RQ10.3
Element: Addr1         This field contains the first line of     RQ11.1  RQ13.2
                       address information.                      RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-SH-ADDR3           Alpha 30  (Lower Case)                    RQ10.1  RQ10.3
Element: Addr1         This field contains the first line of     RQ11.1  RQ13.2
                       address information.                      RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-SH-ADDR4           Alpha 30  (Lower Case)                    RQ10.1  RQ10.3
Element: Addr1         This field contains the first line of     RQ11.1  RQ13.2
                       address information.                      RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-SH-CITY-ADDR5      Alpha 18  (Lower Case)                    RQ10.1  RQ10.3
Element: City          This field contains the city of the       RQ11.1  RQ13.2
                       address.                                  RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-SH-STATE-PROV      Alpha 2                                   RQ10.1  RQ10.3
Element: State Prov    The state or province.                    RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-SH-POST-CODE       Alpha 10  (Lower Case)                    RQ10.1  RQ10.3
Element: Sh Post Code  This is the ship to mail code.            RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-SH-COUNTRY-CD      Alpha 2                                   RQ10.1  RQ10.3
Element: Sh Country Cd                                           RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-SH-COUNTRY         Alpha 30  (Lower Case)                    RQ10.1  RQ10.3
Element: Country       This field contains the country of the    RQ11.1  RQ13.2
                       address, or it can be used for            RQ35.1  RQ500
                       additional information such as an         RQIB.1  RQIF.1
                       attention name.                           RQII.1  RQIJ.1

RQH-SH-COUNTY          Alpha 25  (Lower Case)                    RQ10.1  RQ10.3
Element: County        The county for the company address.       RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-SH-PHONE-PREF      Alpha 6                                   RQ10.1  RQ10.3
Element: Phone Prefix  The telephone number country code.        RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-SH-PHONE           Alpha 15                                  RQ10.1  RQ10.3
Element: Phone         Phone number.                             RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-SH-PHONE-EXT       Alpha 5                                   RQ10.1  RQ10.3
Element: Phone Ext     This field contains the telephone         RQ11.1  RQ13.2
                       extension number.                         RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-SH-CONTACT         Alpha 30  (Lower Case)                    RQ10.1  RQ10.3
Element: Addr Contact  This is the name of the main contact.     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                                  RQ10.1  RQ10.3
Element: Pflow Aprv Lvl                                          RQ11.1  RQ13.1
                                                                 RQ13.2  RQ35.1
                                                                 RQ500   RQIB.1
                                                                 RQIF.1  RQII.1
                                                                 RQIJ.1

RQH-APPROVAL-TYPE      Alpha 1                                   RQ10.1  RQ10.3
Element: Approval Type The type of approval record.              RQ11.1  RQ13.2
                       0 = Header approval-Approval codes        RQ35.1  RQ500
                       1 = Header approval-Process Flow          RQIB.1  RQIF.1
                       2 = Line approval                         RQII.1  RQIJ.1
                       3 = No approval required

RQH-APPROVE-CD         Alpha 5                                   RQ10.1  RQ10.3
Element: Approve Cd    This is a code to identify the approval   RQ11.1  RQ13.2
                       process (levels) that a requisition has   RQ35.1  RQ500
                       to pass before it can be picked or        RQIB.1  RQIF.1
                       purchased.                                RQII.1  RQIJ.1

RQH-BASE-CURR-CODE     Alpha 5                                   RQ10.1  RQ10.3
Element: Currency Code This field contains the company base      RQ11.1  RQ13.2
                       currency code established in Company      RQ35.1  RQ500
                       (GL10.1 ).                                RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-TRAN-CURR-CODE     Alpha 5                                   RQ10.1  RQ10.3
Element: Currency Code This field contains the company base      RQ11.1  RQ13.2
                       currency code established in Company      RQ35.1  RQ500
                       (GL10.1 ).                                RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-POB-NAME           Alpha 30  (Lower Case)
Element: Name          Displays the company description.

RQH-POB-ADDR1          Alpha 30  (Lower Case)
Element: Addr1         This field contains the first line of
                       address information.

RQH-POB-ADDR2          Alpha 30  (Lower Case)
Element: Addr1         This field contains the first line of
                       address information.

RQH-POB-ADDR3          Alpha 30  (Lower Case)
Element: Addr1         This field contains the first line of
                       address information.

RQH-POB-ADDR4          Alpha 30  (Lower Case)
Element: Addr1         This field contains the first line of
                       address information.

RQH-POB-CITY-ADDR5     Alpha 18  (Lower Case)
Element: City          This field contains the city of the
                       address.

RQH-POB-STATE-PROV     Alpha 2
Element: State Prov    The state or province.

RQH-POB-POSTAL-CD      Alpha 10  (Lower Case)
Element: Postal Code   This field contains the postal code.

RQH-POB-COUNTRY-CD     Alpha 2
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

RQH-POB-COUNTY         Alpha 25  (Lower Case)
Element: County        The county for the company address.

RQH-POB-CONTACT        Alpha 30  (Lower Case)
Element: Addr Contact  This is the name of the main contact.

RQH-RQ-SOURCE          Numeric 2                                 RQ10.1  RQ10.3
Element: Rq Source     00 = Upgrade                              RQ11.1  RQ13.2
                       01 = IC142                                RQ35.1  RQ500
                       02 = IC141                                RQIB.1  RQIF.1
                       03 = IC83                                 RQII.1  RQIJ.1
                       04 = RQ35
                       05 = RQ500
                       06 = RSS
                       07 = RQ10
                       08 = DR100

RQH-ONE-SRC-ONE-PO     Numeric 1                                 RQ10.1  RQ10.3
Element: One Src One Po0                                         RQ11.1  RQ13.2
                       1                                         RQ35.1  RQ500
                       2 = One Requisition to One PO             RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

RQH-PCARD-NBR          Alpha 16
Element: Pcard Nbr

RQH-SS-EVENT-REQD      Numeric 1                                 RQ10.1  RQ10.3
Element: Ss Event Reqd                                           RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQII.1  RQIJ.1

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

                         REQHEADER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RQHSET1   COMPANY                                                AP125   AP126
          REQ-NUMBER                                             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  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  CXCP.1
                                                                 ...

RQHSET2   COMPANY       KeyChange                                RQ01.1  RQ111
          REQ-LOCATION                                           RQ140   RQ300
          REQUESTER                                              RQ40.1
          REQ-NUMBER

RQHSET3   REQUESTER                                              RQ10.1  RQ35.1
          REQ-NUMBER*                                            RQ500   RQIF.1
          COMPANY

RQHSET4   FROM-COMPANY  KeyChange                                RQ41.1
          FROM-LOCATION
          STATUS
          COMPANY
          REQ-NUMBER

RQHSET5   COMPANY       KeyChange, Subset
          REFERENCE-NO  Where REFERENCE-NO != Spaces
          REQ-NUMBER

RQHSET6   COMPANY       KeyChange, Subset
          REQ-DESC      Where REQ-DESC != Spaces
          REQ-NUMBER

RQHSET7   REQUESTER                                              RQ04.1  RQ10.1
          REQ-NUMBER                                             RQ500   RQCP.1
          COMPANY                                                RQD1.1  RQIF.1
                                                                 RQII.1  RQIJ.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      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       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