Retail Integration Mappings Report Release:15.0.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.
XSD Structure

XML-Schema Name:RTVReqDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RTVReqDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
rtv_order_no number12 1 1 Contains the number that uniquely identifies the return to vendor within the system. RTV EXTERNAL_ID VARCHAR2 128 No external identifier. ex. this is external id from rms.
supplier varchar210 1 1 Description is not available. RTV SUPPLIER_ID VARCHAR2 128 No supplier or warehouse reference identifier
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 No the current status of a return. 1 - Pending, 2 - Requested, 3 - Dispatched, 4 - Received, 5 - Active, 6 - Canceled
loc number10 1 1 Contains either the store or warehouse number for the items being returned. RTV 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
physical_loc number10 1 1 Contains the store number or the physical warehouse where the items are being returned. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
ship_to_addr_line1 varchar2240 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
ship_to_addr_line2 varchar2240 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
ship_to_addr_line3 varchar2240 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
ship_to_city varchar2120 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
state varchar23 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
ship_to_country_code varchar23 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
ship_to_postal_code varchar230 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. RTV AUTHORIZATION_NUMBER VARCHAR2 12 No the vendor authorization number for when a number is required when a return being returned to a vendor.
ret_courier varchar2250 0 1 Contains the courier name if the supplier requires that returns be sent by a designated carrier. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
creation_date xs:dateTime 1 1 Description is not available. RTV CREATE_DATE Date Fill column length. No create date of a original return
completed_date xs:dateTime 0 1 Description is not available. RTV CLOSED_DATE RIB or/and RSB or/and RSL DATE null
handling_pct number12_4 0 1 Contains the handling (restocking) percent if a percent is specified at a vendor level. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
comment_desc varchar22000 0 1 Description is not available. NOTES TEXT VARCHAR2 2000 No comment or short description entered by the creator or processor of the return
RTVReqDtl * 0 unbounded Description is not available.
not_after_date xs:dateTime 0 1 Description is not available. RTV NOT_AFTER_DATE DATE Fill column length. No This indicates the store specific date after which return is not allowed.

XML-Schema Name:RTVReqDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RTVReqDtl in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's 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 external identifier
item varchar225 1 1 Description is not available. RTV_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Unique identifier of the item
shipment number12 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. RTV_LINE_ITEM QUANTITY_REQUESTED NUMBER 20,4 No requested quantity
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. RTV_LINE_ITEM SHIPMENT_REASON_ID VARCHAR2 12 Yes Contains the value identifying the reason for the return.