PORETLNDTL FILE

                         PO Return Line Detail

REFERENCED BY

PO132

UPDATED BY

PO32.2    PO31.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PTD-COMPANY          Numeric 4                                   PO32.2
Company              The company number.

PTD-RETURN-NUMBER    Numeric 10                                  PO32.2
Return Number        This is the number assigned to the
                     return for purposes of referencing the
                     return internally and with the customer
                     or vendor.

PTD-RET-LINE-NBR     Numeric 6                                   PO32.2
Return Line Number   This is the return line number.

PTD-SEQ              Numeric 3                                   PO32.2
Sequence Number      This field contains the record sequence
                     number.

PTD-LOT-SERIAL       Alpha 16                                    PO32.2
Lot/Serial Number    This is the lot/sublot or serial number
                     for this detail record.

PTD-BIN              Alpha 7                                     PO32.2
Bin                  This field contains a storage area for
                     an item or any number of items.

PTD-ITEM             Alpha 32                                    PO32.2
Item Number          This field contains the item
                     identifier.

PTD-QUANTITY         Signed 13.4                                 PO32.2
Quantity             This field contains the requested
                     quantity.

PTD-SECONDARY-QTY    Signed 13.4                                 PO32.2
Secondary Quantity   This field contains the secondary
                     quantity, which is tracked if the item
                     is a catch weight item.  This quantity
                     is a memo quantity only.  It is not used
                     for valuation.

                         PORETLNDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PTDSET1   COMPANY                                                PO132   PO31.1
          RETURN-NUMBER                                          PO32.2
          RET-LINE-NBR
          SEQ

                         PORETLNDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Returnline     PORETURNLN   Required

                            PTD-COMPANY          -> PTL-COMPANY
                            PTD-RETURN-NUMBER    -> PTL-RETURN-NUMBER
                            PTD-RET-LINE-NBR     -> PTL-RET-LINE-NBR