PORECLINE FILE
PO Line Item Receivings
This file contains purchase order receiving line item detail and status
information.
REFERENCED BY
IC130 IC234 MA231 MA310 MA63.1 MA66.1
MA66.8 MA66.2 PO133 PO199 PO230 PO274
PO64.1 POA3.1 PO277 PO135 PO223 PO275
PO276 PO94.1 IC851 PO85.1 IC12.1
UPDATED BY
POID.1 POIJ.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRL-COMPANY Numeric 4 MA63.1 POIJ.1
Company The company number.
PRL-REC-NUMBER Numeric 10 MA63.1 POIJ.1
Receiver Number The receiver number. Assigned when
this receiving information was added.
PRL-LINE-NBR Numeric 6 MA63.1 POIJ.1
Line Number This field contains the line number.
PRL-REC-NUMBER-A Alpha 10 (Right Justified) MA63.1 POIJ.1
Rec Number A
PRL-REFERENCE-NO Alpha 10 (Right Justified) MA63.1 POIJ.1
Reference No
PRL-PO-NUMBER Alpha 14 (Right Justified) MA63.1 POIJ.1
PO Number This field contains the number
representing the purchase order.
PRL-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).
PRL-PO-CODE Alpha 4 MA63.1 POIJ.1
Po Code This is the purchase order code.
PRL-PO-LINE-NBR Numeric 6 MA63.1 POIJ.1
PO Line Number The purchase order line number this
record is associated with.
PRL-ITEM Alpha 32 MA63.1 POIJ.1
Item Number This field contains the item
identifier.
PRL-DESCRIPTION Alpha 30 (Lower Case) MA63.1 POIJ.1
Description This field displays the description.
PRL-ITEM-TYPE Alpha 1 MA63.1 POIJ.1
Item Type This field identifies the line item
type.
I = Inventoried
N = Non-stock
S = Service
X = Special
PRL-VEN-ITEM Alpha 32 MA63.1 POIJ.1
Vendor Item The vendor's item identifer.
PRL-LOCATION Alpha 5 MA63.1 POIJ.1
Location Code This field contains a valid stock
location within the company inventory.
PRL-PROCESS-LEVEL Alpha 5 MA63.1 POIJ.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
PRL-ENT-REC-QTY Signed 13.4 MA63.1 POIJ.1
Entered Received Entered receipt quantity.
Quantity
PRL-ENT-REC-UOM Alpha 4 MA63.1 POIJ.1
Entered Received UOM Entered valid receipt unit of measure.
PRL-ENT-RUOM-MULT Signed 13.7 MA63.1 POIJ.1
Entered Recvd UOM This multiplier is used to convert
Multiplier entered unit of measure quantity down to
stock unit of measure.
PRL-REJECT-QTY Signed 13.4 MA63.1 POIJ.1
Inspection Reject The rejected quantity for this
Quantity receiving.
PRL-ORIG-REC-QTY Signed 13.4 MA63.1 POIJ.1
Original Received Any adjustment to the original received
Quantity quantity is accumulated in the Entered
Received Quantity field. This quantity
is the original quantity when this
receiver was first released.
PRL-CATCH-WT-QTY Signed 13.4 MA63.1 POIJ.1
Catch Weight This field contains the quantity
Quantity received for catch weight shipments.
PRL-ORIG-UNIT-CST Signed 13.5 MA63.1 POIJ.1
Orig Unit Cst
PRL-MATCH-UNIT-CST Signed 13.5 MA63.1 POIJ.1
Match Unit Cst
PRL-BIN Alpha 7 MA63.1 POIJ.1
Bin This field contains a storage area for
an item or any number of items.
PRL-CANCEL-BO-FL Alpha 1 MA63.1 POIJ.1
Cancel Back Order This flag indicates whether the
Flag backordered quantity is to be canceled
and the line is to be considered closed.
N = No
Y = Yes
PRL-INSP-REQ-FL Alpha 1 MA63.1 POIJ.1
Inspection Required This flag indicates whether this item
Flag has to be inspected when received via
purchase order.
N = No
Y = Yes
PRL-DETAIL-BAL-FL Alpha 1 MA63.1 POIJ.1
Detail Balance Flag This flag is set to Yes when all items
received for this line have bins, serial
numbers, and/or lots/sublots assigned if
necessary.
Y = Yes
N = No
PRL-STATUS Numeric 1 MA63.1 POIJ.1
Status Current receiving status for this line.
0 = Entered
1 = Released/Inspected
5 = Released/Requires Inspection
6 = Released/Unreleased Inspection
PRL-BUYER-MSG-FLAG Alpha 1 MA63.1 POIJ.1
Buyer Msg Flag Indicates whether a buyer message exists
for this receiving line.
Y = Yes
N = No
PRL-LAST-POT-SEQ Numeric 6 MA63.1 POIJ.1
Last Pot Seq
PRL-UPDATE-DATE Numeric 8 (yyyymmdd) MA63.1 POIJ.1
Update Date This field contains the date the record
was updated.
PRL-UPDATE-TIME Numeric 6 MA63.1 POIJ.1
Update Time This field contains the system time
when the record was updated.
PRL-REC-DATE Numeric 8 (yyyymmdd) MA63.1 POIJ.1
Receiving Date
PRL-VENDOR Alpha 9 (Right Justified) MA63.1 POIJ.1
Vendor ID The vendor's identification code.
PRL-INVOICE Alpha 22 MA63.1 POIJ.1
Invoice Number Used to identify the invoice.
PRL-SUFFIX Numeric 3 MA63.1 POIJ.1
Invoice Suffix This is the suffix for the invoice.
PRL-MSDS-FLAG Alpha 1 MA63.1 POIJ.1
Material Safety This flag indicates if this item
DataSheet Flag requires a Material Safety Data Sheet.
N = No
Y = Yes
PRL-MSDS-VERSION Alpha 4 MA63.1 POIJ.1
Msds Version The version number of the most recent
MSDS that was received.
PRL-MSDS-DOCUMENT Alpha 30 MA63.1 POIJ.1
Msds Document The document number from the most
recent MSDS that was received.
PRL-MATCH-CLASS Alpha 10 MA63.1 POIJ.1
Match Class
PRL-MATCHED-QTY Signed 13.4 MA63.1 POIJ.1
Matched Qty
PRL-MATCH-OBJ-ID Numeric 12 MA63.1 POIJ.1
Match Obj Id
PRL-MATCH-DTL-KEY Alpha 55 MA63.1 POIJ.1
Match Dtl Key
PRL-ARCHIVE-QTY Signed 13.4 MA63.1 POIJ.1
Archive Qty
PRL-ARCH-WO-QTY Signed 13.4 MA63.1 POIJ.1
Arch Wo Qty
PRL-VPRI-QUANTITY Signed 13.4 MA63.1 POIJ.1
Vendor Price The entered line quantity system
Quantity converted to vendor pricing terms.
PRL-VPRI-UOM Alpha 4 MA63.1 POIJ.1
Vendor Price Unit This is the vendor pricing unit of
of Measure measure.
PRL-VPRI-UOM-MULT Signed 13.7 MA63.1 POIJ.1
Vendor Price UOM This is the vendor pricing unit of
Multiplier measure multiplier. It is used to
convert unit cost to stock unit of
measure terms.
PRL-BUOM-QTY Signed 13.4 MA63.1 POIJ.1
Buom Qty
PRL-VBUY-UOM Alpha 4 MA63.1 POIJ.1
Vendor Buy Unit of The vendor's buying unit of measure.
Measure
PRL-VBUY-UOM-MULT Signed 13.7 MA63.1 POIJ.1
Vendor Buy UOM Vendor Buy Unit Of Measure Multiplier.
Multiplier Used to convert quantity and unit cost.
PRL-CHARGEBACK-QTY Signed 13.4 MA63.1 POIJ.1
Chargeback Qty
PRL-WRITE-OFF-QTY Signed 13.4 MA63.1 POIJ.1
Write Off Qty
PRL-MATCH-SEQ-NBR Numeric 4 MA63.1 POIJ.1
Match Seq Nbr
PRL-TAX-UNIT-CST Signed 13.5 MA63.1 POIJ.1
Tax Unit Cst
PRL-TAX-CODE Alpha 10 MA63.1 POIJ.1
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
PRL-EXTENDED-AMT Signed 15.2 MA63.1 POIJ.1
Extended Amt
PRL-RETURN-NUMBER Numeric 10 MA63.1 POIJ.1
Return Number This is the number assigned to the
return for purposes of referencing the
return internally and with the customer
or vendor.
PRL-RET-LINE-NBR Numeric 6 MA63.1 POIJ.1
Return Line Number This is the return line number.
PRL-FULLY-DELIV Alpha 1 MA63.1 POID.1
Fully Deliv Y = Yes POIJ.1
N = No
PRL-REC-ALLOC-QTY Signed 13.4 MA63.1 POIJ.1
Rec Alloc Qty This is the portion of the entered
received quantity that has been
allocated by the automatic allocation
from receiving process. (Allocation by
other processes is not tracked here)
PRL-TAX-USAGE-CD Alpha 10 MA63.1 POIJ.1
Tax Usage Cd The tax usage coe for the vendor. This
filed is required if the AP Company
inidcates that VAT reporting required.
PRL-INTRASTAT-NBR Numeric 12
Intrastat Nbr The number assigned by the Intrastat
system to a transaction that involves
Intrastat reporting after it has been
added.
PRL-SUBSTITUTE Derived
Substitute
PORECLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRLSET1 COMPANY IC130 IC234
REC-NUMBER MA231 MA310
LINE-NBR MA63.1 MA66.1
MA66.8 PO133
PO199 PO230
PO274 PO64.1
POID.1 POIJ.1
PRLSET10 COMPANY This index is used to obtain all lines POIJ.1
REC-NUMBER on a receiver that require inspection.
LINE-NBR It was added to support Evaluated
Receipt Settlement processing - a
receiver
can not generate an invoice until all
lines have been inspected.
Subset
Where STATUS = 5
Or STATUS = 6
PRLSET11 COMPANY KeyChange MA66.2 POA3.1
MATCH-OBJ-ID POIJ.1
MATCH-SEQ-NBR
REC-NUMBER
LINE-NBR
PRLSET12 COMPANY KeyChange
REC-NUMBER
MATCH-DTL-KEY
PO-LINE-NBR
LINE-NBR
PRLSET2 COMPANY KeyChange
REC-NUMBER
ITEM
BIN
PO-LINE-NBR
LINE-NBR
PRLSET3 COMPANY Subset POIJ.1
REC-NUMBER Where FULLY-DELIV = "N"
LINE-NBR And STATUS = 1
PRLSET4 COMPANY KeyChange PO277 POIJ.1
PO-CODE
PO-NUMBER
PO-RELEASE
LOCATION
MATCH-DTL-KEY
PO-LINE-NBR
REC-NUMBER
LINE-NBR
PRLSET5 COMPANY KeyChange, Subset PO135 PO223
PO-CODE Where STATUS > Zeroes PO275 PO276
PO-NUMBER PO64.1 PO94.1
PO-RELEASE POID.1 POIJ.1
PO-LINE-NBR
UPDATE-DATE*
UPDATE-TIME*
REC-NUMBER
LINE-NBR
PRLSET6 COMPANY This index is used by PO30 to display POID.1 POIJ.1
REC-NUMBER receiving lines where substitute lines
PO-LINE-NBR are directly under the line number for
LINE-NBR the original item.
PRLSET7 COMPANY KeyChange IC851 PO85.1
LOCATION
ITEM
UPDATE-DATE*
UPDATE-TIME*
REC-NUMBER
LINE-NBR
PRLSET8 COMPANY IC234
REC-NUMBER-A
LINE-NBR
PRLSET9 COMPANY KeyChange IC12.1 PO274
ITEM
LOCATION
REC-NUMBER
LINE-NBR
PORECLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
PRL-COMPANY -> CPY-COMPANY
Apinvoice APINVOICE Not Required
PRL-COMPANY -> API-COMPANY
PRL-VENDOR -> API-VENDOR
PRL-MATCH-OBJ-ID -> API-MATCH-OBJ-ID
PRL-INVOICE -> API-INVOICE
PRL-SUFFIX -> API-SUFFIX
Zeroes -> API-CANCEL-SEQ
Buyer Message POMESSAGE Not Required, Delete Cascades
PRL-COMPANY -> POM-COMPANY
PRL-REC-NUMBER -> POM-REC-NUMBER
PRL-LINE-NBR -> POM-LINE-NBR
Icbin ICBIN Required
When PRL-BIN != Spaces
And PRL-BIN != "* "
PRL-COMPANY -> ICB-COMPANY
PRL-LOCATION -> ICB-LOCATION
PRL-BIN -> ICB-BIN
Iccategory ICCATEGORY Required
When PRL-ITEM-TYPE = "I"
PRL-COMPANY -> ICA-COMPANY
PRL-LOCATION -> ICA-LOCATION
ITL-GL-CATEGORY -> ICA-GL-CATEGORY
Iccompany ICCOMPANY Required
PRL-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
PRL-COMPANY -> ICL-COMPANY
PRL-LOCATION -> ICL-LOCATION
Ictrans ICTRANS Required
When PRL-ITEM-TYPE = "I"
PRL-COMPANY -> ICT-COMPANY
PRL-LOCATION -> ICT-LOCATION
"PO" -> ICT-DOC-TYPE
"PO" -> ICT-SYSTEM-CD
PRL-REC-NUMBER-A -> ICT-DOCUMENT
Zeroes -> ICT-SHIPMENT-NBR
PRL-LINE-NBR -> ICT-LINE-NBR
Zeroes -> ICT-COMPONENT-SEQ
Itemloc ITEMLOC Required
When PRL-ITEM-TYPE = "I"
PRL-COMPANY -> ITL-COMPANY
PRL-LOCATION -> ITL-LOCATION
PRL-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When PRL-ITEM-TYPE = "I"
Or PRL-ITEM-TYPE = "N"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
PRL-ITEM -> ITE-ITEM
Macompany MACOMPANY Required
PRL-COMPANY -> MAY-COMPANY
Mainvdtl MAINVDTL Required
When PRL-MATCH-OBJ-ID != Zeroes
PRL-COMPANY -> MAD-COMPANY
PRL-MATCH-OBJ-ID -> MAD-MATCH-OBJ-ID
PRL-MATCH-SEQ-NBR -> MAD-MATCH-SEQ-NBR
Pocompany POCOMPANY Required
PRL-COMPANY -> PCY-COMPANY
Poline POLINE Required
PRL-COMPANY -> PLI-COMPANY
PRL-PO-NUMBER -> PLI-PO-NUMBER
PRL-PO-RELEASE -> PLI-PO-RELEASE
PRL-PO-CODE -> PLI-PO-CODE
PRL-LINE-NBR -> PLI-LINE-NBR
Poreceive PORECEIVE Required
PRL-COMPANY -> POR-COMPANY
PRL-REC-NUMBER -> POR-REC-NUMBER
Purchorder PURCHORDER Required
PRL-COMPANY -> PCR-COMPANY
PRL-PO-CODE -> PCR-PO-CODE
PRL-PO-NUMBER -> PCR-PO-NUMBER
PRL-PO-RELEASE -> PCR-PO-RELEASE
Vendloc APVENLOC Required
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
PRL-VENDOR -> VLO-VENDOR
PLI-PURCH-FR-LOC -> VLO-LOCATION-CODE
Vendor APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
POR-VENDOR -> VEN-VENDOR
PORECLINE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ictransdtl ICTRANSDTL
PRL-COMPANY -> ICD-COMPANY
PRL-LOCATION -> ICD-LOCATION
"PO" -> ICD-DOC-TYPE
"PO" -> ICD-SYSTEM-CD
PRL-REC-NUMBER-A -> ICD-DOCUMENT
Zeroes -> ICD-SHIPMENT-NBR
PRL-LINE-NBR -> ICD-LINE-NBR
Zeroes -> ICD-COMPONENT-SEQ
ICD-TRANS-SEQ
ICD-SEQ
Mmdist MMDIST
PRL-COMPANY -> MMD-COMPANY
"PO" -> MMD-SYSTEM-CD
PRL-LOCATION -> MMD-LOCATION
"P" -> MMD-DOC-TYPE
PRL-PO-NUMBER -> MMD-DOC-NUMBER
PRL-PO-RELEASE -> MMD-DOC-NBR-NUM
PRL-PO-CODE -> MMD-PO-CODE
PRL-PO-LINE-NBR -> MMD-LINE-NBR
Zeroes -> MMD-COMPONENT-SEQ
Spaces -> MMD-AOC-CODE
MMD-LINE-SEQ
MMD-REQ-LOCATION
MMD-API-OBJ-ID
Porecadjln PORECADJLN
PRL-COMPANY -> PJL-COMPANY
PRL-REC-NUMBER -> PJL-REC-NUMBER
PRL-LINE-NBR -> PJL-LINE-NBR
PJL-DOC-TYPE
PJL-DOC-NBR-NUM
Potransdtl POTRANSDTL Delete Cascades
PRL-COMPANY -> POT-COMPANY
"PO" -> POT-DOC-TYPE
PRL-REC-NUMBER -> POT-DOC-NBR-NUM
PRL-LINE-NBR -> POT-LINE-NBR
POT-TRANS-SEQ
POT-SEQ
Substitutes PORECLINE
Valid When PRL-PO-LINE-NBR != PRL-LINE-NBR
PRL-COMPANY -> PRL-COMPANY
PRL-PO-CODE -> PRL-PO-CODE
PRL-PO-NUMBER -> PRL-PO-NUMBER
PRL-PO-RELEASE -> PRL-PO-RELEASE
PRL-LOCATION -> PRL-LOCATION
PRL-MATCH-DTL-KEY -> PRL-MATCH-DTL-KEY
PRL-PO-LINE-NBR
PRL-REC-NUMBER
PRL-LINE-NBR
|
