Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RQTRANS


                              RQTRANS FILE

                        Requisition Transactions

This file is the history of all deliveries for all requisitions. This file
contains all requisition line types:  inventory, nonstock, special order, and
services.

REFERENCED BY

RQ235     RQ50.1    IC182     PC210     RQ230

UPDATED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.1    IC20.1    IC20.2    IC21.1    IC21.2
IC22.1    IC22.2    IC24.1    IC24.2    IC25.1    IC28.1
IC500     MA180     MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA66.2    MA66.3    MA67.1    MA67.2
MA70.1    MA75.1    MA80.1    MAI1.1    OE10.1    OE10.2
OE10.3    OE10.4    OE10.5    OE10.6    OE10.7    OE10.8
OE11.1    OE11.4    OE11.8    OE11.9    OE110     OE111
OE113     OE114     OE116     OE129     OE13.2    OE13.3
OE13.5    OE13.6    OE14.4    OE30.1    OE30.2    OE30.3
OE30.4    OE30.5    OE30.6    OE30.7    OE30.9    OE510
OE530     OE81.1    OE810     OE830     OE90.1    OE90.2
PO100     PO101     PO122     PO131     PO20.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO23.1    PO29.1
PO30.1    PO30.2    PO30.3    PO300     PO31.1    PO31.2
PO32.2    PO33.1    PO34.1    PO35.1    PO38.1    PO39.1
PO39.2    PO44.1    PO50.1    PO52.1    PO520     POI3.1
POID.1    POIE.1    POII.1    POIJ.1    RQ10.1    RQ10.2
RQ300     RQ35.1    WH130     WH132     WH190     WH20.2
WH20.7    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     WO132
WO140

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RQT-FROM-COMPANY       Numeric 4                                 AP125   AP126
Element: Company       This is the company that is the source    AP131   AP25.1
                       of the items.                             AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-FROM-LOCATION      Alpha 5                                   AP125   AP126
Element: Location Code This is the inventory location that       AP131   AP25.1
                       supplied the items or it is the purchase  AP25.2  AP26.1
                       order ship to location that received the  AP27.1  AP30.4
                       items.                                    BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-DOC-TYPE           Alpha 2                                   AP125   AP126
Element: Document Type This field contains the type of           AP131   AP25.1
                       transaction.                              AP25.2  AP26.1
                       DT = Direct Transfer                      AP27.1  AP30.4
                       IS = Issue                                BL120   BL122
                       IT = Transfer Issue                       BL130   BL20.1
                       PO = PO Receiving                         BL20.3  BL21.2
                       RR = Requisition Return                   BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-REQ-NUMBER         Numeric 7                                 AP125   AP126
Element: Requisition NuThis is the assigned number to identify   AP131   AP25.1
                       this requisition.                         AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-DOC-NBR-NUM        Numeric 10                                AP125   AP126
Element: Doc Nbr Num                                             AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-SEQ                Numeric 3                                 AP125   AP126
Element: Sequence NumbeThe delivery or return sequence number.   AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-LINE-NBR           Numeric 6                                 AP125   AP126
Element: Line Number   This field contains the requisition       AP131   AP25.1
                       line number.                              AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-TRANS-DATE         Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Transaction DaThe date of the transaction.              AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-ITEM-TYPE          Alpha 1                                   AP125   AP126
Element: Item Type     This field identifies the line item       AP131   AP25.1
                       type.                                     AP25.2  AP26.1
                       I = Inventoried                           AP27.1  AP30.4
                       N = Non-stock                             BL120   BL122
                       X = Special                               BL130   BL20.1
                       S = Service                               BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-ITEM               Alpha 32                                  AP125   AP126
Element: Item Number   This field contains the item              AP131   AP25.1
                       identifier.                               AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-QUANTITY           Signed 13.4                               AP125   AP126
Element: Quantity      This is the delivered quantity.           AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-STOCK-UOM          Alpha 4                                   AP125   AP126
Element: Unit of MeasurThis is the stock unit of measure for     AP131   AP25.1
                       the item.                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-UNIT-COST          Signed 18.5                               AP125   AP126
Element: Intl Cost     This field contains the unit cost.        AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       Identifies the AP company if the          AP131   AP25.1
                       resource type = V.  Identifies the HR     AP25.2  AP26.1
                       company if the resource type = E.  It is  AP27.1  AP30.4
                       blank for type A, P or Q resources.       BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-REQ-LOCATION       Alpha 5                                   AP125   AP126
Element: To Location   The location requisitioning items.        AP131   AP25.1
                       This location can be an inventory or      AP25.2  AP26.1
                       noninventory location.                    AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-NOTE               Alpha 12                                  AP125   AP126
Element: Note          This is the return note entered when      AP131   AP25.1
                       this transaction was created in RQ35.1    AP25.2  AP26.1
                       (Requisition Returns).                    AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-PURCH-MAJOR        Alpha 4                                   AP125   AP126
Element: Major Class   This is the purchasing major class code   AP131   AP25.1
                       that was entered on the requisition       AP25.2  AP26.1
                       line.                                     AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-PURCH-MINOR        Alpha 4                                   AP125   AP126
Element: Minor Class   This is the purchasing minor class code   AP131   AP25.1
                       that was entered on the requisition       AP25.2  AP26.1
                       line.                                     AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 ...

RQT-TRAN-UNIT-COST     Signed 18.5
Element: Intl Cost

RQT-TRAN-CURR-CODE     Alpha 5
Element: Currency Code

RQT-CNV-RATE           Signed 14.7
Entered Conversion
Rate

RQT-LINE-EXT           Derived
Element: Line Ext

                         RQTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RQTSET1   FROM-COMPANY  This index is used to access a           AP125   AP126
          FROM-LOCATION requisition delivery history record for  AP131   AP25.1
          DOC-TYPE      a specific from company and from         AP25.2  AP26.1
          REQ-NUMBER    location, document type, requisition     AP27.1  AP30.4
          DOC-NBR-NUM   number, sequence number, and line        BL120   BL122
          SEQ           number.                                  BL130   BL20.1
          LINE-NBR                                               BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 ...

RQTSET2   FROM-COMPANY  This index is used to access a           AP125   AP126
          FROM-LOCATION requisition delivery history record for  AP131   AP25.1
          ITEM          a transaction date defined for an item   AP25.2  AP26.1
          TRANS-DATE    assigned a specific from company and     AP27.1  AP30.4
          DOC-TYPE      from location.                           BL120   BL122
          REQ-NUMBER                                             BL130   BL20.1
          DOC-NBR-NUM                                            BL20.3  BL21.2
          SEQ                                                    BL21.5  BL29.1
          LINE-NBR                                               BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 ...

RQTSET3   COMPANY       This index is used to access a           AP125   AP126
          REQ-LOCATION  requisition delivery history record for  AP131   AP25.1
          TRANS-DATE    a transaction date defined for an item   AP25.2  AP26.1
          REQ-NUMBER    having a specific requisition number and AP27.1  AP30.4
          DOC-TYPE      document number.                         BL120   BL122
          DOC-NBR-NUM                                            BL130   BL20.1
          SEQ                                                    BL20.3  BL21.2
          LINE-NBR                                               BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC182   IC20.1
                                                                 IC20.2  IC21.1
                                                                 IC21.2  IC22.1
                                                                 IC22.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 ...

RQTSET4   COMPANY
          REQ-LOCATION
          ITEM
          TRANS-DATE
          REQ-NUMBER
          DOC-TYPE
          DOC-NBR-NUM
          SEQ
          LINE-NBR

                         RQTRANS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

From Location  ICLOCATION   Required

                            RQT-FROM-COMPANY     -> ICL-COMPANY  (ICLSET1)
                            RQT-FROM-LOCATION    -> ICL-LOCATION

Iccompany      ICCOMPANY    Required

                            RQT-COMPANY          -> ICC-COMPANY

Item           ITEMMAST     Required
                            When RQT-ITEM-TYPE = "I"
                            Or   RQT-ITEM-TYPE = "N"

                            ICC-ITEM-GROUP       -> ITE-ITEM-GROUP
                            RQT-ITEM             -> ITE-ITEM

Itemloc        ITEMLOC      Required
                            When RQT-ITEM-TYPE = "I"

                            RQT-FROM-COMPANY     -> ITL-COMPANY
                            RQT-FROM-LOCATION    -> ITL-LOCATION
                            RQT-ITEM             -> ITL-ITEM

Req Header     REQHEADER    Required

                            RQT-COMPANY          -> RQH-COMPANY
                            RQT-REQ-NUMBER       -> RQH-REQ-NUMBER

Req Line       REQLINE      Required

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

Rq Location    RQLOC        Required

                            RQT-COMPANY          -> RQL-COMPANY
                            RQT-REQ-LOCATION     -> RQL-REQ-LOCATION