RQLINEDTL FILE

                        Requisition Line Details

This file contains requisition line detail records. These are created if the
item is an inventory item and it was picked from or returned to multiple bins
and/or is lot or serial tracked.

UPDATED BY

RQ35.1    RQ39.1    RQ39.2    RQ39.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RQD-COMPANY          Numeric 4                                   RQ35.1  RQ39.1
Company              The company number represents an            RQ39.2  RQ39.3
                     established company and is entered on
                     all function codes.

RQD-REQ-NUMBER       Numeric 7                                   RQ35.1  RQ39.1
Requisition Number   This is the assigned number to identify     RQ39.2  RQ39.3
                     this requisition.

RQD-LINE-NBR         Numeric 6                                   RQ35.1  RQ39.1
Line Number          This is the requisition line number.        RQ39.2  RQ39.3

RQD-BIN              Alpha 7                                     RQ35.1  RQ39.1
Bin                  This field contains a storage area for      RQ39.2  RQ39.3
                     an item or any number of items.

RQD-LOT-SERIAL       Alpha 16                                    RQ35.1  RQ39.1
Lot/Serial Number    This is the lot/sublot or serial number     RQ39.2  RQ39.3
                     for this detail record.

RQD-UOM              Alpha 4                                     RQ35.1  RQ39.1
Unit of Measure      This field contains the valid stock         RQ39.2  RQ39.3
                     unit of measure for this item.


RQD-UOM-MULT         Signed 13.7                                 RQ35.1  RQ39.1
Unit of Measure      This field contains the multiplier for      RQ39.2  RQ39.3
Multiplier           converting this unit of measure to the
                     stock unit of measure.

RQD-QUANTITY         Signed 13.4                                 RQ35.1  RQ39.1
Quantity             This is the detail transaction quantity.    RQ39.2  RQ39.3

                         RQLINEDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RQDSET1   COMPANY       This index is used to access a           RQ35.1  RQ39.1
          REQ-NUMBER    requisition line detail record by        RQ39.2  RQ39.3
          LINE-NBR      company; requisition number; line; bin,
          BIN           lot number, serial number, or a
          LOT-SERIAL    combination thereof; and unit of
          UOM           measure.

                         RQLINEDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Req Line       REQLINE      Required

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

Serial         ITSERIAL     Not Required

                            RQD-COMPANY       -> SER-COMPANY
                            RLN-ITEM          -> SER-ITEM
                            RQD-LOT-SERIAL    -> SER-SERIAL

                         RQLINEDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Return Detail  RQLINEDTL    Delete Restricted

                            RQD-COMPANY       -> RQD-COMPANY
                            RQD-REQ-NUMBER    -> RQD-REQ-NUMBER
                            RQD-LINE-NBR      -> RQD-LINE-NBR
                                                 RQD-BIN
                                                 RQD-LOT-SERIAL
                                                 RQD-UOM