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     IC282     MA540     PO132     PO231
PO274     PO58.2    POCP.1    IC242     MM280     MM80.1
MM80.2    PO64.1

UPDATED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.4    API1.1    IC28.1    MA180
MA41.2    MA41.7    MA43.1    MA43.2    MA43.3    MA43.9
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    PO100     PO101     PO122     PO131
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.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    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    POII.1    POIJ.1    RQ10.1    RQ10.2    RQ10.3
RQIE.1    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)               MA531   PO30.1
Element: Reference No                                            PO30.2  PO30.3
                                                                 PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-RET-LINE-NBR       Numeric 6                                 MA531   PO30.1
Element: 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 NumThis 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                                                 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 Number   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: Receiver NumbeThe 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 Number   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                               IC282   MA531
Element: Quantity      This is the quantity on the return line.  PO30.1  PO30.2
                                                                 PO30.3  PO31.1
                                                                 PO31.2  PO33.1
                                                                 PO34.1  PO52.1

PTL-ADJUSTMENT-QTY     Signed 13.4                               AP125   AP126
Element: Quantity                                                AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC28.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 PO25.6  PO25.7
                                                                 PO27.2  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 ...

PTL-CATCH-WT-QTY       Signed 13.4                               MA531   PO30.1
Element: Quantity                                                PO30.2  PO30.3
                                                                 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: Unit of MeasurThis 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
Unit of Measure        This is the multiplier that relates the   PO30.2  PO30.3
Multiplier             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: Unit of Measure                                         PO30.2  PO30.3
                                                                 PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-VPRI-UOM-MULT      Signed 13.7                               MA531   PO30.1
Unit of Measure                                                  PO30.2  PO30.3
Multiplier                                                       PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-UNIT-COST          Signed 13.5                               AP125   AP126
Element: Base Cost                                               AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC28.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 PO25.6  PO25.7
                                                                 PO27.2  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 ...

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: Sequence NumbeThis 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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC28.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 PO25.6  PO25.7
                                                                 PO27.2  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 ...

PTL-LAST-POT-SEQ       Numeric 6                                 MA531   PO30.1
Element: Last Pot Seq                                            PO30.2  PO30.3
                                                                 PO31.1  PO31.2
                                                                 PO32.2  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  AP23.1
                       option is chosen at line level, a cancel  AP25.1  AP25.2
                       quantity must also be entered. Once a     AP26.1  AP27.1
                       cancel option is set, it cannot be        AP30.4  API1.1
                       changed or undone.                        IC28.1  MA180
                       Y = Canceled                              MA41.2  MA41.7
                       N                                         MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 PO25.6  PO25.7
                                                                 PO27.2  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 ...

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                                                PO30.2  PO30.3
                                                                 PO31.1  PO31.2
                                                                 PO33.1  PO34.1
                                                                 PO52.1

PTL-WEIGHT             Signed 9.3                                MA531   PO30.1
Element: Unit 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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC28.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 PO25.6  PO25.7
                                                                 PO27.2  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 ...

                         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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 API2.1  IC130
                                                                 IC28.1  IC282
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA540
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC242   IC28.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 ...

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  AP23.1
          RETURN-NUMBER                                          AP25.1  AP25.2
          RET-LINE-NBR                                           AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC28.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 ...

PTLSET4   COMPANY       This key was added to allow alternate    AP125   AP126
          RETURN-NUMBER file access for correcting DBAPIERROR    AP131   AP20.1
          RET-LINE-NBR  problems.                                AP20.2  AP20.3
          ITEM-TYPE     KeyChange                                AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC28.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 ...

                         PORETURNLN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccategory     ICCATEGORY   Not Required
                            Valid 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   Not 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      Not Required
                            Valid When PTL-ITEM-TYPE = "I"

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

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

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

Original Po    POLINE       Not 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   Not Required
                            Valid 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   Not Required
                            Valid 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    Not Required
                            Valid 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