Retail Integration Mappings Report Release:15.0.0 (Integration Gateway Services)
Application Integration Gateway Services
Target Name Space http://www.oracle.com/retail/integration/base/bo/RTVDesc/v1
Version 1.1
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:RTVDesc 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 RTVDesc in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's 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. RMS.rtv_head store, wh varchar2 10 Yes Contains the number of the location number from which the items are returned. If the dc_dest_id is a store, the STORE column is populated with the dc_dest_id value, and the WH column defaults to -1. If the dc_dest_id is a warehouse, the WH column is populated.
rtv_id varchar214 1 1 Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. RMS.rtv_head ext_ref_no varchar2 14 Yes Audit trail reference to an external system when an external transaction initiates master record creation in RMS.
rtn_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. RMS.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.
vendor_nbr varchar210 1 1 Contains the supplier ID to which the merchandise is being returned. RMS.rtv_head supplier varchar2 10 Yes Contains the supplier ID to which the merchandise is being returned.
ship_address1 varchar2240 0 1 Contains the first line of the supplier's address for returns. RMS.rtv_head ship_to_add_1 varchar2 240 No Contains the first line of the supplier's address for returns.
ship_address2 varchar2240 0 1 Contains the second line of the supplier's address for returns. RMS.rtv_head ship_to_add_2 varchar2 240 No Contains the second line of the supplier's address for returns.
ship_address3 varchar2240 0 1 Contains the third line of the supplier's address for returns. RMS.rtv_head ship_to_add_3 varchar2 240 No Contains the third line of the supplier's address for returns.
state varchar23 0 1 Contains the state of the supplier's address for returns. RMS.rtv_head state varchar2 3 No Contains the state of the supplier's address for returns.
city varchar2120 0 1 Contains the city name of the supplier's address for returns. RMS.rtv_head ship_to_city varchar2 120 No Contains the city name of the supplier's address for returns.
shipto_zip varchar230 0 1 Contains the zip code of the supplier's address for returns. RMS.rtv_head ship_to_pcode varchar2 30 No Contains the zip code of the supplier's address for returns.
country varchar23 0 1 Contains the country ID of the supplier's address for returns. RMS.rtv_head ship_to_country_id varchar2 3 No Contains the country ID of the supplier's address for returns.
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. RMS.rtv_head created_date, completed_date date Fill column length. No CREATED_DATE contains the date the vendor return was created, COMPLETED_DATE contains the date the vendor return was completed.
comments varchar22000 0 1 Contains any comments associated with the return. RMS.rtv_head comment_desc varchar2 2000 No Contains comments associated with the return.
rtv_order_no number10 0 1 Contains the number that uniquely identifies the return to vendor within the system. RMS.rtv_head rtv_order_no number 10 No Contains the number to uniquely identify the return to vendor within the system.
RTVDtl * 0 unbounded Description is not available.
status_ind varchar21 0 1 This value is used to determine the current status of the return. If this is 'A', RMS will set the status to 12 (In Progress). If this is 'S' or null, it will be set to 15 (Shipped). RMS.n/a n/a n/a n/a No This value is used to determine the current status of the return. If this is 'A', RMS will set the status to 12 (In Progress). If this is 'S' or null, it will be set to 15 (Shipped).

XML-Schema Name:RTVDtl 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 RTVDtl in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
item_id varchar225 1 1 Unique identifier for the item on the RTV. RMS.rtv_detail item varchar2 25 Yes Unique identifier for the item on the RTV.
unit_qty number12_4 0 1 Contains the quantiy of items being returned to the supplier under this RTV number. RMS.rtv_detail qty_returned number 12 Yes Contains the quantiy of items being returned to the supplier under this RTV number.
container_qty number6 0 1 Not used by RMS. RMS.n/a n/a n/a n/a No Not used by RMS.
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. RMS.inv_status_codes inv_status_code varchar2 10 No This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value in the INV_STATUS_CODES table.
to_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. RMS.n/a n/a n/a n/a No Not used by RMS.
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. RMS.rtv_detail unit_cost number 20 No Contains the cost per unit for the SKU being returned. This field is stored in the supplier's currency.
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). RMS.rtv_detail reason varchar2 6 Yes Contains a value to identify the reason for the return. Valid values are Q (QC failed) and U (unavailable inventory). Other values may also be entered through 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 (such as overstock).
weight number12_4 0 1 Actual weight shipped for the item on the RTV. RMS.n/a n/a n/a n/a No Actual weight shipped for the item on the RTV.
weight_uom varchar24 0 1 Unit of Measure for the weight (e.g. pounds, kilograms). RMS.n/a n/a n/a n/a No Unit of measure for the weight (such as pounds and kilograms).
gross_cost number20_4 0 1 Contains the Unit cost and Expenses incurred on an item in a particular transaction RMS.shipment unit_cost number 20 No Contains the Unit cost and Expenses incurred on an item in a particular transaction. This field is stored in the location's currency.
RTVDtlUin * 0 unbounded Collection of UIN(s) associated to the item.

XML-Schema Name:RTVDtlUin 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 RTVDtlUin in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
uin varchar2128 1 1 Universal Identification Number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
status number4 1 1 Status associated with the UIN. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.