Oracle Portal
 Retail Integration Bus Mappings Report    

Application Name: Retail Merchandising System
XML-Schema or Node Name:RTVReqDesc.xsd
Tag Name Table Name Column Name API Req Description
rtv_order_no rtv_head rtv_order_no Yes Contains the number that uniquely identifies the return to vendor within the system.
supplier rtv_head supplier Yes Contains the supplier number to which the merchandise is being returned.
status_ind rtv_head status_ind Yes Contains the current status of the return. Valid values include: 05- Input, 10 - Approved, 15 - Shipped, 20 - Cancelled.
loc rtv_head store, wh Yes Contains either the store or warehouse number for the items being returned.
loc_type n/a n/a Yes Indicates the location type. Contains an 'S' if the location is a store or 'W' if the location is a warehouse.
physical_loc rtv_head, wh store, physical_wh Yes Contains the store number or the physical warehouse where the items are being returned.
total_order_amt rtv_head total_order_amt No Contains the total amount of the return. This field is stored in the supplier's currency.
ship_to_addr_line1 rtv_head ship_to_add_1 Yes Contains the first line of the supplier's address for returns.
ship_to_addr_line2 rtv_head ship_to_add_2 No Contains the second line of the supplier's address for returns.
ship_to_addr_line3 rtv_head ship_to_add_3 No Contains the third line of the supplier's address for returns.
ship_to_city rtv_head ship_to_city Yes Contains the city name of the supplier's address for returns.
state rtv_head state Yes Contains the state of the supplier's address for returns.
ship_to_country_code rtv_head ship_to_country_id Yes Contains the country ID of the supplier's address for returns.
ship_to_postal_code rtv_head ship_to_pcode No Contains the zip code of the supplier's address for returns.
ret_auth_nbr rtv_head ret_auth_num No Contains the number that the supplier provides when the decision is made that an order may be returned. This value is not always required and is determined by vendor level data.
ret_courier rtv_head courier No Contains the courier name if the supplier requires that returns be sent by a designated carrier.
freight_charge rtv_head freight No Contains the freight cost associated with the vendor return. This field is stored in the supplier's currency.
creation_date rtv_head created_date Yes Contains the date the vendor return was created.
completed_date rtv_head completed_date No Contains the date the vendor return was completed.
handling_pct rtv_head restock_pct No Contains the handling (restocking) percent if a percent is specified at a vendor level.
handling_cost rtv_head restock_cost Yes Contains the handling (restocking) cost for the vendor return if a handling (restocking) percent is specified at a supplier level. The cost is calculated by taking the total order amount multiplied by the handling (restocking) percent. This field is stored in the supplier's currency.
ext_ref_no rtv_head ext_ref_no No Audit trail reference to external system when an external transaction initiates master record creation in the Retek system.
comment_desc rtv_head comment_desc No Contains any comments associated with the return.
RTVReqDtl * * * *
not_after_date rtv_head not_after_date No Contains the last date that delivery of the order will be accepted.

Application Name: Retail Merchandising System
XML-Schema or Node Name:RTVReqDtl
Tag Name Table Name Column Name API Req Description
seq_no rtv_detail seq_no Yes This field will contain a sequence number which makes the record unique when combined with the RTV_ORDER_NO field.
item rtv_detail item Yes Unique identifier for the item.
shipment rtv_detail shipment Yes Contains the shipment number associated with all vendor returns originating from the Quality Control process. This field will contain a -1 for all returns originating from held inventory.
inv_status rtv_detail inv_status No This field contains the number representing the inventory status code. This field is only required if the reason field has a value of 'U' for unavailable inventory.
rtv_qty rtv_detail qty_requested Yes Contains the quantity of items requested to be returned to the supplier under this RTV number.
unit_cost rtv_detail unit_cost Yes Contains the cost per unit for the SKU being returned. This field is stored in the supplier's currency.
reason rtv_detail reason Yes Contains the value identifying the reason for the return. Valid values are: Q - QC Failed, U - Unavailable Inventory.