Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PORECLINE FILE

                        PO Line Item Receivings

This file contains purchase order receiving line item detail and status
information.

REFERENCED BY

IC130     IC234     MA231     MA310     MA63.1    MA66.1
MA66.8    MA66.2    PO133     PO199     PO230     PO274
PO64.1    POA3.1    PO277     PO135     PO223     PO275
PO276     PO94.1    IC851     PO85.1    IC12.1

UPDATED BY

POID.1    POIJ.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PRL-COMPANY          Numeric 4                                   MA63.1  POIJ.1
Company              The company number.

PRL-REC-NUMBER       Numeric 10                                  MA63.1  POIJ.1
Receiver Number      The receiver number.  Assigned when
                     this receiving information was added.

PRL-LINE-NBR         Numeric 6                                   MA63.1  POIJ.1
Line Number          This field contains the line number.

PRL-REC-NUMBER-A     Alpha 10  (Right Justified)                 MA63.1  POIJ.1
Rec Number A

PRL-REFERENCE-NO     Alpha 10  (Right Justified)                 MA63.1  POIJ.1
Reference No

PRL-PO-NUMBER        Alpha 14  (Right Justified)                 MA63.1  POIJ.1
PO Number            This field contains the number
                     representing the purchase order.

PRL-PO-RELEASE       Numeric 4                                   MA63.1  POIJ.1
PO Release Number    Used to identify a purchase order
                     release (created from a Blanket or
                     Standing order).

PRL-PO-CODE          Alpha 4                                     MA63.1  POIJ.1
Po Code              This is the purchase order code.

PRL-PO-LINE-NBR      Numeric 6                                   MA63.1  POIJ.1
PO Line Number       The purchase order line number this
                     record is associated with.

PRL-ITEM             Alpha 32                                    MA63.1  POIJ.1
Item Number          This field contains the item
                     identifier.

PRL-DESCRIPTION      Alpha 30  (Lower Case)                      MA63.1  POIJ.1
Description          This field displays the description.

PRL-ITEM-TYPE        Alpha 1                                     MA63.1  POIJ.1
Item Type            This field identifies the line item
                     type.
                     I = Inventoried
                     N = Non-stock
                     S = Service
                     X = Special

PRL-VEN-ITEM         Alpha 32                                    MA63.1  POIJ.1
Vendor Item          The vendor's item identifer.

PRL-LOCATION         Alpha 5                                     MA63.1  POIJ.1
Location Code        This field contains a valid stock
                     location within the company inventory.

PRL-PROCESS-LEVEL    Alpha 5                                     MA63.1  POIJ.1
Process Level        This field contains the process level,
                     which is the reporting hierarchy below
                     company.

PRL-ENT-REC-QTY      Signed 13.4                                 MA63.1  POIJ.1
Entered Received     Entered receipt quantity.
Quantity

PRL-ENT-REC-UOM      Alpha 4                                     MA63.1  POIJ.1
Entered Received UOM Entered valid receipt unit of measure.

PRL-ENT-RUOM-MULT    Signed 13.7                                 MA63.1  POIJ.1
Entered Recvd UOM    This multiplier is used to convert
Multiplier           entered unit of measure quantity down to
                     stock unit of measure.

PRL-REJECT-QTY       Signed 13.4                                 MA63.1  POIJ.1
Inspection Reject    The rejected quantity for this
Quantity             receiving.

PRL-ORIG-REC-QTY     Signed 13.4                                 MA63.1  POIJ.1
Original Received    Any adjustment to the original received
Quantity             quantity is accumulated in the Entered
                     Received Quantity field. This quantity
                     is the original quantity when this
                     receiver was first released.

PRL-CATCH-WT-QTY     Signed 13.4                                 MA63.1  POIJ.1
Catch Weight         This field contains the quantity
Quantity             received for catch weight shipments.

PRL-ORIG-UNIT-CST    Signed 13.5                                 MA63.1  POIJ.1
Orig Unit Cst

PRL-MATCH-UNIT-CST   Signed 13.5                                 MA63.1  POIJ.1
Match Unit Cst

PRL-BIN              Alpha 7                                     MA63.1  POIJ.1
Bin                  This field contains a storage area for
                     an item or any number of items.

PRL-CANCEL-BO-FL     Alpha 1                                     MA63.1  POIJ.1
Cancel Back Order    This flag indicates whether the
Flag                 backordered quantity is to be canceled
                     and the line is to be considered closed.
                     N = No
                     Y = Yes

PRL-INSP-REQ-FL      Alpha 1                                     MA63.1  POIJ.1
Inspection Required  This flag indicates whether this item
Flag                 has to be inspected when received via
                     purchase order.
                     N = No
                     Y = Yes

PRL-DETAIL-BAL-FL    Alpha 1                                     MA63.1  POIJ.1
Detail Balance Flag  This flag is set to Yes when all items
                     received for this line have bins, serial
                     numbers, and/or lots/sublots assigned if
                     necessary.
                     Y = Yes
                     N = No

PRL-STATUS           Numeric 1                                   MA63.1  POIJ.1
Status               Current receiving status for this line.
                     0 = Entered
                     1 = Released/Inspected
                     5 = Released/Requires Inspection
                     6 = Released/Unreleased Inspection

PRL-BUYER-MSG-FLAG   Alpha 1                                     MA63.1  POIJ.1
Buyer Msg Flag       Indicates whether a buyer message exists
                     for this receiving line.
                     Y = Yes
                     N = No

PRL-LAST-POT-SEQ     Numeric 6                                   MA63.1  POIJ.1
Last Pot Seq

PRL-UPDATE-DATE      Numeric 8  (yyyymmdd)                       MA63.1  POIJ.1
Update Date          This field contains the date the record
                     was updated.

PRL-UPDATE-TIME      Numeric 6                                   MA63.1  POIJ.1
Update Time          This field contains the system time
                     when the record was updated.

PRL-REC-DATE         Numeric 8  (yyyymmdd)                       MA63.1  POIJ.1
Receiving Date

PRL-VENDOR           Alpha 9  (Right Justified)                  MA63.1  POIJ.1
Vendor ID            The vendor's identification code.



PRL-INVOICE          Alpha 22                                    MA63.1  POIJ.1
Invoice Number       Used to identify the invoice.

PRL-SUFFIX           Numeric 3                                   MA63.1  POIJ.1
Invoice Suffix       This is the suffix for the invoice.

PRL-MSDS-FLAG        Alpha 1                                     MA63.1  POIJ.1
Material Safety      This flag indicates if this item
DataSheet Flag       requires a Material Safety Data Sheet.
                     N = No
                     Y = Yes

PRL-MSDS-VERSION     Alpha 4                                     MA63.1  POIJ.1
Msds Version         The version number of the most recent
                     MSDS that was received.

PRL-MSDS-DOCUMENT    Alpha 30                                    MA63.1  POIJ.1
Msds Document        The document number from the most
                     recent MSDS that was received.

PRL-MATCH-CLASS      Alpha 10                                    MA63.1  POIJ.1
Match Class

PRL-MATCHED-QTY      Signed 13.4                                 MA63.1  POIJ.1
Matched Qty

PRL-MATCH-OBJ-ID     Numeric 12                                  MA63.1  POIJ.1
Match Obj Id

PRL-MATCH-DTL-KEY    Alpha 55                                    MA63.1  POIJ.1
Match Dtl Key

PRL-ARCHIVE-QTY      Signed 13.4                                 MA63.1  POIJ.1
Archive Qty

PRL-ARCH-WO-QTY      Signed 13.4                                 MA63.1  POIJ.1
Arch Wo Qty

PRL-VPRI-QUANTITY    Signed 13.4                                 MA63.1  POIJ.1
Vendor Price         The entered line quantity system
Quantity             converted to vendor pricing terms.

PRL-VPRI-UOM         Alpha 4                                     MA63.1  POIJ.1
Vendor Price Unit    This is the vendor pricing unit of
of Measure           measure.

PRL-VPRI-UOM-MULT    Signed 13.7                                 MA63.1  POIJ.1
Vendor Price UOM     This is the vendor pricing unit of
Multiplier           measure multiplier. It is used to
                     convert unit cost to stock unit of
                     measure terms.

PRL-BUOM-QTY         Signed 13.4                                 MA63.1  POIJ.1
Buom Qty

PRL-VBUY-UOM         Alpha 4                                     MA63.1  POIJ.1
Vendor Buy Unit of   The vendor's buying unit of measure.
Measure

PRL-VBUY-UOM-MULT    Signed 13.7                                 MA63.1  POIJ.1
Vendor Buy UOM       Vendor Buy Unit Of Measure Multiplier.
Multiplier           Used to convert quantity and unit cost.

PRL-CHARGEBACK-QTY   Signed 13.4                                 MA63.1  POIJ.1
Chargeback Qty

PRL-WRITE-OFF-QTY    Signed 13.4                                 MA63.1  POIJ.1
Write Off Qty

PRL-MATCH-SEQ-NBR    Numeric 4                                   MA63.1  POIJ.1
Match Seq Nbr

PRL-TAX-UNIT-CST     Signed 13.5                                 MA63.1  POIJ.1
Tax Unit Cst

PRL-TAX-CODE         Alpha 10                                    MA63.1  POIJ.1
Tax Code             This field contains a code representing
                     specific tax information.  This must be
                     valid Tax Code.

PRL-EXTENDED-AMT     Signed 15.2                                 MA63.1  POIJ.1
Extended Amt

PRL-RETURN-NUMBER    Numeric 10                                  MA63.1  POIJ.1
Return Number        This is the number assigned to the
                     return for purposes of referencing the
                     return internally and with the customer
                     or vendor.

PRL-RET-LINE-NBR     Numeric 6                                   MA63.1  POIJ.1
Return Line Number   This is the return line number.

PRL-FULLY-DELIV      Alpha 1                                     MA63.1  POID.1
Fully Deliv          Y = Yes                                     POIJ.1
                     N = No

PRL-REC-ALLOC-QTY    Signed 13.4                                 MA63.1  POIJ.1
Rec Alloc Qty        This is the portion of the entered
                     received quantity that has been
                     allocated by the automatic allocation
                     from receiving process. (Allocation by
                     other processes is not tracked here)

PRL-TAX-USAGE-CD     Alpha 10                                    MA63.1  POIJ.1
Tax Usage Cd         The tax usage coe for the vendor.  This
                     filed is required if the AP Company
                     inidcates that VAT reporting required.

PRL-INTRASTAT-NBR    Numeric 12
Intrastat Nbr        The number assigned by the Intrastat
                     system to a transaction that involves
                     Intrastat reporting after it has been
                     added.

PRL-SUBSTITUTE       Derived
Substitute

                         PORECLINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRLSET1   COMPANY                                                IC130   IC234
          REC-NUMBER                                             MA231   MA310
          LINE-NBR                                               MA63.1  MA66.1
                                                                 MA66.8  PO133
                                                                 PO199   PO230
                                                                 PO274   PO64.1
                                                                 POID.1  POIJ.1

PRLSET10  COMPANY       This index is used to obtain all lines   POIJ.1
          REC-NUMBER    on a receiver that require inspection.
          LINE-NBR      It was added to support Evaluated
                        Receipt Settlement processing - a
                        receiver
                        can not generate an invoice until all
                        lines have been inspected.
                        Subset
                        Where STATUS = 5
                        Or    STATUS = 6

PRLSET11  COMPANY       KeyChange                                MA66.2  POA3.1
          MATCH-OBJ-ID                                           POIJ.1
          MATCH-SEQ-NBR
          REC-NUMBER
          LINE-NBR

PRLSET12  COMPANY       KeyChange
          REC-NUMBER
          MATCH-DTL-KEY
          PO-LINE-NBR
          LINE-NBR

PRLSET2   COMPANY       KeyChange
          REC-NUMBER
          ITEM
          BIN
          PO-LINE-NBR
          LINE-NBR

PRLSET3   COMPANY       Subset                                   POIJ.1
          REC-NUMBER    Where FULLY-DELIV = "N"
          LINE-NBR      And   STATUS      = 1

PRLSET4   COMPANY       KeyChange                                PO277   POIJ.1
          PO-CODE
          PO-NUMBER
          PO-RELEASE
          LOCATION
          MATCH-DTL-KEY
          PO-LINE-NBR
          REC-NUMBER
          LINE-NBR

PRLSET5   COMPANY       KeyChange, Subset                        PO135   PO223
          PO-CODE       Where STATUS > Zeroes                    PO275   PO276
          PO-NUMBER                                              PO64.1  PO94.1
          PO-RELEASE                                             POID.1  POIJ.1
          PO-LINE-NBR
          UPDATE-DATE*
          UPDATE-TIME*
          REC-NUMBER
          LINE-NBR

PRLSET6   COMPANY       This index is used by PO30 to display    POID.1  POIJ.1
          REC-NUMBER    receiving lines where substitute lines
          PO-LINE-NBR   are directly under the line number for
          LINE-NBR      the original item.

PRLSET7   COMPANY       KeyChange                                IC851   PO85.1
          LOCATION
          ITEM
          UPDATE-DATE*
          UPDATE-TIME*
          REC-NUMBER
          LINE-NBR

PRLSET8   COMPANY                                                IC234
          REC-NUMBER-A
          LINE-NBR

PRLSET9   COMPANY       KeyChange                                IC12.1  PO274
          ITEM
          LOCATION
          REC-NUMBER
          LINE-NBR

                         PORECLINE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            PRL-COMPANY          -> CPY-COMPANY

Apinvoice      APINVOICE    Not Required

                            PRL-COMPANY          -> API-COMPANY
                            PRL-VENDOR           -> API-VENDOR
                            PRL-MATCH-OBJ-ID     -> API-MATCH-OBJ-ID
                            PRL-INVOICE          -> API-INVOICE
                            PRL-SUFFIX           -> API-SUFFIX
                            Zeroes               -> API-CANCEL-SEQ

Buyer Message  POMESSAGE    Not Required, Delete Cascades

                            PRL-COMPANY          -> POM-COMPANY
                            PRL-REC-NUMBER       -> POM-REC-NUMBER
                            PRL-LINE-NBR         -> POM-LINE-NBR

Icbin          ICBIN        Required
                            When PRL-BIN != Spaces
                            And  PRL-BIN != "*      "

                            PRL-COMPANY          -> ICB-COMPANY
                            PRL-LOCATION         -> ICB-LOCATION
                            PRL-BIN              -> ICB-BIN

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

                            PRL-COMPANY          -> ICA-COMPANY
                            PRL-LOCATION         -> ICA-LOCATION
                            ITL-GL-CATEGORY      -> ICA-GL-CATEGORY

Iccompany      ICCOMPANY    Required

                            PRL-COMPANY          -> ICC-COMPANY

Iclocation     ICLOCATION   Required

                            PRL-COMPANY          -> ICL-COMPANY
                            PRL-LOCATION         -> ICL-LOCATION

Ictrans        ICTRANS      Required
                            When PRL-ITEM-TYPE = "I"

                            PRL-COMPANY          -> ICT-COMPANY
                            PRL-LOCATION         -> ICT-LOCATION
                            "PO"                 -> ICT-DOC-TYPE
                            "PO"                 -> ICT-SYSTEM-CD
                            PRL-REC-NUMBER-A     -> ICT-DOCUMENT
                            Zeroes               -> ICT-SHIPMENT-NBR
                            PRL-LINE-NBR         -> ICT-LINE-NBR
                            Zeroes               -> ICT-COMPONENT-SEQ

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

                            PRL-COMPANY          -> ITL-COMPANY
                            PRL-LOCATION         -> ITL-LOCATION
                            PRL-ITEM             -> ITL-ITEM

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

                            ICC-ITEM-GROUP       -> ITE-ITEM-GROUP
                            PRL-ITEM             -> ITE-ITEM

Macompany      MACOMPANY    Required

                            PRL-COMPANY          -> MAY-COMPANY

Mainvdtl       MAINVDTL     Required
                            When PRL-MATCH-OBJ-ID != Zeroes

                            PRL-COMPANY          -> MAD-COMPANY
                            PRL-MATCH-OBJ-ID     -> MAD-MATCH-OBJ-ID
                            PRL-MATCH-SEQ-NBR    -> MAD-MATCH-SEQ-NBR

Pocompany      POCOMPANY    Required

                            PRL-COMPANY          -> PCY-COMPANY

Poline         POLINE       Required

                            PRL-COMPANY          -> PLI-COMPANY
                            PRL-PO-NUMBER        -> PLI-PO-NUMBER
                            PRL-PO-RELEASE       -> PLI-PO-RELEASE
                            PRL-PO-CODE          -> PLI-PO-CODE
                            PRL-LINE-NBR         -> PLI-LINE-NBR

Poreceive      PORECEIVE    Required

                            PRL-COMPANY          -> POR-COMPANY
                            PRL-REC-NUMBER       -> POR-REC-NUMBER

Purchorder     PURCHORDER   Required

                            PRL-COMPANY          -> PCR-COMPANY
                            PRL-PO-CODE          -> PCR-PO-CODE
                            PRL-PO-NUMBER        -> PCR-PO-NUMBER
                            PRL-PO-RELEASE       -> PCR-PO-RELEASE

Vendloc        APVENLOC     Required

                            CPY-VENDOR-GROUP     -> VLO-VENDOR-GROUP
                            PRL-VENDOR           -> VLO-VENDOR
                            PLI-PURCH-FR-LOC     -> VLO-LOCATION-CODE

Vendor         APVENMAST    Required

                            CPY-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            POR-VENDOR           -> VEN-VENDOR

                         PORECLINE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ictransdtl     ICTRANSDTL

                            PRL-COMPANY          -> ICD-COMPANY
                            PRL-LOCATION         -> ICD-LOCATION
                            "PO"                 -> ICD-DOC-TYPE
                            "PO"                 -> ICD-SYSTEM-CD
                            PRL-REC-NUMBER-A     -> ICD-DOCUMENT
                            Zeroes               -> ICD-SHIPMENT-NBR
                            PRL-LINE-NBR         -> ICD-LINE-NBR
                            Zeroes               -> ICD-COMPONENT-SEQ
                                                    ICD-TRANS-SEQ
                                                    ICD-SEQ

Mmdist         MMDIST

                            PRL-COMPANY          -> MMD-COMPANY
                            "PO"                 -> MMD-SYSTEM-CD
                            PRL-LOCATION         -> MMD-LOCATION
                            "P"                  -> MMD-DOC-TYPE
                            PRL-PO-NUMBER        -> MMD-DOC-NUMBER
                            PRL-PO-RELEASE       -> MMD-DOC-NBR-NUM
                            PRL-PO-CODE          -> MMD-PO-CODE
                            PRL-PO-LINE-NBR      -> MMD-LINE-NBR
                            Zeroes               -> MMD-COMPONENT-SEQ
                            Spaces               -> MMD-AOC-CODE
                                                    MMD-LINE-SEQ
                                                    MMD-REQ-LOCATION
                                                    MMD-API-OBJ-ID

Porecadjln     PORECADJLN

                            PRL-COMPANY          -> PJL-COMPANY
                            PRL-REC-NUMBER       -> PJL-REC-NUMBER
                            PRL-LINE-NBR         -> PJL-LINE-NBR
                                                    PJL-DOC-TYPE
                                                    PJL-DOC-NBR-NUM

Potransdtl     POTRANSDTL   Delete Cascades

                            PRL-COMPANY          -> POT-COMPANY
                            "PO"                 -> POT-DOC-TYPE
                            PRL-REC-NUMBER       -> POT-DOC-NBR-NUM
                            PRL-LINE-NBR         -> POT-LINE-NBR
                                                    POT-TRANS-SEQ
                                                    POT-SEQ

Substitutes    PORECLINE
                            Valid When PRL-PO-LINE-NBR != PRL-LINE-NBR

                            PRL-COMPANY          -> PRL-COMPANY
                            PRL-PO-CODE          -> PRL-PO-CODE
                            PRL-PO-NUMBER        -> PRL-PO-NUMBER
                            PRL-PO-RELEASE       -> PRL-PO-RELEASE
                            PRL-LOCATION         -> PRL-LOCATION
                            PRL-MATCH-DTL-KEY    -> PRL-MATCH-DTL-KEY
                                                    PRL-PO-LINE-NBR
                                                    PRL-REC-NUMBER
                                                    PRL-LINE-NBR