PORECEIVE – PO Receivers

System
Purchase Order (PO)
Prefix
POR
Primary key
COMPANY, REC-NUMBER
Fields
49
Updated by
223 programs
Referenced by
26 programs

PORECEIVE is the PO Receivers table in Lawson Purchase Order (prefix POR). It is indexed by COMPANY, REC-NUMBER (PORSET1); alternate indexes: PORSET10, PORSET11, PORSET12, PORSET2, PORSET3, PORSET4, PORSET5, PORSET6 and 3 more. It is related 1:1 to APCOMPANY, ICCOMPANY, ICLOCATION, MACOMPANY, POCOMPANY, PORBOD, PURCHORDER and APVENMAST and 1:M to PORECLINE, POTRACK and RECAOCDTL. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 215 more and referenced by AP191, IC153, IC300, IC37.1, MA168, MA231, MA540, MA63.1 and 18 more. The table has 49 fields, 12 indexes and 13 documented relations.

About PORECEIVE

This file contains header information for the Purchase Order receiver.

Fields (49)

Column = COBOL field name without the POR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
POR-COMPANY PK
COMPANY		Numeric 4The company number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-REC-NUMBER PK
REC_NUMBER		Numeric 10The receiver number. Assigned when this receiving information was added.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-REFERENCE-NO
REFERENCE_NO		Alpha 25 (Right Justified)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-PO-NUMBER
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-PO-RELEASE
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-LOCATION
LOCATION		Alpha 5This field contains a valid stock location within the company inventory.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-PO-LOCATION
PO_LOCATION		Alpha 5The purchase order and/or inventory control receiving location for this receiver.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-OPER-ID
OPER_ID		Alpha 10Unique identification code that defines who is entering the receiver.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-BUYER-CODE
BUYER_CODE		Alpha 3—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-BOL-NBR
BOL_NBR		Alpha 22The bill of lading number assigned to this receiver.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-REC-DATE
REC_DATE		Numeric 8 (yyyymmdd)The date the items were received.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-CARRIER
CARRIER		Alpha 9 (Right Justified)The carrier ID must be a valid vendor ID.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4The vendor's purchase from location.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-STATUS
STATUS		Numeric 1The current status of this receiver.
  • 0 Unreleased
  • 1 Released
  • 5 Ready to Archive
  • 7 Drop Ship
  • 9 Archived / Closed
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-LOGGED-FLAG
LOGGED_FLAG		Alpha 1If 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
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-REPRINT-REC-FL
REPRINT_REC_FL		Alpha 1—
  • Y Reprint Receiver
  • N Do Not Reprint Receiver
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-ACTUAL-TIME
ACTUAL_TIME		Numeric 4This is the actual time the receiver was entered into the system. System time defaults if one was not entered.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-ERS-STATUS
ERS_STATUS		Numeric 1The 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
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-INVOICE
INVOICE		Alpha 22Used to identify the invoice created from this receipt in the Evaluated Receipts Settlement process.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-INVC-REF-TYPE
INVC_REF_TYPE		Alpha 2Indicates the type of number the vendor 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
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-COMMENT
COMMENT		Alpha 40 (Lower Case)Occurs 5 Times This field contains comments that can optionally be printed on the vendor remittance or used internally.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-PRINT-CODE
PRINT_CODE		Alpha 1This 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
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-MATCH-AMT
MATCH_AMT		Signed 18.2The amount of the receipt.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-MATCH-AMT-TOT
MATCH_AMT_TOT		Signed 18.2The amount matched on the receiptAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-MATCH-REF-NBR
MATCH_REF_NBR		Alpha 22—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-REC-CNV-RATE
REC_CNV_RATE		Signed 14.7Currency conversion rate at Purchase Order entry time.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-TERMS-CD
TERMS_CD		Alpha 5A user-defined code representing a method of determining invoice due and discount dates.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-SHIP-TO-ARRIVE
SHIP_TO_ARRIVE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-MTCH-PRPY-FL
MTCH_PRPY_FL		Alpha 1This field will be populated from the INVOICE file if the invoice is INVOICE-TYPE R for Match Prepayment. When the receipt is entered or interfaced the same firled on the receipt record will be populated in oreder to note that it will be matched to a match prepayment invoice. " " = No Option
  • R Invoice Type Match Prepay
—
POR-PO-AOC-TOTAL
PO_AOC_TOTAL		Signed 18.2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-HASH-QTY
HASH_QTY		Signed 15.4This is the total of the goods quantity on the invoice. This field will be used to match on quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-HASH-QTY-MATCH
HASH_QTY_MATCH		Signed 15.4This is the total Qty matched from this receipt.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-XREF-VENDOR
XREF_VENDOR		Alpha 9 (Right Justified)This is a vendor that is supported on a system outside Lawson. When records are interfaces we will maintain this vendor on the file but we will use the Lawson vendor while in the lawson application.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-RETAIL-FLAG
RETAIL_FLAG		Numeric 1—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-CREATED-BY
CREATED_BY		Alpha 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-LAST-UPDT-DATE
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-REL-OPER-ID
REL_OPER_ID		Alpha 10—PO30.1, POID.1
POR-FREIGHT-TOT
FREIGHT_TOT		Signed 18.2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-INSURANCE-TOT
INSURANCE_TOT		Signed 18.2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-CSTMS-TOT
CSTMS_TOT		Signed 18.2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-OTHER-AOC-TOT
OTHER_AOC_TOT		Signed 18.2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-GLBL-DOC-TYPE
GLBL_DOC_TYPE		Alpha 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POR-TEMP-HOLD
TEMP_HOLD		Alpha 1—
  • A Approved by Engine
  • S Sent for Approval
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (12)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PORSET1COMPANY, REC-NUMBER*PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PORSET10COMPANY, VENDOR, MATCH-REF-NBR, REC-NUMBERKeyChange, SubsetWhere MATCH-REF-NBR != SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PORSET11COMPANY, REFERENCE-NO, REC-NUMBERKeyChange, SubsetWhere REFERENCE-NO != SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PORSET12COMPANY, REC-NUMBER, REC-DATE, LAST-UPDT-DATE, STATUSKeyChange—
PORSET2COMPANY, STATUS, REC-DATE, REC-NUMBERKeyChangeMA180, PO300
PORSET3COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE, PO-LOCATION, REC-NUMBERKeyChangeAP125, AP126, AP131, AP191, AP20.1, AP20.2, AP20.3, AP20.4 +22 more (list truncated in source)
PORSET4COMPANY, LOCATION, REC-NUMBERKeyChange, SubsetWhere STATUS = ZeroesPO199, PO230, PO35.1
PORSET5COMPANY, PO-CODE, PO-NUMBER, BOL-NBR, OPER-ID, BUYER-CODE, CARRIER, REC-NUMBERKeyChangePO258, PO58.1, PO58.2
PORSET6COMPANY, LOCATION, REC-DATE*, REC-NUMBERKeyChange—
PORSET7COMPANY, VENDOR, REC-NUMBERKeyChange, SubsetWhere ERS-STATUS = 3AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PORSET8COMPANY, VENDOR, INVOICEKeyChange, SubsetWhere INVOICE != SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PORSET9COMPANY, VENDOR, PO-CODE, PO-NUMBER, PO-RELEASE, LOCATION, REC-NUMBERKeyChange, SubsetWhere (STATUS = 1) Or (STATUS = 4)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (9) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredPOR-COMPANY → CPY-COMPANY
Ic CompanyICCOMPANYRequiredPOR-COMPANY → ICC-COMPANY
IclocationICLOCATIONRequiredWhen POR-LOCATION != SpacesPOR-COMPANY → ICL-COMPANY, POR-LOCATION → ICL-LOCATION
MacompanyMACOMPANYRequiredPOR-COMPANY → MAY-COMPANY
Po LocationICLOCATIONRequiredPOR-COMPANY → ICL-COMPANY, POR-PO-LOCATION → ICL-LOCATION
PocompanyPOCOMPANYRequiredPOR-COMPANY → PCY-COMPANY
PorbodPORBODNot Required, Delete CascadesPOR-COMPANY → PBE-COMPANY, POR-REC-NUMBER → PBE-REC-NUMBER
PurchorderPURCHORDERRequiredPOR-COMPANY → PCR-COMPANY, POR-PO-CODE → PCR-PO-CODE, POR-PO-NUMBER → PCR-PO-NUMBER, POR-PO-RELEASE → PCR-PO-RELEASE
VendorAPVENMASTRequiredCPY-VENDOR-GROUP → VEN-VENDOR-GROUP, POR-VENDOR → VEN-VENDOR

One to many (4) — child tables

RelationTableRulesConditionField map
PoreclinePORECLINEDelete CascadesPOR-COMPANY → PRL-COMPANY, POR-REC-NUMBER → PRL-REC-NUMBER, → PRL-LINE-NBR
Porecline ItemPORECLINEPOR-COMPANY → PRL-COMPANY, POR-REC-NUMBER → PRL-REC-NUMBER, → PRL-ITEM, → PRL-BIN, → PRL-PO-LINE-NBR, → PRL-LINE-NBR
PotrackPOTRACKDelete CascadesPOR-COMPANY → PTK-COMPANY, POR-REC-NUMBER → PTK-REC-NUMBER, Zeroes → PTK-LINE-NBR, → PTK-PKG-TRK-NBR, → PTK-REQ-NUMBER
RecaocdtlRECAOCDTLPOR-COMPANY → REC-COMPANY, POR-REC-NUMBER → REC-REC-NUMBER, Zeroes → REC-LINE-NBR, → REC-AOC-CODE

Programs

Updated by (223)

Referenced by (26)