Lawson Insight Technical Documentation |
|
PORETURNLN
PORETURNLN FILE
PO Return Line
REFERENCED BY
API1.1 API2.1 IC130 IC282 PO132 PO231
PO274 PO58.2 POCP.1 MM280 PO64.1
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 IC28.1 MA180 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.1 MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE111 OE113 OE114 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE81.1 OE810 OE830
OE90.1 OE90.2 PO100 PO101 PO122 PO131
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.1 PO32.2 PO33.1 PO34.1
PO35.1 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 POI3.1 POIE.1 POII.1 POIJ.1
RQ10.1 RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTL-COMPANY Numeric 4 MA531 PO30.1
Element: Company The company number. PO30.2 PO30.3
PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-RETURN-NUMBER Numeric 10 MA531 PO30.1
Element: Return Number This is the number assigned to the PO30.2 PO30.3
return for purposes of referencing the PO31.1 PO31.2
return internally and with the customer PO33.1 PO34.1
or vendor. PO52.1
PTL-RETURN-NUMBERA Alpha 10 (Right Justified) MA531 PO30.1
Element: Return Numbera PO30.2 PO30.3
PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-REFERENCE-NO Alpha 10 (Right Justified) MA531 PO30.1
Element: Reference No PO30.2 PO30.3
PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-RET-LINE-NBR Numeric 6 MA531 PO30.1
Element: Line Number This is the return line number. PO30.2 PO30.3
PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-ORIG-PO-NBR Alpha 14 (Right Justified) MA531 PO30.1
Element: PO Number This is the original purchase order PO30.2 PO30.3
number the return line is from. PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-ORIG-PO-REL Numeric 4 MA531 PO30.1
Element: PO Release NumThis is the release number of the PO30.2 PO30.3
original purchase order the return line PO31.1 PO31.2
is from. PO33.1 PO34.1
PO52.1
PTL-ORIG-PO-CODE Alpha 4 MA531 PO30.1
Element: Po Code PO30.2 PO30.3
PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-ORIG-PO-LN-NBR Numeric 6 MA531 PO30.1
Element: Line Number This is the line number of the original PO30.2 PO30.3
purchase order the return line is from. PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-DOC-NBR-NUM Numeric 10 MA531 PO30.1
Element: Doc Nbr Num For return lines created from inspection PO30.2 PO30.3
rejections, this field holds the PO31.1 PO31.2
document number of the rejection to PO33.1 PO34.1
allow for drill backs. PO52.1
PTL-REC-NUMBER Numeric 10 MA531 PO30.1
Element: Receiver NumbeThe receiver number the return line was PO30.2 PO30.3
created from as a result of a receiving PO31.1 PO31.2
buyer message. PO33.1 PO34.1
PO52.1
PTL-ITEM Alpha 32 MA531 PO30.1
Element: Item Number This field contains the item PO30.2 PO30.3
identifier. PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-MATCH-DTL-KEY Alpha 85 MA531 PO30.1
Element: Match Dtl Key PO30.2 PO30.3
PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-DESCRIPTION Alpha 30 (Lower Case) MA531 PO30.1
Element: Description This is the item description. PO30.2 PO30.3
PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-ITEM-TYPE Alpha 1 MA531 PO30.1
Element: Item Type This field identifies the line item PO30.2 PO30.3
type. PO31.1 PO31.2
I = Inventoried PO33.1 PO34.1
N = Non-stock PO52.1
X = Special
S = Service
PTL-RETURN-QTY Signed 13.4 IC282 MA531
Element: Quantity This is the quantity on the return line. PO30.1 PO30.2
PO30.3 PO31.1
PO31.2 PO33.1
PO34.1 PO52.1
PTL-ADJUSTMENT-QTY Signed 13.4 AP125 AP126
Element: Quantity This field indicates the adjustment AP131 AP25.1
quantity for adjustments made to the AP25.2 AP26.1
return after it is shipped to the AP27.1 AP30.4
vendor. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PTL-CATCH-WT-QTY Signed 13.4 MA531 PO30.1
Element: Quantity This field contains the quantity PO30.2 PO30.3
received for catch weight shipments. PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-DETAIL-BAL-FL Alpha 1 MA531 PO30.1
Element: All Flag Y = Yes PO30.2 PO30.3
N = No PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO52.1
PTL-ENTERED-UOM Alpha 4 MA531 PO30.1
Element: Unit of MeasurThis is the valid unit of measure of PO30.2 PO30.3
the entered quantity. PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-ENT-UOM-MULT Signed 13.7 MA531 PO30.1
Unit of Measure This is the multiplier that relates the PO30.2 PO30.3
Multiplier entered unit of measure to stock unit of PO31.1 PO31.2
measure. PO33.1 PO34.1
PO52.1
PTL-VPRI-UOM Alpha 4 MA531 PO30.1
Element: Unit of MeasurThis is the vendor pricing unit of PO30.2 PO30.3
measure. PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-VPRI-UOM-MULT Signed 13.7 MA531 PO30.1
Unit of Measure This is the vendor pricing unit of PO30.2 PO30.3
Multiplier measure multiplier. It is used to PO31.1 PO31.2
convert unit cost to stock unit of PO33.1 PO34.1
measure terms. PO52.1
PTL-UNIT-COST Signed 18.5 AP125 AP126
Element: Intl Cost This field contains the unit cost. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PTL-INSP-REQ-FL Alpha 1 MA531 PO30.1
Element: All Flag This flag indicates whether this item PO30.2 PO30.3
has to be inspected when received via PO31.1 PO31.2
purchase order. PO33.1 PO34.1
N = No PO52.1
Y = Yes
PTL-TAX-CODE Alpha 10 MA531 PO30.1
Element: Tax Code This field contains a code representing PO30.2 PO30.3
specific tax information. This must be PO31.1 PO31.2
valid Tax Code. PO33.1 PO34.1
PO52.1
PTL-TAX-USAGE-CD Alpha 10 MA531 PO30.1
Element: Tax Usage Cd The tax usage coe for the vendor. This PO30.2 PO30.3
filed is required if the AP Company PO31.1 PO31.2
inidcates that VAT reporting required. PO33.1 PO34.1
PO52.1
PTL-LAST-DST-SEQ Numeric 3 AP125 AP126
Element: Sequence NumbeThis is the sequence number of the last AP131 AP25.1
distribution line for this return line. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PTL-LAST-POT-SEQ Numeric 6 MA531 PO30.1
Element: Last Pot Seq PO30.2 PO30.3
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO52.1
PTL-CANCEL-OPTIONS Alpha 1 AP125 AP126
Element: New Quantity FThis option indicates at header or line AP131 AP25.1
level, whether both a return and return AP25.2 AP26.1
purchase order should be canceled, or AP27.1 AP30.4
just one or the other. If a cancel BL120 BL122
option is chosen at line level, a cancel BL130 BL20.1
quantity must also be entered. Once a BL20.3 BL21.2
cancel option is set, it cannot be BL21.5 BL29.1
changed or undone. BL29.2 BL520
Y = Canceled BL820 BL92.1
N IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PTL-ICN-CODE Alpha 8 MA531 PO30.1
Element: Icn Code PO30.2 PO30.3
PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-SUPLMNTARY-QTY Signed 13.4 MA531 PO30.1
Element: Quantity PO30.2 PO30.3
PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-WEIGHT Signed 9.3 MA531 PO30.1
Element: Unit Weight This field contains the unit weight of PO30.2 PO30.3
the item based on the stocking UOM. PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-INTRASTAT-NBR Numeric 12 AP125 AP126
Element: Intrastat Nbr The number assigned by the Intrastat AP131 AP25.1
system to a transaction that involves AP25.2 AP26.1
Intrastat reporting after it has been AP27.1 AP30.4
added. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PORETURNLN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTLSET1 COMPANY AP125 AP126
RETURN-NUMBER AP131 AP25.1
RET-LINE-NBR AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC130 IC28.1
IC282 MA180
MA530 MA531
MA60.2 MA60.3
...
PTLSET2 COMPANY Subset AP125 AP126
RETURN-NUMBERAWhere ITEM-TYPE = "I" AP131 AP25.1
RET-LINE-NBR AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
PTLSET3 COMPANY Subset MA531 PO30.1
ORIG-PO-NBR Where ORIG-PO-NBR != Spaces PO30.2 PO30.3
ORIG-PO-REL PO31.2 PO33.1
ORIG-PO-CODE PO34.1 PO52.1
ORIG-PO-LN-NBR PO64.1 POIJ.1
RETURN-NUMBER
RET-LINE-NBR
PTLSET4 COMPANY This key was added to allow alternate AP125 AP126
RETURN-NUMBER file access for correcting DBAPIERROR AP131 AP25.1
RET-LINE-NBR problems. AP25.2 AP26.1
ITEM-TYPE KeyChange AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
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
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
|