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/RTVDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:RTVDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For RTVDesc
Table Name Column Name API Type Column Length API Required API Description
dc_dest_id varchar210 1 1 Contains the location number that the items are returned from. If the dc_dest_id is a store, the STORE column gets populated with the dc_dest_id value, and the WH column is defaulted to -1. If the dc_dest_id is a warehouse, the WH column gets populated. TBD TBD * * Not Yet Available Not Yet Available
rtv_id varchar214 1 1 Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. TBD TBD * * Not Yet Available Not Yet Available
item_id varchar225 0 1 Unique identifier for the item on the RTV. null null null null null
rtn_auth_nbr varchar212 1 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. TBD TBD null null Yes Not Yet Available
unit_qty number12_4 0 1 Contains the quantiy of items being returned to the supplier under this RTV number. null null null null null
container_qty number6 0 1 Not used by RMS. null null null null null
vendor_nbr varchar210 1 1 Contains the supplier ID to which the merchandise is being returned. null null null null null
ship_address1 varchar2240 0 1 Contains the first line of the supplier's address for returns. TBD TBD * * Not Yet Available Not Yet Available
ship_address2 varchar2240 0 1 Contains the second line of the supplier's address for returns. TBD TBD * * Not Yet Available Not Yet Available
ship_address3 varchar2240 0 1 Contains the third line of the supplier's address for returns. null varchar2 240 null null
state varchar23 0 1 Contains the state of the supplier's address for returns. TBD TBD * * Not Yet Available Not Yet Available
city varchar2120 0 1 Contains the city name of the supplier's address for returns. TBD TBD * * Not Yet Available Not Yet Available
shipto_zip varchar230 0 1 Contains the zip code of the supplier's address for returns. TBD TBD * * Not Yet Available Not Yet Available
country varchar23 0 1 Contains the country ID of the supplier's address for returns. TBD TBD * * Not Yet Available Not Yet Available
from_disposition varchar24 0 1 This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table. null varchar2 4 null null
to_disposition varchar24 0 1 Not used by RMS. null null null null null
creation_ts xs:dateTime 0 1 CREATED_DATE contains the date the vendor return was created, COMPLETED_DATE contains the date the vendor return was completed. TBD TBD null null Not Yet Available Not Yet Available
unit_cost number20_4 0 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 0 1 Contains the value identifying the reason for the return. Valid values are: Q - QC Failed, U - Unavailable Inventory. Other values may also be entered via the codes table under code type 'RTVR', however, the two codes listed previously may never be deleted. Note that any value added can only be related to RTV from existing inventory (e.g. overstock). null null null null null
comments varchar22000 0 1 Contains any comments associated with the return. TBD TBD * * Not Yet Available Not Yet Available
rtv_order_no number10 0 1 Contains the number that uniquely identifies the return to vendor within the system. null number 10 null null
weight number12_4 0 1 Actual weight shipped for the item on the RTV. null null null null null
weight_uom varchar24 0 1 Unit of Measure for the weight (e.g. pounds, kilograms). null null null null null
RTVDtl * 0 unbounded Description is not available.
status_ind varchar21 0 1 Description is not available. NA NA NA NA NA NA
ExtOfRTVDesc:ExtOfRTVDesc * 0 1 Provide an extension hook to customize RTVDesc. NA NA NA NA NA NA

XML-Schema Name:RTVDtl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For RTVDtl
Table Name Column Name API Type Column Length API Required API Description
item_id varchar225 1 1 Unique identifier for the item on the RTV. TBD TBD * * Not Yet Available Not Yet Available
unit_qty number12_4 0 1 Contains the quantiy of items being returned to the supplier under this RTV number. TBD TBD * * Not Yet Available Not Yet Available
container_qty number6 0 1 Not used by RMS. null null null null null
from_disposition varchar24 0 1 This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table. TBD TBD * * Not Yet Available Not Yet Available
to_disposition varchar24 0 1 Not used by RMS. null null null null null
unit_cost number20_4 0 1 Contains the cost per unit for the SKU being returned. This field is stored in the supplier's currency. null null null null null
reason varchar26 0 1 Contains the value identifying the reason for the return. Valid values are: Q - QC Failed, U - Unavailable Inventory. Other values may also be entered via the codes table under code type 'RTVR', however, the two codes listed previously may never be deleted. Note that any value added can only be related to RTV from existing inventory (e.g. overstock). TBD TBD * * Not Yet Available Not Yet Available
weight number12_4 0 1 Actual weight shipped for the item on the RTV. null null null null null
weight_uom varchar24 0 1 Unit of Measure for the weight (e.g. pounds, kilograms). null null null null null
ExtOfRTVDesc:ExtOfRTVDtl * 0 1 Provide an extension hook to customize RTVDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfRTVDtl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfRTVDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfRTVDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfRTVDesc
Table Name Column Name API Type Column Length API Required API Description