Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing System
Target Name Space http://www.oracle.com/retail/integration/base/bo/RTVReqDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:RTVReqDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For RTVReqDesc
Table Name Column Name API Type Column Length API Required API Description
rtv_order_no number10 1 1 Contains the number that uniquely identifies the return to vendor within the system. rtv_head rtv_order_no number 10 Yes Contains the number that uniquely identifies the return to vendor within the system.
supplier varchar210 1 1 Description is not available. rtv_head supplier varchar2 10 Yes Contains the supplier number to which the merchandise is being returned.
status_ind number2 1 1 Contains the current status of the return. Valid values include: 05- Input, 10 - Approved, 15 - Shipped, 20 - Cancelled. rtv_head status_ind null null Yes Contains the current status of the return. Valid values include: 05- Input, 10 - Approved, 15 - Shipped, 20 - Cancelled.
loc number10 1 1 Contains either the store or warehouse number for the items being returned. rtv_head store, wh null null Yes Contains either the store or warehouse number for the items being returned.
loc_type varchar21 1 1 Indicates the location type. Contains an 'S' if the location is a store or 'W' if the location is a warehouse. n/a n/a null null Yes Indicates the location type. Contains an 'S' if the location is a store or 'W' if the location is a warehouse.
physical_loc number10 1 1 Contains the store number or the physical warehouse where the items are being returned. rtv_head, wh store, physical_wh null null Yes Contains the store number or the physical warehouse where the items are being returned.
total_order_amt number20_4 0 1 Contains the total amount of the return. This field is stored in the supplier's currency. rtv_head total_order_amt number 20 No Contains the total amount of the return. This field is stored in the supplier's currency.
ship_to_addr_line1 varchar2240 1 1 Description is not available. rtv_head ship_to_add_1 varchar2 240 Yes Contains the first line of the supplier's address for returns.
ship_to_addr_line2 varchar2240 0 1 Description is not available. rtv_head ship_to_add_2 varchar2 240 No Contains the second line of the supplier's address for returns.
ship_to_addr_line3 varchar2240 0 1 Description is not available. rtv_head ship_to_add_3 varchar2 240 No Contains the third line of the supplier's address for returns.
ship_to_city varchar2120 1 1 Description is not available. rtv_head ship_to_city varchar2 120 Yes Contains the city name of the supplier's address for returns.
state varchar23 0 1 Description is not available. rtv_head state varchar2 3 Yes Contains the state of the supplier's address for returns.
ship_to_country_code varchar23 1 1 Description is not available. rtv_head ship_to_country_id varchar2 3 Yes Contains the country ID of the supplier's address for returns.
ship_to_postal_code varchar230 0 1 Description is not available. rtv_head ship_to_pcode varchar2 30 No Contains the zip code of the supplier's address for returns.
ret_auth_nbr varchar212 0 1 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. rtv_head ret_auth_num varchar2 12 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 varchar2250 0 1 Contains the courier name if the supplier requires that returns be sent by a designated carrier. rtv_head courier varchar2 250 No Contains the courier name if the supplier requires that returns be sent by a designated carrier.
freight_charge number20_4 0 1 Contains the freight cost associated with the vendor return. This field is stored in the supplier's currency. rtv_head freight number 20 No Contains the freight cost associated with the vendor return. This field is stored in the supplier's currency.
creation_date xs:dateTime 1 1 Description is not available. rtv_head created_date RIBDate * Yes Contains the date the vendor return was created.
completed_date xs:dateTime 0 1 Description is not available. rtv_head completed_date RIBDate * No Contains the date the vendor return was completed.
handling_pct number12_4 0 1 Contains the handling (restocking) percent if a percent is specified at a vendor level. rtv_head restock_pct null null No Contains the handling (restocking) percent if a percent is specified at a vendor level.
handling_cost number20_4 1 1 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. rtv_head restock_cost null null 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 varchar214 0 1 Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. rtv_head ext_ref_no varchar2 14 No Audit trail reference to external system when an external transaction initiates master record creation in the Retek system.
comment_desc varchar22000 0 1 Description is not available. rtv_head comment_desc varchar2 2000 No Contains any comments associated with the return.
RTVReqDtl * 0 unbounded Description is not available.
not_after_date xs:dateTime 0 1 Description is not available. rtv_head not_after_date RIBDate * No Contains the last date that delivery of the order will be accepted.
ExtOfRTVReqDesc:ExtOfRTVReqDesc * 0 1 Provide an extension hook to customize RTVReqDesc. NA NA NA NA NA NA
LocOfRTVReqDesc:LocOfRTVReqDesc * 0 1 Provide an extension hook to localize RTVReqDesc. NA NA NA NA NA NA

XML-Schema Name:RTVReqDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For RTVReqDtl
Table Name Column Name API Type Column Length API Required API Description
seq_no number8 1 1 This field will contain a sequence number which makes the record unique when combined with the RTV_ORDER_NO field. rtv_detail seq_no null null Yes This field will contain a sequence number which makes the record unique when combined with the RTV_ORDER_NO field.
item varchar225 1 1 Description is not available. rtv_detail item varchar2 25 Yes Unique identifier for the item.
shipment number10 0 1 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. rtv_detail shipment number 10 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 number2 0 1 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_detail inv_status null null 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 number12_4 1 1 Contains the quantity of items requested to be returned to the supplier under this RTV number. rtv_detail qty_requested null null Yes Contains the quantity of items requested to be returned to the supplier under this RTV number.
unit_cost number20_4 1 1 Contains the cost per unit for the SKU being returned. This field is stored in the supplier's currency. rtv_detail unit_cost number 20 Yes Contains the cost per unit for the SKU being returned. This field is stored in the supplier's currency.
reason varchar26 1 1 Contains the value identifying the reason for the return. Valid values are: Q - QC Failed, U - Unavailable Inventory. rtv_detail reason null null Yes Contains the value identifying the reason for the return. Valid values are: Q - QC Failed, U - Unavailable Inventory.
ExtOfRTVReqDesc:ExtOfRTVReqDtl * 0 1 Provide an extension hook to customize RTVReqDtl. NA NA NA NA NA NA
LocOfRTVReqDesc:LocOfRTVReqDtl * 0 1 Provide an extension hook to localize RTVReqDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfRTVReqDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfRTVReqDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfRTVReqDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfRTVReqDtl
Table Name Column Name API Type Column Length API Required API Description
InRTVReqDesc:InRTVReqDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrRTVReqDesc:BrRTVReqDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfRTVReqDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfRTVReqDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfRTVReqDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfRTVReqDesc
Table Name Column Name API Type Column Length API Required API Description
InRTVReqDesc:InRTVReqDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrRTVReqDesc:BrRTVReqDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA