PORETURNLN

PO Return Line

REFERENCED BY
MA540 MM280


UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1 PO64.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTL-COMPANY
Element: Company
Numeric 4
The company number.
PTL-RETURN-NUMBER
Element: Return Number
Numeric 10
This is the number assigned to the return for purposes of referencing the return internally and with the customer or vendor.
PTL-RETURN-NUMBERA
Element: Return Numbera
Alpha 10 (Right Justified)
PTL-REFERENCE-NO
Element: Reference No
Alpha 10 (Right Justified)
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PTL-RET-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
PTL-ORIG-PO-NBR
Element: Po Number
Alpha 14 (Right Justified)
This is the original purchase order number the return line is from.
PTL-ORIG-PO-REL
Element: Po Release
Numeric 4
This is the release number of the original purchase order the return line is from.
PTL-ORIG-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
PTL-ORIG-PO-LN-NBR
Element: Line Nbr
Numeric 6
This is the line number of the original purchase order the return line is from.
PTL-DOC-NBR-NUM
Element: Doc Nbr Num
Numeric 10
For return lines created from inspection rejections, this field holds the document number of the rejection to allow for drill backs.
PTL-REC-NUMBER
Element: Rec Number
Numeric 10
The receiver number the return line was created from as a result of a receiving buyer message.
PTL-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
PTL-MATCH-DTL-KEY
Element: Match Dtl Key
Alpha 85
PTL-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This is the item description.
PTL-ITEM-TYPE
Element: Item Type
Alpha 1
This field identifies the line item type.
I = Inventoried
N = Non-stock
X = Special
S = Service
PTL-RETURN-QTY
Element: Quantity
Signed 13.4
This is the quantity on the return line.
PTL-ADJUSTMENT-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PTL-CATCH-WT-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
PTL-DETAIL-BAL-FL
Element: All Flag
Alpha 1

Y = Yes
N = No
PTL-ENTERED-UOM
Element: Uom
Alpha 4
This is the valid unit of measure of the entered quantity.
PTL-ENT-UOM-MULT
Element: Uom Mult
Signed 13.7
This is the multiplier that relates the entered unit of measure to stock unit of measure.
PTL-VPRI-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
PTL-VPRI-UOM-MULT
Element: Uom Mult
Signed 13.7
This field contains the multiplier for converting this unit of measure to the stock unit of measure.
PTL-UNIT-COST
Element: Intl Cost
Signed 18.5
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PTL-INSP-REQ-FL
Element: All Flag
Alpha 1
This flag indicates whether this item has to be inspected when received via purchase order.
N = No
Y = Yes
PTL-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
PTL-TAX-USAGE-CD
Element: Tax Usage Cd
Alpha 10
The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.
PTL-LAST-DST-SEQ
Element: Seq
Numeric 3
This is the sequence number of the last distribution line for this return line.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PTL-LAST-POT-SEQ
Element: Last Pot Seq
Numeric 6
PTL-CANCEL-OPTIONS
Element: New Quantity For
Alpha 1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PTL-ICN-CODE
Element: Icn Code
Alpha 8
PTL-SUPLMNTARY-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
PTL-WEIGHT
Element: Weight
Signed 9.3
This field contains the unit weight of the item based on the stocking UOM.
PTL-INTRASTAT-NBR
Element: Intrastat Nbr
Numeric 12
The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PTL-VR-CXL-UPD-SOH
Element: Vr Cxl Upd Soh
Numeric 1
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PTL-VEN-ITEM
Element: Item
Alpha 32
PTL-VEN-AGRMT-REF
Element: Agreement Ref
Alpha 30
PTL-PROD-TAX-CAT
Element: Prod Tax Cat
Alpha 15
PTL-CM-CONTRACT
Element: Cm Contract
Numeric 15
PTL-MFG-CONTRACT
Element: Cm Contract
Numeric 15
PTL-CONTRACT-GROUP
Element: Enterprise Grp
Alpha 4
PTL-GTIN
Element: Gtin
Numeric 14


PORETURNLN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTLSET1 COMPANY
RETURN-NUMBER
RET-LINE-NBR
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PTLSET2 COMPANY
RETURN-NUMBERA
RET-LINE-NBR
Subset
WhereITEM-TYPE ="I"
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PTLSET3 COMPANY
ORIG-PO-NBR
ORIG-PO-REL
ORIG-PO-CODE
ORIG-PO-LN-NBR
RETURN-NUMBER
RET-LINE-NBR
Subset
WhereORIG-PO-NBR !=Spaces
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PTLSET4 COMPANY
RETURN-NUMBER
RET-LINE-NBR
ITEM-TYPE
KeyChange
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136


PORETURNLN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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"
OrPTL-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
NAME
RELATED 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
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


File created: Wed Jun 08 20:50:55 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.