|
|
PORETURNLN FILE
PO Return Line
REFERENCED BY
MA40.1 PO132 PO231 PO274 PO30.1 PO35.1
PO530 PO64.1
UPDATED BY
MA300 PO31.1 PO32.1 PO32.2 PO32.4 PO32.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTL-COMPANY Numeric 4 PO31.1
Company The company number.
PTL-RETURN-NUMBER Numeric 10 PO31.1
Return Number This is the number assigned to the
return for purposes of referencing the
return internally and with the customer
or vendor.
PTL-RET-LINE-NBR Numeric 6 PO31.1
Return Line Number This is the return line number.
PTL-ORIG-PO-NBR Alpha 7 (Right Justified) PO31.1
Original PO Number This is the original purchase order
number the return line is from.
PTL-ORIG-PO-REL Numeric 6 PO31.1
Original PO Release This is the release number of the
Number original purchase order the return line
is from.
PTL-ORIG-PO-LN-NBR Numeric 6 PO31.1
Original PO Line This is the line number of the original
Number purchase order the return line is from.
PTL-ITEM Alpha 32 PO31.1
Item Number This field contains the item
identifier.
PTL-DESCRIPTION Alpha 30 (Lower Case) PO31.1
Description This is the item description.
PTL-ITEM-TYPE Alpha 1 PO31.1
Item Type This field identifies the line item
type.
I = Inventory
N = Non Stock
X = Special Order
S = Service
PTL-RETURN-QTY Signed 13.4 PO31.1
Quantity Returned This is the quantity on the return line.
PTL-ADJUSTMENT-QTY Signed 13.4 PO31.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 PO31.1
Catch Weight This field contains the quantity
Quantity received for catch weight shipments.
PTL-DETAIL-QTY Signed 13.4 PO32.2
Detail Qty This field shows the total quantity of
details defined for a detail tracked
item. It is matched against the line
quantity field to determine if details
are in balance.
In the item detail subform, it is the
quantity for a particular lot or bin.
PTL-ENTERED-UOM Alpha 4 PO31.1
Entered Unit of This is the valid unit of measure of
Measure the entered quantity.
PTL-ENT-UOM-MULT Signed 13.7 PO31.1
Entered UOM This is the multiplier that relates the
Multiplier entered unit of measure to stock unit of
measure.
PTL-VPRI-UOM Alpha 4 PO31.1
Vendor Price Unit This is the vendor pricing unit of
of Measure measure.
PTL-VPRI-UOM-MULT Signed 13.7 PO31.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.
PTL-UNIT-COST Signed 13.5 PO31.1
Unit Cost This field contains the unit cost.
PTL-INSP-REQ-FL Alpha 1 PO31.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 PO31.1
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
PTL-LAST-COMM-SEQ Numeric 3 PO31.1 PO32.4
Last Comment This is the sequence number of the last PO32.5
Sequence Number comment line entered for this return
line.
PTL-LAST-DST-SEQ Numeric 3 PO31.1 PO32.1
Last Distribution This is the sequence number of the last PO32.2
Sequence Nbr distribution line for this return line.
PTL-LAST-DET-SEQ Numeric 3
Last Detail This is the sequence number of the last
Sequence Number bin, lot, or serial detail line entered
for this line.
PTL-CANCEL-OPTIONS Alpha 1 PO31.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.
B = Both Return And Repl PO
P = Replacement PO Only
R = Return Only
PORETURNLN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTLSET1 COMPANY MA300 MA40.1
RETURN-NUMBER PO132 PO231
RET-LINE-NBR PO274 PO30.1
PO31.1 PO32.1
PO32.2 PO32.4
PO32.5 PO35.1
PO530
PTLSET3 COMPANY Subset PO31.1 PO64.1
ORIG-PO-NBR Where ORIG-PO-NBR != Spaces
ORIG-PO-REL
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
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
When PTL-ORIG-PO-NBR != Spaces
PTL-COMPANY -> PLI-COMPANY
PTL-ORIG-PO-NBR -> PLI-PO-NUMBER
PTL-ORIG-PO-REL -> PLI-PO-RELEASE
PTL-ORIG-PO-LN-NBR -> PLI-LINE-NBR
Returnheader PORETURNHD Required
PTL-COMPANY -> PTH-COMPANY
PTL-RETURN-NUMBER -> PTH-RETURN-NUMBER
Vendoritem POITEMVEN Required
PTL-COMPANY -> PIV-COMPANY
PTL-ITEM -> PIV-ITEM
PTH-VENDOR -> PIV-VENDOR
PORETURNLN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Lncomments POCOMMENTS Delete Cascades
Valid When PTL-LAST-COMM-SEQ > Zeroes
PTL-COMPANY -> POC-COMPANY
Spaces -> POC-ORDER-NAME
PTL-RETURN-NUMBER -> POC-RETURN-NUMBER
Spaces -> POC-PO-NUMBER
Zeroes -> POC-PO-RELEASE
PTL-RET-LINE-NBR -> POC-LINE-NBR
POC-SEQ
Mmdist MMDIST Delete Cascades
Valid When PTL-ITEM-TYPE != "I"
PTL-COMPANY -> MMD-COMPANY
"PO" -> MMD-SYSTEM-CD
Spaces -> MMD-LOCATION
"VR" -> MMD-DOC-TYPE
Spaces -> MMD-DOC-NBR
PTL-RETURN-NUMBER -> MMD-DOC-NBR-NUM
PTL-RET-LINE-NBR -> MMD-LINE-NBR
Zeroes -> MMD-COMPONENT-SEQ
Spaces -> MMD-AOC-CODE
MMD-LINE-SEQ
Poretlndtl PORETLNDTL Delete Cascades
Valid When PTL-LAST-DET-SEQ > Zeroes
PTL-COMPANY -> PTD-COMPANY
PTL-RETURN-NUMBER -> PTD-RETURN-NUMBER
PTL-RET-LINE-NBR -> PTD-RET-LINE-NBR
PTD-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
|