Retail Integration Bus Mappings Report Release:13.2.0 (Store Inventory Management)
Application Store Inventory Management
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 sim 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. RETURN EXTERNAL_ID NUMBER 12,0 No Contains the number that uniquely identifies the return to vendor within the system.
supplier varchar210 1 1 Description is not available. RETURN SOURCE_ID VARCHAR2 128 No Unique identifier of the supplier
status_ind number2 1 1 Contains the current status of the return. Valid values include: 05- Input, 10 - Approved, 15 - Shipped, 20 - Cancelled. RETURN STATUS NUMBER 2,0 null 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. RETURN STORE_ID NUMBER 10,0 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. null Not used in SIM
physical_loc number10 1 1 Contains the store number or the physical warehouse where the items are being returned. null Not used in SIM.
total_order_amt number20_4 0 1 Contains the total amount of the return. This field is stored in the supplier's currency. null Not used in SIM.
ship_to_addr_line1 varchar2240 1 1 Description is not available. null Not used in SIM.
ship_to_addr_line2 varchar2240 0 1 Description is not available. null Not used in SIM.
ship_to_addr_line3 varchar2240 0 1 Description is not available. null Not used in SIM.
ship_to_city varchar2120 1 1 Description is not available. null Not used in SIM.
state varchar23 0 1 Description is not available. null Not used in SIM.
ship_to_country_code varchar23 1 1 Description is not available. null Not used in SIM.
ship_to_postal_code varchar230 0 1 Description is not available. null Not used in SIM.
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. RETURN AUTHORIZATION_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. null Not used in SIM.
freight_charge number20_4 0 1 Contains the freight cost associated with the vendor return. This field is stored in the supplier's currency. null Not used in SIM.
creation_date xs:dateTime 1 1 Description is not available. RETURN CREATE_DATE Date No This indicates the stores specific create date of the RTV request
completed_date xs:dateTime 0 1 Description is not available. null Not used in SIM.
handling_pct number12_4 0 1 Contains the handling (restocking) percent if a percent is specified at a vendor level. null Not used in SIM.
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. null Not used in SIM.
ext_ref_no varchar214 0 1 Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. null Not used in SIM.
comment_desc varchar22000 0 1 Description is not available. RETURN COMMENTS VARCHAR2 2000 No Comments
RTVReqDtl * 0 unbounded Description is not available.
not_after_date xs:dateTime 0 1 Description is not available. RETURN NOT_AFTER_DATE Date No This indicates the store specific date after which return is not allowed.
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 sim 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. RETURN_LINE_ITEM EXTERNAL_ID NUMBER 12,0 No 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. RETURN_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Unique identifier of 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. null Not used in SIM
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. null Not used in SIM.
rtv_qty number12_4 1 1 Contains the quantity of items requested to be returned to the supplier under this RTV number. RETURN_LINE_ITEM REQUESTED_QUANTITY NUMBER 20,4 No 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. null Not used in SIM
reason varchar26 1 1 Contains the value identifying the reason for the return. Valid values are: Q - QC Failed, U - Unavailable Inventory. RETURN_LINE_ITEM REASON_ID VARCHAR2 6 No 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 sim 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 sim 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 sim 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 sim 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