PORETURNLN FILE
PO Return Line
REFERENCED BY
API1.1 API2.1 PO132 PO231 PO274 POCP.1
PO64.1
UPDATED BY
POIJ.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTL-COMPANY Numeric 4
Company The company number.
PTL-RETURN-NUMBER Numeric 10
Return Number This is the number assigned to the
return for purposes of referencing the
return internally and with the customer
or vendor.
PTL-RETURN-NUMBERA Alpha 10 (Right Justified)
Return Numbera
PTL-REFERENCE-NO Alpha 10 (Right Justified)
Reference No
PTL-RET-LINE-NBR Numeric 6
Return Line Number This is the return line number.
PTL-ORIG-PO-NBR Alpha 14 (Right Justified)
Original PO Number This is the original purchase order
number the return line is from.
PTL-ORIG-PO-REL Numeric 4
Original PO Release This is the release number of the
Number original purchase order the return line
is from.
PTL-ORIG-PO-CODE Alpha 4
Orig Po Code
PTL-ORIG-PO-LN-NBR Numeric 6
Original PO Line This is the line number of the original
Number purchase order the return line is from.
PTL-DOC-NBR-NUM Numeric 10
Doc Nbr Num For return lines created from inspection
rejections, this field holds the
document number of the rejection to
allow for drill backs.
PTL-REC-NUMBER Numeric 10
Receiver Number The receiver number the return line was
created from as a result of a receiving
buyer message.
PTL-ITEM Alpha 32
Item Number This field contains the item
identifier.
PTL-MATCH-DTL-KEY Alpha 55
Match Dtl Key
PTL-DESCRIPTION Alpha 30 (Lower Case)
Description This is the item description.
PTL-ITEM-TYPE Alpha 1
Item Type This field identifies the line item
type.
I = Inventoried
N = Non-stock
X = Special
S = Service
PTL-RETURN-QTY Signed 13.4
Quantity Returned This is the quantity on the return line.
PTL-ADJUSTMENT-QTY Signed 13.4 POIJ.1
Adjustment Quantity This field indicates the adjustment
quantity for adjustments made to the
return after it is shipped to the
vendor.
PTL-CATCH-WT-QTY Signed 13.4
Catch Weight This field contains the quantity
Quantity received for catch weight shipments.
PTL-DETAIL-BAL-FL Alpha 1
Detail Balance Flag Y = Yes
N = No
PTL-ENTERED-UOM Alpha 4
Entered Unit of This is the valid unit of measure of
Measure the entered quantity.
PTL-ENT-UOM-MULT Signed 13.7
Entered UOM This is the multiplier that relates the
Multiplier entered unit of measure to stock unit of
measure.
PTL-VPRI-UOM Alpha 4
Vendor Price Unit This is the vendor pricing unit of
of Measure measure.
PTL-VPRI-UOM-MULT Signed 13.7
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.
PTL-UNIT-COST Signed 13.5 POIJ.1
Unit Cost This field contains the unit cost.
PTL-INSP-REQ-FL Alpha 1
Inspection Required This flag indicates whether this item
Flag has to be inspected when received via
purchase order.
N = No
Y = Yes
PTL-TAX-CODE Alpha 10
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
PTL-TAX-USAGE-CD Alpha 10
Tax Usage Cd The tax usage coe for the vendor. This
filed is required if the AP Company
inidcates that VAT reporting required.
PTL-LAST-DST-SEQ Numeric 3 POIJ.1
Last Distribution This is the sequence number of the last
Sequence Nbr distribution line for this return line.
PTL-LAST-POT-SEQ Numeric 6
Last Pot Seq
PTL-CANCEL-OPTIONS Alpha 1 POIJ.1
New Quantity For This option indicates at header or line
level, whether both a return and return
purchase order should be canceled, or
just one or the other. If a cancel
option is chosen at line level, a cancel
quantity must also be entered. Once a
cancel option is set, it cannot be
changed or undone.
Y = Canceled
N
PTL-ICN-CODE Alpha 8
Icn Code
PTL-SUPLMNTARY-QTY Signed 13.4
Suplmntary Qty
PTL-WEIGHT Signed 9.3
Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
PTL-INTRASTAT-NBR Numeric 12 POIJ.1
Intrastat Nbr The number assigned by the Intrastat
system to a transaction that involves
Intrastat reporting after it has been
added.
PORETURNLN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTLSET1 COMPANY API1.1 API2.1
RETURN-NUMBER PO132 PO231
RET-LINE-NBR PO274 POCP.1
POIJ.1
PTLSET2 COMPANY Subset
RETURN-NUMBERAWhere ITEM-TYPE = "I"
RET-LINE-NBR
PTLSET3 COMPANY Subset PO64.1 POIJ.1
ORIG-PO-NBR Where ORIG-PO-NBR != Spaces
ORIG-PO-REL
ORIG-PO-CODE
ORIG-PO-LN-NBR
RETURN-NUMBER
RET-LINE-NBR
PORETURNLN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccategory ICCATEGORY Required
When PTL-ITEM-TYPE = "I"
PTL-COMPANY -> ICA-COMPANY
PTH-RETURN-FRM-LOC -> ICA-LOCATION
ITL-GL-CATEGORY -> ICA-GL-CATEGORY
Iccompany ICCOMPANY Required
PTL-COMPANY -> ICC-COMPANY
Inspreturns PORECADJLN Required
PTL-COMPANY -> PJL-COMPANY
"IN" -> PJL-DOC-TYPE
PTL-DOC-NBR-NUM -> PJL-DOC-NBR-NUM
PTL-ORIG-PO-LN-NBR -> PJL-LINE-NBR
Itemloc ITEMLOC Required
When PTL-ITEM-TYPE = "I"
PTL-COMPANY -> ITL-COMPANY
PTH-RETURN-FRM-LOC -> ITL-LOCATION
PTL-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When PTL-ITEM-TYPE = "I"
Or PTL-ITEM-TYPE = "N"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
PTL-ITEM -> ITE-ITEM
Original Po POLINE Required
PTL-COMPANY -> PLI-COMPANY
PTL-ORIG-PO-NBR -> PLI-PO-NUMBER
PTL-ORIG-PO-REL -> PLI-PO-RELEASE
PTL-ORIG-PO-CODE -> PLI-PO-CODE
PTL-ORIG-PO-LN-NBR -> PLI-LINE-NBR
Porecadjln PORECADJLN Required
When PTL-DOC-NBR-NUM != Zeroes
PTL-COMPANY -> PJL-COMPANY
"IN" -> PJL-DOC-TYPE
PTL-DOC-NBR-NUM -> PJL-DOC-NBR-NUM
PTL-ORIG-PO-LN-NBR -> PJL-LINE-NBR
Porecadjln2 PORECADJLN Required
When PTL-DOC-NBR-NUM != Zeroes
PTL-COMPANY -> PJL-COMPANY
"RA" -> PJL-DOC-TYPE
PTL-DOC-NBR-NUM -> PJL-DOC-NBR-NUM
PTL-ORIG-PO-LN-NBR -> PJL-LINE-NBR
Porecline PORECLINE Required
When PTL-REC-NUMBER != Zeroes
PTL-COMPANY -> PRL-COMPANY
PTL-REC-NUMBER -> PRL-REC-NUMBER
PTL-ORIG-PO-LN-NBR -> PRL-LINE-NBR
Returnheader PORETURNHD Required
PTL-COMPANY -> PTH-COMPANY
PTL-RETURN-NUMBER -> PTH-RETURN-NUMBER
PORETURNLN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mmdist MMDIST
Valid When PTL-ITEM-TYPE != "I"
PTL-COMPANY -> MMD-COMPANY
"PO" -> MMD-SYSTEM-CD
PTH-RETURN-FRM-LOC -> MMD-LOCATION
"VR" -> MMD-DOC-TYPE
Spaces -> MMD-DOC-NUMBER
PTL-RETURN-NUMBER -> MMD-DOC-NBR-NUM
Spaces -> MMD-PO-CODE
PTL-RET-LINE-NBR -> MMD-LINE-NBR
Zeroes -> MMD-COMPONENT-SEQ
Spaces -> MMD-AOC-CODE
MMD-LINE-SEQ
MMD-REQ-LOCATION
MMD-API-OBJ-ID
Potransdtl POTRANSDTL
PTL-COMPANY -> POT-COMPANY
"VR" -> POT-DOC-TYPE
PTL-RETURN-NUMBER -> POT-DOC-NBR-NUM
PTL-RET-LINE-NBR -> POT-LINE-NBR
POT-TRANS-SEQ
POT-SEQ
Sohdetail SOHDETAIL
Valid When PTL-ITEM-TYPE = "I"
PTL-COMPANY -> SDT-COMPANY
PTH-RETURN-FRM-LOC -> SDT-LOCATION
PTL-ITEM -> SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
|
