 |
Lawson Insight Technical Documentation |
|
PORETURNLN FILE
PO Return Line
REFERENCED BY
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP23.1 API1.1 API2.1 MA41.2 PO132 PO231
PO274 POCP.1 PO64.1
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 IC28.1 MA180 MA43.9 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.3 MA67.1
MA67.2 MA70.1 MAI1.1 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
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
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
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
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
Return 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
Original 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
Original PO Release This is the release number of the PO30.2 PO30.3
Number 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
Orig 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
Original PO Line This is the line number of the original PO30.2 PO30.3
Number 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
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
Receiver 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
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 55 MA531 PO30.1
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
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
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
Quantity Returned 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
Adjustment 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 IC28.1
vendor. MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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.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
PTL-CATCH-WT-QTY Signed 13.4 MA531 PO30.1
Catch Weight This field contains the quantity PO30.2 PO30.3
Quantity received for catch weight shipments. PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-DETAIL-BAL-FL Alpha 1 MA531 PO30.1
Detail Balance 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
Entered Unit of This is the valid unit of measure of PO30.2 PO30.3
Measure the entered quantity. PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-ENT-UOM-MULT Signed 13.7 MA531 PO30.1
Entered UOM 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
Vendor Price Unit This is the vendor pricing unit of PO30.2 PO30.3
of Measure measure. PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-VPRI-UOM-MULT Signed 13.7 MA531 PO30.1
Vendor Price UOM 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 13.5 AP125 AP126
Unit Cost This field contains the unit cost. AP131 AP25.1
AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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.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
PTL-INSP-REQ-FL Alpha 1 MA531 PO30.1
Inspection Required This flag indicates whether this item PO30.2 PO30.3
Flag 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
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
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
Last Distribution This is the sequence number of the last AP131 AP25.1
Sequence Nbr distribution line for this return line. AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
PTL-LAST-POT-SEQ Numeric 6 MA531 PO30.1
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
New Quantity For This 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 IC28.1
just one or the other. If a cancel MA180 MA43.9
option is chosen at line level, a cancel MA530 MA531
quantity must also be entered. Once a MA60.2 MA60.3
cancel option is set, it cannot be MA60.5 MA61.1
changed or undone. MA66.3 MA67.1
Y = Canceled MA67.2 MA70.1
N MAI1.1 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.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
PTL-ICN-CODE Alpha 8 MA531 PO30.1
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
Suplmntary Qty PO30.2 PO30.3
PO31.1 PO31.2
PO33.1 PO34.1
PO52.1
PTL-WEIGHT Signed 9.3 MA531 PO30.1
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
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 IC28.1
added. MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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.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
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
API1.1 API2.1
IC28.1 MA180
MA41.2 MA43.2
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
...
PTLSET2 COMPANY Subset
RETURN-NUMBERAWhere ITEM-TYPE = "I"
RET-LINE-NBR
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 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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
|