Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PORECEIVE FILE

                              PO Receivers

This file contains header information for the Purchase Order receiver.

REFERENCED BY

IC300     MA63.1    PO01.1    PO223     PO230     PO274
PO275     PO85.1    PO94.1    POI4.1    POI6.1    POID.1
POA3.1    PO199     PO68.1    MA231     MA310

UPDATED BY

POIJ.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

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

POR-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).

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

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

POR-PO-LOCATION      Alpha 5                                     MA63.1  POIJ.1
Purchase Order       The purchase order and/or inventory
Location             control receiving location for this
                     receiver.

POR-OPER-ID          Alpha 10                                    MA63.1  POIJ.1
Operator             Unique identification code that
Identification       defines who is entering the receiver.

POR-BUYER-CODE       Alpha 3                                     MA63.1  POIJ.1
Buyer Code           The user defined buyer identifier.

POR-BOL-NBR          Alpha 22                                    MA63.1  POIJ.1
Bill of Lading       The bill of lading number assigned to
Number               this receiver.

POR-REC-DATE         Numeric 8  (yyyymmdd)                       MA63.1  POIJ.1
Receiving Date       The date the items were received.

POR-CARRIER          Alpha 9  (Right Justified)                  MA63.1  POIJ.1
Carrier Vendor       The carrier ID must be a valid vendor
Number               ID.

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



POR-PURCH-FR-LOC     Alpha 4                                     MA63.1  POIJ.1
Purchase From        The vendor's purchase from location.
Location Code

POR-STATUS           Numeric 1                                   MA63.1  POIJ.1
Status               The current status of this receiver.
                     0 = Unreleased
                     1 = Released
                     5 = Ready to Archive
                     7 = Drop Ship
                     9 = Archived / Closed

POR-LOGGED-FLAG      Alpha 1                                     MA63.1  POIJ.1
Logged Flag          If set to "Y", this field indicates the
                     receiving or receiving adjustment log
                     has been run against this record in a
                     print all unprinted transactions mode.
                     Y = Yes
                     N = No

POR-REPRINT-REC-FL   Alpha 1                                     MA63.1  POIJ.1
Reprint Rec Fl       Y = Reprint Receiver
                     N = Do Not Reprint Receiver

POR-ACTUAL-TIME      Numeric 4                                   MA63.1  POIJ.1
Actual Time          This is the actual time the
                     receiver was entered into the system.
                     System time defaults if one was
                     not entered.

POR-ERS-STATUS       Numeric 1                                   MA63.1  POIJ.1
ERS Status           The status of the receipt in the
                     Evaluated Receipts Settlement process.
                     1 = Vendor to Invoice
                     2 = Invoice From Receipt
                     3 = Invoice Pending
                     4 = Invoice In Process
                     5 = Invoice Complete
                     6 = Invoice Complete - Errors

POR-INVOICE          Alpha 22                                    MA63.1  POIJ.1
Invoice Number       Used to identify the invoice created
                     from this receipt in the Evaluated
                     Receipts Settlement process.

POR-INVC-REF-TYPE    Alpha 2                                     MA63.1  POIJ.1
Invoice Reference    Indicates the type of number the vendor
Type                 is providing to reference the invoice.
                     BM = Bill of Lading
                     IN = Invoice
                     OW = Service Order Number
                     PL = Packing List Number
                     PO = PO Number
                     VN = Vendor Order
                     WO = Work Order
                     WP = Warehouse Pick Ticket
                     ZZ = Mutually Defined

POR-COMMENT          Alpha 40  (Lower Case)                      MA63.1  POIJ.1
Comment Line         Occurs 5 Times
                     This field contains comments that can
                     optionally be printed on the vendor
                     remittance or used internally.

POR-PRINT-CODE       Alpha 1                                     MA63.1  POIJ.1
Print Code           This field contains the print code,
                     which defines where comments are
                     displayed or printed.
                     A = All
                     C = Check (Cheque)
                     D = Display and Print
                     N = Notation Only

POR-MATCH-AMT        Signed 15.2                                 MA63.1  POIJ.1
Match Amt            The amount of the receipt

POR-MATCH-AMT-TOT    Signed 15.2                                 MA63.1  POIJ.1
Match Amt Tot        The amount matched on the receipt

POR-MATCH-REF-NBR    Alpha 22                                    MA63.1  POIJ.1
Match Ref Nbr

POR-CURRENCY-CODE    Alpha 5                                     MA63.1  POIJ.1
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).

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

POR-REC-CNV-RATE     Signed 12.6                                 MA63.1  POIJ.1
Receiving Exchange   Currency conversion rate for the
Rate                 Purchase Order at receiving time.

POR-TERMS-CD         Alpha 5                                     MA63.1  POIJ.1
Terms Code

                         PORECEIVE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PORSET1   COMPANY                                                IC300   MA63.1
          REC-NUMBER*                                            PO01.1  PO223
                                                                 PO230   PO274
                                                                 PO275   PO85.1
                                                                 PO94.1  POI4.1
                                                                 POI6.1  POID.1
                                                                 POIJ.1

PORSET10  COMPANY       KeyChange, Subset                        MA63.1  POIJ.1
          VENDOR        Where MATCH-REF-NBR != Spaces
          MATCH-REF-NBR
          REC-NUMBER

PORSET11  COMPANY       KeyChange, Subset                        POIJ.1
          REFERENCE-NO  Where REFERENCE-NO != Spaces

PORSET2   COMPANY       KeyChange
          STATUS
          REC-DATE
          REC-NUMBER

PORSET3   COMPANY       KeyChange                                POA3.1  POIJ.1
          PO-CODE
          PO-NUMBER
          PO-RELEASE
          PO-LOCATION
          REC-NUMBER

PORSET4   COMPANY       KeyChange, Subset                        PO199   PO230
          LOCATION      Where STATUS = Zeroes
          REC-NUMBER

PORSET5   COMPANY       KeyChange                                PO68.1
          REC-DATE*
          REC-NUMBER

PORSET6   COMPANY       KeyChange
          LOCATION
          REC-DATE*
          REC-NUMBER

PORSET7   COMPANY       KeyChange, Subset                        POIJ.1
          VENDOR        Where ERS-STATUS = 3
          REC-NUMBER

PORSET8   COMPANY       KeyChange, Subset                        POIJ.1
          VENDOR        Where INVOICE != Spaces
          INVOICE

PORSET9   COMPANY       KeyChange, Subset                        MA231   MA310
          VENDOR        Where STATUS = 1                         MA63.1  POIJ.1
          PO-CODE       Or    STATUS = 4
          PO-NUMBER
          PO-RELEASE
          LOCATION
          REC-NUMBER

                         PORECEIVE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            POR-COMPANY         -> CPY-COMPANY

Ic Company     ICCOMPANY    Required

                            POR-COMPANY         -> ICC-COMPANY

Iclocation     ICLOCATION   Required
                            When POR-LOCATION != Spaces

                            POR-COMPANY         -> ICL-COMPANY
                            POR-LOCATION        -> ICL-LOCATION

Macompany      MACOMPANY    Required

                            POR-COMPANY         -> MAY-COMPANY

Po Location    ICLOCATION   Required

                            POR-COMPANY         -> ICL-COMPANY
                            POR-PO-LOCATION     -> ICL-LOCATION

Pocompany      POCOMPANY    Required

                            POR-COMPANY         -> PCY-COMPANY

Purchorder     PURCHORDER   Required

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

Vendor         APVENMAST    Required

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

                         PORECEIVE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Porecline      PORECLINE    Delete Cascades

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

Porecline Item PORECLINE

                            POR-COMPANY         -> PRL-COMPANY
                            POR-REC-NUMBER      -> PRL-REC-NUMBER
                                                   PRL-ITEM
                                                   PRL-BIN
                                                   PRL-PO-LINE-NBR
                                                   PRL-LINE-NBR