Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PORETURNLN


                            PORETURNLN FILE

                             PO Return Line

REFERENCED BY

API2.1    IC130     MA540     PO132     PO231     PO274
PO58.2    POCP.1    MM280     MM80.1    MM80.2    PO64.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    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     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.1    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
POD0.1    POI3.1    POID.1    POII.1    POIJ.1    RQ10.1
RQ10.2    WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PTL-COMPANY            Numeric 4                                 MA531   PO30.1
Element: Company       The company number.                       PO30.2  PO30.3
                                                                 PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-RETURN-NUMBER      Numeric 10                                MA531   PO30.1
Element: Return Number This is the number assigned to the        PO30.2  PO30.3
                       return for purposes of referencing the    PO31.1  PO31.2
                       return internally and with the customer   PO33.1  PO34.1
                       or vendor.                                PO52.1

PTL-RETURN-NUMBERA     Alpha 10  (Right Justified)               MA531   PO30.1
Element: Return Numbera                                          PO30.2  PO30.3
                                                                 PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-REFERENCE-NO       Alpha 10  (Right Justified)               AP125   AP126
Element: Reference No                                            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  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
                                                                 ...

PTL-RET-LINE-NBR       Numeric 6                                 MA531   PO30.1
Element: Line Nbr      This field contains the line number.      PO30.2  PO30.3
                                                                 PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-ORIG-PO-NBR        Alpha 14  (Right Justified)               MA531   PO30.1
Element: Po Number     This is the original purchase order       PO30.2  PO30.3
                       number the return line is from.           PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-ORIG-PO-REL        Numeric 4                                 MA531   PO30.1
Element: Po Release    This is the release number of the         PO30.2  PO30.3
                       original purchase order the return line   PO31.1  PO31.2
                       is from.                                  PO33.1  PO34.1
                                                                 PO52.1

PTL-ORIG-PO-CODE       Alpha 4                                   MA531   PO30.1
Element: Po Code       This is the purchase order code.          PO30.2  PO30.3
                                                                 PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-ORIG-PO-LN-NBR     Numeric 6                                 MA531   PO30.1
Element: Line Nbr      This is the line number of the original   PO30.2  PO30.3
                       purchase order the return line is from.   PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-DOC-NBR-NUM        Numeric 10                                MA531   PO30.1
Element: Doc Nbr Num   For return lines created from inspection  PO30.2  PO30.3
                       rejections, this field holds the          PO31.1  PO31.2
                       document number of the rejection to       PO33.1  PO34.1
                       allow for drill backs.                    PO52.1

PTL-REC-NUMBER         Numeric 10                                MA531   PO30.1
Element: Rec Number    The receiver number the return line was   PO30.2  PO30.3
                       created from as a result of a receiving   PO31.1  PO31.2
                       buyer message.                            PO33.1  PO34.1
                                                                 PO52.1

PTL-ITEM               Alpha 32                                  MA531   PO30.1
Element: Item          This field contains the item              PO30.2  PO30.3
                       identifier.                               PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-MATCH-DTL-KEY      Alpha 85                                  MA531   PO30.1
Element: Match Dtl Key                                           PO30.2  PO30.3
                                                                 PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-DESCRIPTION        Alpha 30  (Lower Case)                    MA531   PO30.1
Element: Description   This is the item description.             PO30.2  PO30.3
                                                                 PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-ITEM-TYPE          Alpha 1                                   MA531   PO30.1
Element: Item Type     This field identifies the line item       PO30.2  PO30.3
                       type.                                     PO31.1  PO31.2
                       I = Inventoried                           PO33.1  PO34.1
                       N = Non-stock                             PO52.1
                       X = Special
                       S = Service

PTL-RETURN-QTY         Signed 13.4                               MA531   PO30.1
Element: Quantity      This is the quantity on the return line.  PO30.2  PO30.3
                                                                 PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-ADJUSTMENT-QTY     Signed 13.4                               AP125   AP126
Element: Quantity      This field contains the desired           AP131   AP20.1
                       quantity.                                 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  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
                                                                 ...

PTL-CATCH-WT-QTY       Signed 13.4                               MA531   PO30.1
Element: Quantity      This field contains the desired           PO30.2  PO30.3
                       quantity.                                 PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-DETAIL-BAL-FL      Alpha 1                                   MA531   PO30.1
Element: All Flag      Y = Yes                                   PO30.2  PO30.3
                       N = No                                    PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO52.1

PTL-ENTERED-UOM        Alpha 4                                   MA531   PO30.1
Element: Uom           This is the valid unit of measure of      PO30.2  PO30.3
                       the entered quantity.                     PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-ENT-UOM-MULT       Signed 13.7                               MA531   PO30.1
Element: Uom Mult      This is the multiplier that relates the   PO30.2  PO30.3
                       entered unit of measure to stock unit of  PO31.1  PO31.2
                       measure.                                  PO33.1  PO34.1
                                                                 PO52.1

PTL-VPRI-UOM           Alpha 4                                   MA531   PO30.1
Element: Uom           This field contains the valid stock       PO30.2  PO30.3
                       unit of measure for this item.            PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-VPRI-UOM-MULT      Signed 13.7                               MA531   PO30.1
Element: Uom Mult      This field contains the multiplier for    PO30.2  PO30.3
                       converting this unit of measure to the    PO31.1  PO31.2
                       stock unit of measure.                    PO33.1  PO34.1
                                                                 PO52.1

PTL-UNIT-COST          Signed 18.5                               AP125   AP126
Element: Intl Cost                                               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  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
                                                                 ...

PTL-INSP-REQ-FL        Alpha 1                                   MA531   PO30.1
Element: All Flag      This flag indicates whether this item     PO30.2  PO30.3
                       has to be inspected when received via     PO31.1  PO31.2
                       purchase order.                           PO33.1  PO34.1
                       N = No                                    PO52.1
                       Y = Yes

PTL-TAX-CODE           Alpha 10                                  MA531   PO30.1
Element: Tax Code      This field contains a code representing   PO30.2  PO30.3
                       specific tax information.  This must be   PO31.1  PO31.2
                       valid Tax Code.                           PO33.1  PO34.1
                                                                 PO52.1

PTL-TAX-USAGE-CD       Alpha 10                                  MA531   PO30.1
Element: Tax Usage Cd  The tax usage coe for the vendor.  This   PO30.2  PO30.3
                       filed is required if the AP Company       PO31.1  PO31.2
                       inidcates that VAT reporting required.    PO33.1  PO34.1
                                                                 PO52.1

PTL-LAST-DST-SEQ       Numeric 3                                 AP125   AP126
Element: Seq           This is the sequence number of the last   AP131   AP20.1
                       distribution line for this return line.   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  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
                                                                 ...

PTL-LAST-POT-SEQ       Numeric 6                                 MA531   PO30.1
Element: Last Pot Seq                                            PO30.2  PO30.3
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO32.4
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-CANCEL-OPTIONS     Alpha 1                                   AP125   AP126
Element: New Quantity FThis option indicates at header or line   AP131   AP20.1
                       level, whether both a return and return   AP20.2  AP20.3
                       purchase order should be canceled, or     AP20.4  AP20.5
                       just one or the other. If a cancel        AP20.7  AP21.1
                       option is chosen at line level, a cancel  AP23.1  AP25.1
                       quantity must also be entered. Once a     AP25.2  AP26.1
                       cancel option is set, it cannot be        AP27.1  AP30.4
                       changed or undone.                        API1.1  BL120
                       Y = Canceled                              BL122   BL130
                       N                                         BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.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
                                                                 ...

PTL-ICN-CODE           Alpha 8                                   MA531   PO30.1
Element: Icn Code                                                PO30.2  PO30.3
                                                                 PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-SUPLMNTARY-QTY     Signed 13.4                               MA531   PO30.1
Element: Quantity      This field contains the desired           PO30.2  PO30.3
                       quantity.                                 PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-WEIGHT             Signed 9.3                                MA531   PO30.1
Element: Weight        This field contains the unit weight of    PO30.2  PO30.3
                       the item based on the stocking UOM.       PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-INTRASTAT-NBR      Numeric 12                                AP125   AP126
Element: Intrastat Nbr The number assigned by the Intrastat      AP131   AP20.1
                       system to a transaction that involves     AP20.2  AP20.3
                       Intrastat reporting after it has been     AP20.4  AP20.5
                       added.                                    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  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
                                                                 ...

PTL-VR-CXL-UPD-SOH     Numeric 1                                 AP125   AP126
Element: Vr Cxl Upd Soh                                          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  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
                                                                 ...

                         PORETURNLN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PTLSET1   COMPANY                                                AP125   AP126
          RETURN-NUMBER                                          AP131   AP20.1
          RET-LINE-NBR                                           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  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 ...

PTLSET2   COMPANY       Subset                                   AP125   AP126
          RETURN-NUMBERAWhere ITEM-TYPE = "I"                    AP131   AP20.1
          RET-LINE-NBR                                           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  MA180
                                                                 ...

PTLSET3   COMPANY       Subset                                   AP125   AP126
          ORIG-PO-NBR   Where ORIG-PO-NBR != Spaces              AP131   AP20.1
          ORIG-PO-REL                                            AP20.2  AP20.3
          ORIG-PO-CODE                                           AP20.4  AP20.5
          ORIG-PO-LN-NBR                                         AP20.7  AP21.1
          RETURN-NUMBER                                          AP23.1  AP25.1
          RET-LINE-NBR                                           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  MA180
                                                                 ...

PTLSET4   COMPANY       KeyChange                                AP125   AP126
          RETURN-NUMBER                                          AP131   AP20.1
          RET-LINE-NBR                                           AP20.2  AP20.3
          ITEM-TYPE                                              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  MA180
                                                                 ...

                         PORETURNLN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccategory     ICCATEGORY   Required
                            When PTL-ITEM-TYPE = "I"

                            PTL-COMPANY           -> ICA-COMPANY
                            PTH-RETURN-FRM-LOC    -> ICA-LOCATION
                            ITL-GL-CATEGORY       -> ICA-GL-CATEGORY

Iccompany      ICCOMPANY    Required

                            PTL-COMPANY           -> ICC-COMPANY

Inspreturns    PORECADJLN   Required

                            PTL-COMPANY           -> PJL-COMPANY
                            "IN"                  -> PJL-DOC-TYPE
                            PTL-DOC-NBR-NUM       -> PJL-DOC-NBR-NUM
                            PTL-ORIG-PO-LN-NBR    -> PJL-LINE-NBR

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

                            PTL-COMPANY           -> ITL-COMPANY
                            PTH-RETURN-FRM-LOC    -> ITL-LOCATION
                            PTL-ITEM              -> ITL-ITEM

Itemmast       ITEMMAST     Required
                            When PTL-ITEM-TYPE = "I"
                            Or   PTL-ITEM-TYPE = "N"

                            ICC-ITEM-GROUP        -> ITE-ITEM-GROUP
                            PTL-ITEM              -> ITE-ITEM

Original Po    POLINE       Required

                            PTL-COMPANY           -> PLI-COMPANY
                            PTL-ORIG-PO-NBR       -> PLI-PO-NUMBER
                            PTL-ORIG-PO-REL       -> PLI-PO-RELEASE
                            PTL-ORIG-PO-CODE      -> PLI-PO-CODE
                            PTL-ORIG-PO-LN-NBR    -> PLI-LINE-NBR

Porecadjln     PORECADJLN   Required
                            When PTL-DOC-NBR-NUM != Zeroes

                            PTL-COMPANY           -> PJL-COMPANY
                            "IN"                  -> PJL-DOC-TYPE
                            PTL-DOC-NBR-NUM       -> PJL-DOC-NBR-NUM
                            PTL-ORIG-PO-LN-NBR    -> PJL-LINE-NBR

Porecadjln2    PORECADJLN   Required
                            When PTL-DOC-NBR-NUM != Zeroes

                            PTL-COMPANY           -> PJL-COMPANY
                            "RA"                  -> PJL-DOC-TYPE
                            PTL-DOC-NBR-NUM       -> PJL-DOC-NBR-NUM
                            PTL-ORIG-PO-LN-NBR    -> PJL-LINE-NBR

Porecline      PORECLINE    Required
                            When PTL-REC-NUMBER != Zeroes

                            PTL-COMPANY           -> PRL-COMPANY
                            PTL-REC-NUMBER        -> PRL-REC-NUMBER
                            PTL-ORIG-PO-LN-NBR    -> PRL-LINE-NBR

Returnheader   PORETURNHD   Required

                            PTL-COMPANY           -> PTH-COMPANY
                            PTL-RETURN-NUMBER     -> PTH-RETURN-NUMBER

                         PORETURNLN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mmdist         MMDIST
                            Valid When PTL-ITEM-TYPE != "I"

                            PTL-COMPANY           -> MMD-COMPANY
                            "PO"                  -> MMD-SYSTEM-CD
                            PTH-RETURN-FRM-LOC    -> MMD-LOCATION
                            "VR"                  -> MMD-DOC-TYPE
                            Spaces                -> MMD-DOC-NUMBER
                            PTL-RETURN-NUMBER     -> MMD-DOC-NBR-NUM
                            Spaces                -> MMD-PO-CODE
                            PTL-RET-LINE-NBR      -> MMD-LINE-NBR
                            Zeroes                -> MMD-COMPONENT-SEQ
                            Spaces                -> MMD-AOC-CODE
                                                     MMD-LINE-SEQ
                                                     MMD-REQ-LOCATION
                                                     MMD-API-OBJ-ID

Potransdtl     POTRANSDTL

                            PTL-COMPANY           -> POT-COMPANY
                            "VR"                  -> POT-DOC-TYPE
                            PTL-RETURN-NUMBER     -> POT-DOC-NBR-NUM
                            PTL-RET-LINE-NBR      -> POT-LINE-NBR
                                                     POT-TRANS-SEQ

Sohdetail      SOHDETAIL
                            Valid When PTL-ITEM-TYPE = "I"

                            PTL-COMPANY           -> SDT-COMPANY
                            PTH-RETURN-FRM-LOC    -> SDT-LOCATION
                            PTL-ITEM              -> SDT-ITEM
                                                     SDT-UOM
                                                     SDT-LOT
                                                     SDT-SUBLOT
                                                     SDT-BIN