|
|
PORECEIVE FILE
PO Receivers
This file contains header information for the Purchase Order receiver.
REFERENCED BY
IC300 IC50.2 MA00.3 MA40.1 MA40.2 MA41.1
MA41.2 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3
MA52.1 PO122 PO20.1 PO21.3 PO22.2 PO22.3
PO221 PO230 PO33.1 PO39.1 PO50.1 PO52.1
RQ10.1 RQ10.2 RQ20.1 RQ20.3 RQ20.4 PO68.1
UPDATED BY
MA300 MA530 MA540 PO131 PO30.1 PO30.2
PO31.1 PO34.1 PO35.1 PO530
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POR-COMPANY Numeric 4 PO30.1 PO530
Company The company number.
POR-REC-NUMBER Alpha 10 (Right Justified) PO30.1 PO530
Receiver Number The receiver number. Assigned when
this receiving information was added.
POR-PO-NUMBER Alpha 7 (Right Justified) PO30.1 PO530
PO Number This field contains the number
representing the purchase order.
POR-PO-RELEASE Numeric 6 PO30.1 PO530
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
POR-LOCATION Alpha 5 PO30.1 PO530
Location Code This field contains a valid stock
location within the company inventory.
POR-PO-LOCATION Alpha 5 PO30.1 PO530
Purchase Order The purchase order and/or inventory
Location control receiving location for this
receiver.
POR-OPER-ID Alpha 10 PO30.1 PO530
Operator Unique identification code that
Identification defines who is entering the receiver.
POR-BUYER-CODE Alpha 3 PO30.1 PO530
Buyer Code The user defined buyer identifier.
POR-BOL-NBR Alpha 10 PO30.1 PO530
Bill of Lading The bill of lading number assigned to
Number this receiver.
POR-REC-DATE Numeric 8 (yyyymmdd) PO30.1 PO530
Receiving Date The date the items were received.
POR-CARRIER Alpha 9 PO30.1 PO530
Carrier Vendor The carrier ID must be a valid vendor
Number ID.
POR-VENDOR Alpha 9 PO30.1 PO530
Vendor ID The vendor's identification code.
POR-REC-COMMENTS Alpha 30 (Lower Case) PO30.1 PO530
Receiving Comments The receiving comment narrative for
this receiver.
POR-STATUS Numeric 1 PO131 PO30.1
Status The current status of this receiver. PO35.1 PO530
0 = Unreleased
1 = Released
2 = Logged
POR-LAST-PRL-LINE Numeric 6 PO30.1 PO30.2
Last PO Receive line The last receive line for this receiver. PO530
POR-ACTUAL-TIME Numeric 4 PO30.1 PO530
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 MA530 MA540
ERS Status The status of the receipt in the PO30.1 PO31.1
Evaluated Receipts Settlement process. PO34.1 PO35.1
1 = Vendor to Invoice PO530
2 = Invoice From Receipt
3 = Invoice Pending
4 = Invoice In Process
5 = Invoice Complete
6 = Invoice Complete - Errors
POR-INVOICE Alpha 22 PO30.1 PO530
Invoice Number Used to identify the invoice created
from this receipt in the Evaluated
Receipts Settlement process.
POR-SUFFIX Numeric 3
Invoice Suffix The occurrence value of the invoice
number. If the vendor provides a single
invoice number for multiple receipts,
each receipt's invoice number will have
a unique suffix.
POR-INVC-REF-TYPE Alpha 2 PO30.1 PO530
Invoice Reference Indicates the type of number the vendor
Type is providing to reference the invoice.
BM
IN
OW
PL
PO
VN
WO
WP
ZZ
POR-COMMENT Alpha 40 (Lower Case) PO30.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 PO30.1
Print Code This field contains the print code,
which defines where comments are
displayed or printed.
PORECEIVE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PORSET1 COMPANY IC300 IC50.2
REC-NUMBER MA00.3 MA300
MA40.1 MA40.2
MA41.1 MA41.2
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA52.1
MA530 MA540
PO122 PO131
PO20.1 PO21.3
PO22.2 PO22.3
PO221 PO230
PO30.1 PO30.2
PO31.1 PO33.1
PO34.1 PO35.1
...
PORSET3 COMPANY Subset PO20.1 PO30.1
PO-NUMBER Where STATUS = Zeroes PO530 RQ20.1
PO-RELEASE RQ20.3 RQ20.4
PO-LOCATION
REC-NUMBER
PORSET4 COMPANY KeyChange, Subset PO230 PO35.1
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, Duplicates, Subset MA530
VENDOR Where ERS-STATUS = 3
REC-NUMBER
PORSET8 COMPANY KeyChange, Subset MA530 MA540
VENDOR Where INVOICE != Spaces PO30.1 PO31.1
INVOICE PO530
PORECEIVE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
POR-COMPANY -> CPY-COMPANY
Buyer BUYER Required
POR-COMPANY -> BUY-COMPANY
POR-BUYER-CODE -> BUY-BUYER-CODE
Ic Company ICCOMPANY Required
POR-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
When POR-LOCATION != Spaces
POR-COMPANY -> ICL-COMPANY
POR-LOCATION -> ICL-LOCATION
Po Location ICLOCATION Required
POR-COMPANY -> ICL-COMPANY
POR-PO-LOCATION -> ICL-LOCATION
Pocompany POCOMPANY Required
POR-COMPANY -> PCY-COMPANY
Purchorder PURCHORDER Required
When POR-PO-NUMBER != Spaces
POR-COMPANY -> PCR-COMPANY
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
Ersaocdtl ERSAOCDTL Delete Cascades
POR-COMPANY -> ERS-COMPANY
POR-REC-NUMBER -> ERS-REC-NUMBER
Zeroes -> ERS-LINE-NBR
ERS-AOC-CODE
Hdr Comments POCOMMENTS
POR-COMPANY -> POC-COMPANY
Spaces -> POC-ORDER-NAME
Zeroes -> POC-RETURN-NUMBER
POR-PO-NUMBER -> POC-PO-NUMBER
POR-PO-RELEASE -> POC-PO-RELEASE
Zeroes -> POC-LINE-NBR
POC-SEQ
Porecline PORECLINE Delete Cascades
POR-COMPANY -> PRL-COMPANY
"PO" -> PRL-DOC-TYPE
POR-REC-NUMBER -> PRL-DOCUMENT
PRL-LINE-NBR
Porecline Item PORECLINE Delete Cascades
POR-COMPANY -> PRL-COMPANY
"PO" -> PRL-DOC-TYPE
POR-REC-NUMBER -> PRL-DOCUMENT
PRL-ITEM
PRL-BIN
PRL-PO-LINE-NBR
PRL-LINE-NBR
Tlr Comments POCOMMENTS
POR-COMPANY -> POC-COMPANY
Spaces -> POC-ORDER-NAME
Zeroes -> POC-RETURN-NUMBER
POR-PO-NUMBER -> POC-PO-NUMBER
POR-PO-RELEASE -> POC-PO-RELEASE
999999 -> POC-LINE-NBR
POC-SEQ
|