Lawson Insight Technical Documentation |
|
PORETURNLN
PORETURNLN FILE
PO Return Line
REFERENCED BY
API2.1 IC130 MA540 PO132 PO231 PO274
PO58.2 POCP.1 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 API1.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 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 PO100 PO101 PO122 PO131 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 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
POD0.1 POI3.1 POID.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) AP125 AP126
Element: Reference No 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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
PTL-RET-LINE-NBR Numeric 6 MA531 PO30.1
Element: Line Nbr This field contains the 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 This 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 This is the purchase order 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 Nbr 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: Rec Number The 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 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 MA531 PO30.1
Element: Quantity This is the quantity on the return line. 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 contains the desired AP131 AP20.1
quantity. 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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
PTL-CATCH-WT-QTY Signed 13.4 MA531 PO30.1
Element: Quantity This field contains the desired PO30.2 PO30.3
quantity. 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: Uom This 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
Element: Uom Mult This is the multiplier that relates the PO30.2 PO30.3
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: Uom This field contains the valid stock PO30.2 PO30.3
unit of measure for this item. PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-VPRI-UOM-MULT Signed 13.7 MA531 PO30.1
Element: Uom Mult This field contains the multiplier for PO30.2 PO30.3
converting this unit of measure to the PO31.1 PO31.2
stock unit of measure. PO33.1 PO34.1
PO52.1
PTL-UNIT-COST Signed 18.5 AP125 AP126
Element: Intl Cost 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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
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: Seq This is the sequence number of the last AP131 AP20.1
distribution line for this return line. 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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
PTL-LAST-POT-SEQ Numeric 6 MA531 PO30.1
Element: Last Pot Seq PO30.2 PO30.3
PO31.1 PO31.2
PO32.2 PO32.4
PO33.1 PO34.1
PO52.1
PTL-CANCEL-OPTIONS Alpha 1 AP125 AP126
Element: New Quantity FThis option indicates at header or line AP131 AP20.1
level, whether both a return and return AP20.2 AP20.3
purchase order should be canceled, or AP20.4 AP20.5
just one or the other. If a cancel AP20.7 AP21.1
option is chosen at line level, a cancel AP23.1 AP25.1
quantity must also be entered. Once a AP25.2 AP26.1
cancel option is set, it cannot be AP27.1 AP30.4
changed or undone. API1.1 BL120
Y = Canceled BL122 BL130
N BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
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 This field contains the desired PO30.2 PO30.3
quantity. PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-WEIGHT Signed 9.3 MA531 PO30.1
Element: 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 AP20.1
system to a transaction that involves AP20.2 AP20.3
Intrastat reporting after it has been AP20.4 AP20.5
added. AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
PTL-VR-CXL-UPD-SOH Numeric 1 AP125 AP126
Element: Vr Cxl Upd Soh 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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
PORETURNLN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTLSET1 COMPANY AP125 AP126
RETURN-NUMBER AP131 AP20.1
RET-LINE-NBR 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
PTLSET2 COMPANY Subset AP125 AP126
RETURN-NUMBERAWhere ITEM-TYPE = "I" AP131 AP20.1
RET-LINE-NBR 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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
PTLSET3 COMPANY Subset AP125 AP126
ORIG-PO-NBR Where ORIG-PO-NBR != Spaces AP131 AP20.1
ORIG-PO-REL AP20.2 AP20.3
ORIG-PO-CODE AP20.4 AP20.5
ORIG-PO-LN-NBR AP20.7 AP21.1
RETURN-NUMBER AP23.1 AP25.1
RET-LINE-NBR AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
PTLSET4 COMPANY KeyChange AP125 AP126
RETURN-NUMBER AP131 AP20.1
RET-LINE-NBR AP20.2 AP20.3
ITEM-TYPE AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
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
|