PORETURNHD FILE
PO Return Header
REFERENCED BY
PO01.1 PO274 PO64.1 PO81.1 POCP.1 POED.1
POI4.1 POI6.1 PO231
UPDATED BY
AP30.4 API1.1 API2.1 PO132 PO136 PO190
POIJ.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTH-COMPANY Numeric 4 POIJ.1
Company The company number.
PTH-RETURN-NUMBER Numeric 10 POIJ.1
Return Number This is the number assigned to the
return for purposes of referencing the
return internally and with the customer
or vendor.
PTH-REFERENCE-NO Alpha 10 (Right Justified) POIJ.1
Reference No
PTH-RETURN-FRM-LOC Alpha 5 POIJ.1
Return From Location This field indicates the physical
location the return is being made from.
PTH-USER-ID Alpha 10 (Lower Case) POIJ.1
User ID Name This is the user ID of the person who
created the return.
PTH-CREATION-DATE Numeric 8 (yyyymmdd) POIJ.1
Creation Date This is the date the return was created.
PTH-REASON-CODE Alpha 4 POIJ.1
Reason Code This field is the code that indicates
the reason the return was created.
PTH-VENDOR Alpha 9 (Right Justified) POIJ.1
Vendor ID The vendor's identification code.
PTH-PURCH-FR-LOC Alpha 4 POIJ.1
Purchase From This is the address of the vendor
Location Code location the goods are being returned
to, if it is different than the main
vendor address.
PTH-AUTHORIZE-DATE Numeric 8 (yyyymmdd) POIJ.1
Vendor This is the date the return was
Authorization Date authorized by the vendor.
PTH-RMA-NUMBER Alpha 22 POIJ.1
Rma Number This is the number of the RMA (Return
Material Authorization) given by the
vendor.
PTH-RMA-PRINTED-FL Alpha 1 PO132 POIJ.1
RMA Printed Flag This flag indicates whether RMA
documents that need to be shipped with
the return have been printed.
N = No
Y = Yes
PTH-CURRENCY-CODE Alpha 5 POIJ.1
Currency Code The base currency defined for the
company in the General Ledger system.
PTH-CONTACT Alpha 20 POIJ.1
Primary Contact This is the name of the main contact.
PTH-PHONE-PREFIX Alpha 6 POIJ.1
Telephone Country The telephone number country code.
Code
PTH-PHONE-NUM Alpha 15 POIJ.1
Telephone Number This is the main telephone number.
PTH-PHONE-EXT Alpha 5 POIJ.1
Telephone Extension This field contains the telephone
extension number.
PTH-DROPSHIP-FL Alpha 1 POIJ.1
Dropship Flag This flag indicates whether goods being
shipped by the vendor directly to a non
standard location need to have the
receiving process performed.
N = Not Drop Shipped
Y = Drop Shipped
PTH-SH-NAME Alpha 30 (Lower Case) POIJ.1
Ship To Name This is the ship-to name for a
non-standard ship-to address.
PTH-SH-ADDR1 Alpha 30 (Lower Case) POIJ.1
Ship To Address This is the ship-to address line one.
Line 1
PTH-SH-ADDR2 Alpha 30 (Lower Case) POIJ.1
Ship To Address This is the ship-to address line two.
Line 2
PTH-SH-ADDR3 Alpha 30 (Lower Case) POIJ.1
Ship To Address This is the ship-to address line three.
Line 3
PTH-SH-ADDR4 Alpha 30 (Lower Case) POIJ.1
Ship To Address This is the ship-to address line four.
Line 4
PTH-SH-CITY-ADDR5 Alpha 18 (Lower Case) POIJ.1
Ship To City or This is the ship-to city or the ship-to
Address Line 5 address line five.
PTH-SH-STATE-PROV Alpha 2 POIJ.1
Ship To State or This is the ship-to state or the
Province ship-to province.
PTH-SH-COUNTY Alpha 25 (Lower Case) POIJ.1
Sh County
PTH-SH-POST-CODE Alpha 10 (Lower Case) POIJ.1
Ship To Postal Code This is the ship-to mail code.
PTH-SH-COUNTRY Alpha 30 (Lower Case) POIJ.1
Ship To Country This is the ship-to country.
PTH-ORIG-FRT-CR-AM Signed 15.2 POIJ.1
Original Freight This is the amount of credit the vendor
Credit Amount has promised to allow against the
freight charges incurred when the return
goods were originally shipped.
PTH-ORIG-FRT-CR-AU Alpha 15 POIJ.1
Original Freight Cr This is the accounting unit that
Acct Unit freight credit will be applied against.
This may default from the return
location.
PTH-ORIG-FRT-CR-AC Numeric 6 POIJ.1
Original Freight This is the account that freight credit
Credit Acct will be applied against. This may
default from the return location.
PTH-ORIG-FRT-CR-SA Numeric 4 POIJ.1
Original Freight Cr This is the subaccount that freight
Sub Acct credit will be applied against. This may
default from the return location.
PTH-RTV-FRT-CR-AM Signed 15.2 POIJ.1
Return Frt. Credit This is the amount of credit the vendor
Amount has promised to allow against the
freight charges that will be incurred
when goods are returned.
PTH-RTV-FRT-CR-AU Alpha 15 POIJ.1
Return Frt. Credit This is the accounting unit that
Acct Unit freight credit will be applied against.
This may default from the return
location.
PTH-RTV-FRT-CR-ACT Numeric 6 POIJ.1
Return Frt. Credit This is the account that freight credit
Account will be applied against. This may
default from the return location.
PTH-RTV-FRT-CR-SA Numeric 4 POIJ.1
Return Frt. Credit This is the subaccount that freight
Subaccount credit will be applied against. This may
default from the return location.
PTH-HANDLING-AM Signed 15.2 POIJ.1
Handling Amount This is the amount the vendor will
charge for handling against the return.
PTH-HANDLING-AU Alpha 15 POIJ.1
Handling Accounting This is the accounting unit that
Unit handling charges will be applied
against. This may default from the
return location.
PTH-HANDLING-AC Numeric 6 POIJ.1
Handling Account This is the account that handling
charges will be applied against. This
may default from the return location.
PTH-HANDLING-SA Numeric 4 POIJ.1
Handling Subaccount This is the subaccount that handling
charges will be applied against. This
may default from the return location.
PTH-REPL-FRT-AM Signed 15.2 POIJ.1
Replacement Freight This is the amount of freight charges
Amount it is estimated will be incurred when
replacement goods are received from the
vendor.
PTH-AOC-CODE Alpha 2 POIJ.1
Add On Cost Code This field contains the identifier for
the add-on cost associated with this
line item. This is the add-on cost code
that will be carried on the replacement
purchase order created from the return.
It will be carried as a miscellaneous
add-on cost.
PTH-VEN-CLAIM-TYPE Alpha 2 POIJ.1
Ven Claim Type CB = Chargeback
CM = Credit Memo
NC = No Charge
PTH-REPLACE-GOODS Alpha 1 POIJ.1
Replace Goods Y = Yes
N = No
PTH-SHIP-OR-HOLD Alpha 1 POIJ.1
Ship Or Hold S = Ship
H = Hold
PTH-RET-PO-NUMBER Alpha 14 POIJ.1
Ret Po Number This is the purchase order number
attached to the return purchase order
created to replace return goods.
PTH-RET-PO-CODE Alpha 4 POIJ.1
Ret Po Code This is the PO code that will be used on
the return PO created from a vendor
return. It can be entered when the
return is created, or defaulted from PO
code defaults.
PTH-RET-PO-BUYER Alpha 3 POIJ.1
Ret Po Buyer
PTH-PROCESS-LEVEL Alpha 5 POIJ.1
Process Level This field indicates the process level
to be used if a debit memo is created.
PTH-IVEND-SHIP-VIA Alpha 12 POIJ.1
Inbound frm Vendor This is the shipping method to be used
Ship Via for a replacement shipment.
PTH-VEND-REQ-DATE Numeric 8 (yyyymmdd) POIJ.1
Vendor Requested This is the date a replacement shipment
Delivery Date is required to be received. This date
will be used for the early delivery date
on the replacement purchase order.
PTH-OVEND-SHIP-VIA Alpha 12 POIJ.1
Return To Vendor This is the shipping method to be used
Ship Via for the shipment of return goods to the
vendor. This may be defaulted from the
vendor.
PTH-CARRIER Alpha 9 (Right Justified) POIJ.1
Carrier Vendor This is the carrier vendor number. It
Number must be a valid vendor.
PTH-OVEND-SHP-DATE Numeric 8 (yyyymmdd) POIJ.1
Return To Vendor This is the date the return goods were
Ship Date shipped to the vendor.
PTH-OVEND-SHP-TIME Numeric 6 POIJ.1
Ovend Shp Time
PTH-OVEND-BOL Alpha 10 POIJ.1
Return To Vend. The is the bill of lading number
Bill Of Lading assigned to the vendor return shipment.
PTH-OVEND-USER-ID Alpha 10 POIJ.1
Returned By This is the user ID of the person
returning the goods to the vendor.
PTH-RETURN-VALUE Signed 15.2 POIJ.1
Return Value This field indicates the value of the
return, including freight credit and
handling charges.
PTH-CREDIT-RECVD Signed 15.2 AP30.4 POIJ.1
Credit Amount This field shows the amount of credit
Received that has been received against the
return.
PTH-CREDIT-CL-FL Alpha 1 AP30.4 API1.1
Credit Close Flag For returns where credit is expected, API2.1 PO136
this field indicates if credit has been PO190 POIJ.1
received in an amount equal to or
greater than the value of the return.
N = No
Y = Yes
PTH-REPL-CL-FL Alpha 1 AP30.4 API1.1
Replacement Close For return where replacement goods are API2.1 PO136
Flag expected, this field indicates if all PO190 POIJ.1
replacement goods have been fully
received.
N = No
Y = Yes
PTH-LAST-LINE-NBR Numeric 6 POIJ.1
Last Line Number This is the number of the last line
item added to the return. It is used to
determine the number when the next line
is added to the return.
PTH-CANCEL-OPTIONS Alpha 1 POIJ.1
Cancel Options 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
PTH-CANCEL-USERID Alpha 10 POIJ.1
Cancel Userid This is the user ID of the person who
performed a cancel action at whole
return level.
PTH-CLOSE-DATE Numeric 8 (yyyymmdd) AP30.4 API1.1
Close Date This is the date the return was closed. API2.1 PO136
PO190 POIJ.1
PTH-STATUS Numeric 1 AP30.4 API1.1
Status This is the status of the return. API2.1 PO136
0 = Added PO190 POIJ.1
1 = Authorized By Vendor
2 = Waiting For Vendor Action
9 = Closed
PTH-JRNL-BOOK-NBR Alpha 12 POIJ.1
Journal Book The journal book assigned to the
transaction.
PTH-FOB-CODE Alpha 3
Shipping Term Code The user defined Free On Board Code.
PTH-LOADING-PORT Alpha 5
Loading Port The port where the goods are loaded, if
required. The port code must be defined
in IN04.1 (Port Maintenance)
PTH-NOTC Alpha 2
Notc The Nature of Transaction code. Must
be a valid code defined in IN07.1 (NOTC
Maintenance).
PTH-STAT-PROC Alpha 6
Stat Proc The statistical procedure code applied
to the data. The code must be defined
in IN06.1. (Statistical Procedure
Maintenance).
PTH-DEST-REGION Alpha 2
Dest Region The region of the country to which the
goods were shipped, if required. Must
be a valid region in IN02.1 (Region
Maintenance)
PORETURNHD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTHSET1 COMPANY AP30.4 API1.1
RETURN-NUMBER* API2.1 PO01.1
PO132 PO136
PO190 PO274
PO64.1 PO81.1
POCP.1 POED.1
POI4.1 POI6.1
POIJ.1
PTHSET2 COMPANY PO231
VENDOR
CREATION-DATE*
RETURN-NUMBER
PTHSET3 COMPANY Subset
REFERENCE-NO Where REFERENCE-NO != Spaces
RETURN-NUMBER
PORETURNHD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Aoc Code POAOCMAST Required
PTH-COMPANY -> PAM-COMPANY (PAMSET1)
PTH-AOC-CODE -> PAM-AOC-CODE
Apcompany APCOMPANY Required
PTH-COMPANY -> CPY-COMPANY
Carrier Vendr APVENMAST Required
When PTH-CARRIER != Spaces
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
PTH-CARRIER -> VEN-VENDOR
Pocompany POCOMPANY Required
PTH-COMPANY -> PCY-COMPANY
Purchase From APVENLOC Required
When PTH-PURCH-FR-LOC != Spaces
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
PTH-VENDOR -> VLO-VENDOR
PTH-PURCH-FR-LOC -> VLO-LOCATION-CODE
Reason Code REASON Required
PTH-COMPANY -> REA-COMPANY
PTH-REASON-CODE -> REA-REASON-CODE
Return Frm Loc ICLOCATION Required
PTH-COMPANY -> ICL-COMPANY
PTH-RETURN-FRM-LOC -> ICL-LOCATION
Vendor APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
PTH-VENDOR -> VEN-VENDOR
PORETURNHD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Replcmnt Po Ln POLINE
Valid When PTH-RET-PO-NUMBER != Spaces
PTH-COMPANY -> PLI-COMPANY
PTH-RET-PO-NUMBER -> PLI-PO-NUMBER
Zeroes -> PLI-PO-RELEASE
PTH-RET-PO-CODE -> PLI-PO-CODE
PLI-LINE-NBR
Returnline PORETURNLN Delete Cascades
PTH-COMPANY -> PTL-COMPANY
PTH-RETURN-NUMBER -> PTL-RETURN-NUMBER
PTL-RET-LINE-NBR
|
