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
|
