PORECEIVE

PO Receivers

This file contains header information for the Purchase Order receiver.

REFERENCED BY
POI6.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 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1 MA540 PO01.1 POI4.1 AP191 MAED.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POR-COMPANY
Element: Company
Numeric 4
The company number.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-REC-NUMBER
Element: Rec Number
Numeric 10
The receiver number. Assigned when this receiving information was added.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-REFERENCE-NO
Element: Reference No
Alpha 10 (Right Justified)
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-PO-NUMBER
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-PO-RELEASE
Element: Po Release
Numeric 4
Used 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-LOCATION
Element: Location
Alpha 5
This field contains a valid stock location within the company inventory.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-PO-LOCATION
Element: Location
Alpha 5
The purchase order and/or inventory control receiving location for this receiver.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-OPER-ID
Element: Operator
Alpha 10
Unique identification code that defines who is entering the receiver.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-BUYER-CODE
Element: Buyer
Alpha 3
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-BOL-NBR
Element: Bol Nbr
Alpha 22
The bill of lading number assigned to this receiver.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-REC-DATE
Element: Date
Numeric 8 (yyyymmdd)
The date the items were received.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-CARRIER
Element: Vendor
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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-PURCH-FR-LOC
Element: Purch Fr Loc
Alpha 4
The vendor's purchase from location.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-STATUS
Element: Status
Numeric 1
The 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-LOGGED-FLAG
Element: Logged Flag
Alpha 1
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
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-REPRINT-REC-FL
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-ACTUAL-TIME
Element: Actual Time
Numeric 4
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-ERS-STATUS
Element: Ers Status
Numeric 1
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
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-INVOICE
Element: Invoice
Alpha 22
Used 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-INVC-REF-TYPE
Element: Invc Ref Type
Alpha 2
Indicates 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-COMMENT
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-PRINT-CODE
Element: Print Code
Alpha 1
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
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-MATCH-AMT
Element: Intl Amt
Signed 18.2
The amount of the receipt.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-MATCH-AMT-TOT
Element: Intl Amt
Signed 18.2
The amount matched on the receipt
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-MATCH-REF-NBR
Element: Match Ref Nbr
Alpha 22
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-CURRENCY-CODE
Element: Currency Code
Alpha 5
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-PROCESS-LEVEL
Element: Process Level
Alpha 5
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-REC-CNV-RATE
Element: Ent Cnv Rate
Signed 14.7
Currency conversion rate at Purchase Order entry time.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-TERMS-CD
Element: Term Code
Alpha 5
A 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-SHIP-TO-ARRIVE
Element: Date
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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-MTCH-PRPY-FL
Element: Mtch Prpy Fl
Alpha 1
This 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
Element: Intl Amt
Signed 18.2
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-HASH-QTY
Element: Hash Qty
Signed 15.4
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-HASH-QTY-MATCH
Element: Hash Qty Match
Signed 15.4
This is the total Qty matched from this receipt.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-XREF-VENDOR
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POR-RETAIL-FLAG
Element: Retail Flag
Numeric 1
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1


PORECEIVE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PORSET1 COMPANY
REC-NUMBER*
...
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PORSET10 COMPANY
VENDOR
MATCH-REF-NBR
REC-NUMBER
KeyChange, Subset
WhereMATCH-REF-NBR !=Spaces
...
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PORSET11 COMPANY
REFERENCE-NO
REC-NUMBER
KeyChange, Subset
WhereREFERENCE-NO !=Spaces
...
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PORSET2 COMPANY
STATUS
REC-DATE
REC-NUMBER
KeyChange
PO300
PORSET3 COMPANY
PO-CODE
PO-NUMBER
PO-RELEASE
PO-LOCATION
REC-NUMBER
KeyChange
...
AP125 AP126
AP131 AP191
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
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PORSET4 COMPANY
LOCATION
REC-NUMBER
KeyChange, Subset
WhereSTATUS =Zeroes
PORSET5 COMPANY
PO-CODE
PO-NUMBER
BOL-NBR
OPER-ID
BUYER-CODE
CARRIER
REC-NUMBER
KeyChange
PORSET6 COMPANY
LOCATION
REC-DATE*
REC-NUMBER
KeyChange
PORSET7 COMPANY
VENDOR
REC-NUMBER
KeyChange, Subset
WhereERS-STATUS =3
...
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PORSET8 COMPANY
VENDOR
INVOICE
KeyChange, Subset
WhereINVOICE !=Spaces
...
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PORSET9 COMPANY
VENDOR
PO-CODE
PO-NUMBER
PO-RELEASE
LOCATION
REC-NUMBER
KeyChange, Subset
Where(STATUS =1)
Or(STATUS =4)
...
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAED.1


PORECEIVE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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
Potrack POTRACK Delete Cascades
POR-COMPANY->PTK-COMPANY
POR-REC-NUMBER->PTK-REC-NUMBER
Zeroes->PTK-LINE-NBR
  PTK-PKG-TRK-NBR
  PTK-REQ-NUMBER
Recaocdtl RECAOCDTL
POR-COMPANY->REC-COMPANY
POR-REC-NUMBER->REC-REC-NUMBER
Zeroes->REC-LINE-NBR
  REC-AOC-CODE


File created: Wed Jun 08 20:50:53 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.