PORETURNLN

PO Return Line

REFERENCED BY
IC130 IC282 MA540 PO231 PO274 PO58.2
IC242 MM280 MM80.1 MM80.2 PO64.1


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 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC12.1 IC140 IC141 IC142 IC145 IC243
IC330 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC83.1
MA180 MA278 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA43.7 MA44.1 MA44.2 MA53.1
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO220
PO222 PO224 PO225 PO229 PO23.1 PO230
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO26.3 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO28.2 PO280
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 PO300
PO31.1 PO31.2 PO32.1 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO54.5 POCP.1 POD0.1 POI3.1 POID.1 POII.1
POIJ.1 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1 RQII.1
RQIJ.1 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
IC11.1 IC216

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTL-COMPANY
Element: Company
Numeric 4
The company number.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
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.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-RETURN-NUMBERA
Element: Return Numbera
Alpha 10 (Right Justified)
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-REFERENCE-NO
Element: Upn2 Nbr
Alpha 25 (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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
PTL-RET-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-ORIG-PO-NBR
Element: Po Number
Alpha 14 (Right Justified)
This is the original purchase order number the return line is from.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-ORIG-PO-REL
Element: Po Release
Numeric 4
This is the release number of the original purchase order the return line is from.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-ORIG-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
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.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
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.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
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.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-MATCH-DTL-KEY
Element: Match Dtl Key
Alpha 85
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This is the item description.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-ITEM-TYPE
Element: Item Type
Alpha 1
This field identifies the line item type.
I = Inventoried
N = Non-stock
X = Special
S = Service
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-RETURN-QTY
Element: Quantity
Signed 13.4
This is the quantity on the return line.
...
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP25.1 AP25.2
AP30.4 CX20.1
CX20.2 CX20.4
CX20.5 IC12.1
IC282 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA53.1 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
PD10.1 PD10.2
PD20.1 PD20.2
PD20.3 PO04.1
PO04.2 PO10.1
PO10.2 PO15.1
PO15.2 PO15.4
PO20.1 PO20.6
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
PTL-CATCH-WT-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-DETAIL-BAL-FL
Element: All Flag
Alpha 1

Y = Yes
N = No
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO52.1
PTL-ENTERED-UOM
Element: Uom
Alpha 4
This is the valid unit of measure of the entered quantity.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
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.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-VPRI-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
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.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.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
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
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.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
PTL-LAST-POT-SEQ
Element: Last Pot Seq
Numeric 6
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO32.2
PO32.4 PO33.1
PO34.1 PO52.1
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
PTL-ICN-CODE
Element: Icn Code
Alpha 8
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-SUPLMNTARY-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-WEIGHT
Element: Weight
Signed 9.3
This field contains the unit weight of the item based on the stocking UOM.
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
PTL-VEN-ITEM
Element: Item
Alpha 32
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-VEN-AGRMT-REF
Element: Agreement Ref
Alpha 30
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-PROD-TAX-CAT
Element: Prod Tax Cat
Alpha 15
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
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
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-CREATED-BY
Element: Operator
Alpha 10
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-LAST-UPDT-DATE
Element: Date
Numeric 8 (yyyymmdd)
...
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
PTL-LAST-UPDT-TIME
Element: Time
Numeric 8
...
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
PTL-LAST-UPDATE-BY
Element: Operator
Alpha 10
...
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
PTL-GLBL-LINE-TYPE
Element: Glbl Line Type
Alpha 15
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-TEMP-HOLD
Element: Temp Hold
Alpha 1

S = Sent for Approval
A = Approved by Engine


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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100


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: Thu Jun 09 02:27:45 2016

Home
Contact Us



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