Lawson Insight Technical Documentation |
|
PORETURNLN
PORETURNLN FILE
PO Return Line
REFERENCED BY
API2.1 IC130 IC282 MA540 PO132 PO231
PO274 PO58.2 POCP.1 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 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 IC28.1 MA180
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
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 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.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 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 POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3
RQIE.1 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 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 AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
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
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PTL-CATCH-WT-QTY Signed 13.4 MA531 PO30.1
Element: Quantity PO30.2 PO30.3
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 Measure PO30.2 PO30.3
PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-VPRI-UOM-MULT Signed 13.7 MA531 PO30.1
Unit of Measure PO30.2 PO30.3
Multiplier PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-UNIT-COST Signed 13.5 AP125 AP126
Element: Base Cost AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
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
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
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 AP20.1
distribution line for this return line. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
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
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
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 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 AP23.1
option is chosen at line level, a cancel AP25.1 AP25.2
quantity must also be entered. Once a AP26.1 AP27.1
cancel option is set, it cannot be AP30.4 API1.1
changed or undone. IC28.1 MA180
Y = Canceled MA41.2 MA41.7
N MA43.1 MA43.2
MA43.3 MA43.9
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
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
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 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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
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
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
API2.1 IC130
IC28.1 IC282
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA540
...
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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC242 IC28.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
...
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 AP23.1
RETURN-NUMBER AP25.1 AP25.2
RET-LINE-NBR AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
PTLSET4 COMPANY This key was added to allow alternate AP125 AP126
RETURN-NUMBER file access for correcting DBAPIERROR AP131 AP20.1
RET-LINE-NBR problems. AP20.2 AP20.3
ITEM-TYPE KeyChange AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
PORETURNLN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccategory ICCATEGORY Not Required
Valid 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 Not 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 Not Required
Valid When PTL-ITEM-TYPE = "I"
PTL-COMPANY -> ITL-COMPANY
PTH-RETURN-FRM-LOC -> ITL-LOCATION
PTL-ITEM -> ITL-ITEM
Itemmast ITEMMAST Not Required
Valid When PTL-ITEM-TYPE = "I"
Or PTL-ITEM-TYPE = "N"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
PTL-ITEM -> ITE-ITEM
Original Po POLINE Not 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 Not Required
Valid 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 Not Required
Valid 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 Not Required
Valid 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
|