Retail Integration Bus Mappings Report Release:13.1 (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.1 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. DO_CTL_INV ID_ICD NUMBER 128 Yes Not Yet Available
supplier varchar210 1 1 Description is not available. DO_CTL_INV ID_PRTY_TO_ICD VARCHAR2 128 No Not Yet Available
status_ind number2 1 1 Contains the current status of the return. Valid values include: 05- Input, 10 - Approved, 15 - Shipped, 20 - Cancelled. null null null null null
loc number10 1 1 Contains either the store or warehouse number for the items being returned. DO_CTL_INV ID_STR_RT NUMBER 128 No Not Yet Available
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 null null null null
physical_loc number10 1 1 Contains the store number or the physical warehouse where the items are being returned. null null null null null
total_order_amt number20_4 0 1 Contains the total amount of the return. This field is stored in the supplier's currency. null number 20 null null
ship_to_addr_line1 varchar2240 1 1 Description is not available. null varchar2 240 null null
ship_to_addr_line2 varchar2240 0 1 Description is not available. null varchar2 240 null null
ship_to_addr_line3 varchar2240 0 1 Description is not available. null varchar2 240 null null
ship_to_city varchar2120 1 1 Description is not available. null varchar2 120 null null
state varchar23 0 1 Description is not available. null varchar2 3 null null
ship_to_country_code varchar23 1 1 Description is not available. null varchar2 3 null null
ship_to_postal_code varchar230 0 1 Description is not available. null varchar2 30 null null
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. DO_CTL_INV AUTHORIZATION_NUM VARCHAR2 128 No Not Yet Available
ret_courier varchar2250 0 1 Contains the courier name if the supplier requires that returns be sent by a designated carrier. null varchar2 250 null null
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 number 20 null null
creation_date xs:dateTime 1 1 Description is not available. DO_CTL_INV TS_CRT_ICD RIBDate * No Not Yet Available
completed_date xs:dateTime 0 1 Description is not available. null RIBDate * null null
handling_pct number12_4 0 1 Contains the handling (restocking) percent if a percent is specified at a vendor level. null null null null null
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 null null null null
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 varchar2 14 null null
comment_desc varchar22000 0 1 Description is not available. DO_CTL_INV COMMENT_DESC VARCHAR2 300 No Not Yet Available
RTVReqDtl * 0 unbounded Description is not available.
not_after_date xs:dateTime 0 1 Description is not available. DO_CTL_INV NOT_AFTER_DATE RIBDate * No Not Yet Available
ExtOfRTVReqDesc:ExtOfRTVReqDesc * 0 1 Provide an extension hook to customize RTVReqDesc. NA NA NA NA NA NA

XML-Schema Name:RTVReqDtl Version:13.1 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. TBD TBD NUMBER * Not Yet Available Not Yet Available
item varchar225 1 1 Description is not available. TR_LTM_ICD_MR ID_ITM VARCHAR2 128 Yes Not Yet Available
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 number 10 null null
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 null null null null
rtv_qty number12_4 1 1 Contains the quantity of items requested to be returned to the supplier under this RTV number. TR_LTM_ICD_MR QU_UN_SHP NUMBER 20,4 No Not Yet Available
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 number 20 null null
reason varchar26 1 1 Contains the value identifying the reason for the return. Valid values are: Q - QC Failed, U - Unavailable Inventory. TR_LTM_ICD_MR RC_CHN VARCHAR2 20 No Not Yet Available
ExtOfRTVReqDesc:ExtOfRTVReqDtl * 0 1 Provide an extension hook to customize RTVReqDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfRTVReqDtl Version:13.1 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:ExtOfRTVReqDesc Version:13.1 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