Retail Integration Bus Mappings Report Release:13.1

(Retail Warehouse Management System)

Application Retail Warehouse Management System Target Name Space http://www.oracle.com/retail/integration/base/bo/CustRetDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. CustRetDesc CustRetItem CustRetItemQty CustRetItemQtyDtl ExtOfCustRetItemQtyDtl ExtOfCustRetItemQty ExtOfCustRetItem ExtOfCustRetDesc

XML-Schema Name:CustRetDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For CustRetDesc Table Name Column Name API Type Column Length API Required API Description from_location number10 1 1 Description is not available. transshipment_setup dc_dest_id varchar2 10 Yes * rma_nbr varchar220 1 1 Description is not available. returns_upload rma_nbr varchar2 20 Yes * pro_nbr varchar218 1 1 Description is not available. returns_upload pro_nbr varchar2 18 Yes * comments varchar2250 0 1 Description is not available. returns_upload comments varchar2 300 Yes * CustRetItem * 1 unbounded Description is not available. return_date xs:dateTime 0 1 Description is not available. * * RIBDate * * * ExtOfCustRetDesc:ExtOfCustRetDesc * 0 1 Provide an extension hook to customize CustRetDesc. NA NA NA NA NA NA

XML-Schema Name:CustRetItem Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For CustRetItem Table Name Column Name API Type Column Length API Required API Description item_id varchar225 1 1 Description is not available. returns_upload item_id varchar2 25 Yes * CustRetItemQty * 1 unbounded Description is not available. ExtOfCustRetDesc:ExtOfCustRetItem * 0 1 Provide an extension hook to customize CustRetItem. NA NA NA NA NA NA

XML-Schema Name:CustRetItemQty Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For CustRetItemQty Table Name Column Name API Type Column Length API Required API Description unit_qty number12_4 1 1 Description is not available. returns_upload unit_qty number 12 Yes * from_wip varchar26 0 1 Description is not available. returns_upload from_wip_code varchar2 6 Yes * to_wip varchar26 0 1 Description is not available. returns_upload to_wip_code varchar2 6 Yes * from_disposition varchar24 0 1 Description is not available. returns_upload from_disposition varchar2 4 Yes * to_disposition varchar24 0 1 Description is not available. returns_upload to_disposition varchar2 4 Yes * saleable varchar21 0 1 Description is not available. returns_upload saleable varchar2 1 Yes * CustRetItemQtyDtl * 0 unbounded Description is not available. ExtOfCustRetDesc:ExtOfCustRetItemQty * 0 1 Provide an extension hook to customize CustRetItemQty. NA NA NA NA NA NA

XML-Schema Name:CustRetItemQtyDtl Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For CustRetItemQtyDtl Table Name Column Name API Type Column Length API Required API Description unit_qty number12_4 1 1 Description is not available. returns_upload unit_qty number 12 Yes * reason_code varchar26 0 1 Description is not available. returns_upload reason_code varchar2 6 Yes * action_code varchar26 0 1 Description is not available. returns_upload action_code varchar2 6 Yes * replacement_item varchar225 0 1 Description is not available. returns_upload replacement_item varchar2 25 Yes * replace_unit_qty number12_4 0 1 Description is not available. returns_upload replace_unit_qty number 12 Yes * ExtOfCustRetDesc:ExtOfCustRetItemQtyDtl * 0 1 Provide an extension hook to customize CustRetItemQtyDtl. NA NA NA NA NA NA

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

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

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

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