PORETURNHD FILE
PO Return Header
This file contains header information for vendor returns. Included in the
header information is details about how the return is to be processed, how it
was authorized, how it was shipped, and whether or not it has been closed.
REFERENCED BY
MA00.3 MA40.1 PO180 PO274 PO81.1 PO231
UPDATED BY
AP125 AP126 AP225 AP226 AP25.1 AP25.2
AP26.1 AP30.4 BL92.1 MA190 MA300 MA530
MA540 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 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE510 OE810 OE920 PO100 PO132 PO20.1
PO21.6 PO22.2 PO22.3 PO30.1 PO31.1 PO32.4
PO32.5 PO33.1 PO35.1 PO530 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTH-COMPANY Numeric 4 PO31.1
Company The company number.
PTH-RETURN-NUMBER Numeric 10 PO31.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-RETURN-FRM-LOC Alpha 5 PO31.1
Return From Location This field indicates the physical
location the return is being made from.
PTH-USER-ID Alpha 10 (Lower Case) PO31.1
User ID Name This is the user ID of the person who
created the return.
PTH-CREATION-DATE Numeric 8 (yyyymmdd) PO31.1
Creation Date This is the date the return was created.
PTH-REASON-CODE Alpha 4 PO31.1
Reason Code This field is the code that indicates
the reason the return was created.
PTH-VENDOR Alpha 9 PO31.1
Vendor ID The vendor's identification code.
PTH-PURCH-FR-LOC Alpha 4 PO31.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) PO31.1
Vendor This is the date the return was
Authorization Date authorized by the vendor.
PTH-RMA-NUMBER Alpha 10 PO31.1
Rma Number This is the number of the RMA (Return
Material Authorization) given by the
vendor.
PTH-RMA-PRINTED-FL Alpha 1 PO132 PO31.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 PO31.1
Currency Code The base currency defined for the
company in the General Ledger system.
PTH-CONTACT Alpha 20 PO31.1
Primary Contact This is the name of the main contact.
PTH-PHONE-PREFIX Alpha 6 PO31.1
Telephone Country The telephone number country code.
Code
PTH-PHONE-NUM Alpha 15 PO31.1
Telephone Number This is the main telephone number.
PTH-PHONE-EXT Alpha 5 PO31.1
Telephone Extension This field contains the telephone
extension number.
PTH-DROPSHIP-FL Alpha 1 PO31.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) PO31.1
Ship To Name This is the ship-to name for a
non-standard ship-to address.
PTH-SH-ADDR1 Alpha 30 (Lower Case) PO31.1
Ship To Address This is the ship-to address line one.
Line 1
PTH-SH-ADDR2 Alpha 30 (Lower Case) PO31.1
Ship To Address This is the ship-to address line two.
Line 2
PTH-SH-ADDR3 Alpha 30 (Lower Case) PO31.1
Ship To Address This is the ship-to address line three.
Line 3
PTH-SH-ADDR4 Alpha 30 (Lower Case) PO31.1
Ship To Address This is the ship-to address line four.
Line 4
PTH-SH-CITY-ADDR5 Alpha 18 (Lower Case) PO31.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 PO31.1
Ship To State or This is the ship-to state or the
Province ship-to province.
PTH-SH-POST-CODE Alpha 10 (Lower Case) PO31.1
Ship To Postal Code This is the ship-to mail code.
PTH-SH-COUNTRY Alpha 30 (Lower Case) PO31.1
Ship To Country This is the ship-to country.
PTH-ORIG-FRT-CR-AM Signed 15.2 PO31.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 PO31.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 PO31.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 PO31.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 PO31.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 PO31.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 PO31.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 PO31.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 PO31.1
Handling Amount This is the amount the vendor will
charge for handling against the return.
PTH-HANDLING-AU Alpha 15 PO31.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 PO31.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 PO31.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 PO31.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 PO31.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-VENDOR-ACT Alpha 1 PO31.1
Vendor Action This indicates the action the vendor
will perform to handle the return. This
field is required to perform the
authorization form action. The vendor
will either replace the return goods or
issue a credit memo. The credit memo may
be created immediately when the return
is shipped, or may be issued by the
vendor.
C = Credit Memo
R = Replacement
PTH-VEND-INV-METH Alpha 1 PO31.1
Vendor Invoicing For replacement returns, this field
Method indicates whether the vendor will ship
the items no charge, or credit the
return items and invoice for the
replacement items.
C = Credit and Rebill
N = No Charge
PTH-VEND-SHIP-REQ Alpha 1 PO31.1
Vendor Shipping This field indicates if the return
Requirement goods need to be shipped to the vendor.
S = Ship
H = Hold
PTH-CREATE-DM-FL Alpha 1 PO31.1
Create Credit Memo This field indicates if a debit memo
Flag (credit memo) will automatically be
created when the return goods are
shipped.
N = No
Y = Yes
PTH-RET-PO-NUMBER Alpha 7 PO31.1
Ret Po Number This is the purchase order number
attached to the return purchase order
created to replace return goods.
PTH-PROCESS-LEVEL Alpha 5 PO31.1
Process Level This field indicates the process level
to be used if a debit memo is created.
PTH-IVEND-SHIP-VIA Alpha 12 PO31.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) PO31.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 PO31.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 PO31.1
Carrier Vendor This is the carrier vendor number. It
Number must be a valid vendor.
PTH-OVEND-SHP-DATE Numeric 8 (yyyymmdd) PO31.1
Return To Vendor This is the date the return goods were
Ship Date shipped to the vendor.
PTH-OVEND-BOL Alpha 10 PO31.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 PO31.1
Returned By This is the user ID of the person
returning the goods to the vendor.
PTH-RETURN-VALUE Signed 15.2 PO31.1
Return Value This field indicates the value of the
return, including freight credit and
handling charges.
PTH-CREDIT-RECVD Signed 15.2 AP25.1 AP25.2
Credit Amount This field shows the amount of credit AP30.4 OE10.1
Received that has been received against the OE10.2 OE10.3
return. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
PO20.1 PO21.6
PO22.2 PO22.3
PO30.1 PO31.1
PO33.1 WH20.2
WH20.7
PTH-CREDIT-CL-FL Alpha 1 AP125 AP126
Credit Close Flag For returns where credit is expected, AP225 AP226
this field indicates if credit has been AP25.1 AP25.2
received in an amount equal to or AP26.1 AP30.4
greater than the value of the return. BL92.1 MA190
N = No MA530 MA540
Y = Yes 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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO20.1
PO21.6 PO22.2
PO22.3 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PTH-REPL-CL-FL Alpha 1 AP125 AP126
Replacement Close For return where replacement goods are AP225 AP226
Flag expected, this field indicates if all AP25.1 AP25.2
replacement goods have been fully AP26.1 AP30.4
received. BL92.1 MA190
N = No MA530 MA540
Y = Yes 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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO20.1
PO21.6 PO22.2
PO22.3 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PTH-LAST-LINE-NBR Numeric 6 PO31.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-LAST-COMM-SEQ Numeric 3 PO31.1 PO32.4
Last Comment This is the sequence number of the last PO32.5
Sequence Number comment line entered for this return.
PTH-CANCEL-OPTIONS Alpha 1 PO31.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.
B = Both Return and Repl PO
P = Replacement PO Only
R = Return Only
PTH-CANCEL-USERID Alpha 10 PO31.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) AP125 AP126
Close Date This is the date the return was closed. AP225 AP226
AP25.1 AP25.2
AP26.1 AP30.4
BL92.1 MA190
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO20.1
PO21.6 PO22.2
PO22.3 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PTH-STATUS Numeric 1 AP125 AP126
Status This is the status of the return. AP225 AP226
0 = Added AP25.1 AP25.2
1 = Authorized By Vendor AP26.1 AP30.4
2 = Waiting For Vendor Action BL92.1 MA190
9 = Closed MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO20.1
PO21.6 PO22.2
PO22.3 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PORETURNHD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTHSET1 COMPANY AP125 AP126
RETURN-NUMBER* AP225 AP226
AP25.1 AP25.2
AP26.1 AP30.4
BL92.1 MA00.3
MA190 MA300
MA40.1 MA530
MA540 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
OE113 OE114
...
PTHSET2 COMPANY PO231
VENDOR
CREATION-DATE*
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
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
Comments POCOMMENTS
PTH-COMPANY -> POC-COMPANY
PTH-RETURN-NUMBER -> POC-RETURN-NUMBER
POC-LINE-NBR
POC-SEQ
Hdcomments POCOMMENTS Delete Cascades
Valid When PTH- = PTH-
PTH-COMPANY -> POC-COMPANY
Spaces -> POC-ORDER-NAME
PTH-RETURN-NUMBER -> POC-RETURN-NUMBER
Spaces -> POC-PO-NUMBER
Zeroes -> POC-PO-RELEASE
Zeroes -> POC-LINE-NBR
POC-SEQ
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
PLI-LINE-NBR
Returnline PORETURNLN Delete Cascades
PTH-COMPANY -> PTL-COMPANY
PTH-RETURN-NUMBER -> PTL-RETURN-NUMBER
PTL-RET-LINE-NBR
|