Retail Integration Bus Mappings Report Release:13.2.0

(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 LocOfCustRetItemQtyDtl ExtOfCustRetItemQty LocOfCustRetItemQty ExtOfCustRetItem LocOfCustRetItem ExtOfCustRetDesc LocOfCustRetDesc

XML-Schema Name:CustRetDesc Version:13.2.0 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 LocOfCustRetDesc:LocOfCustRetDesc * 0 1 Provide an extension hook to localize CustRetDesc. NA NA NA NA NA NA

XML-Schema Name:CustRetItem Version:13.2.0 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 LocOfCustRetDesc:LocOfCustRetItem * 0 1 Provide an extension hook to localize CustRetItem. NA NA NA NA NA NA

XML-Schema Name:CustRetItemQty Version:13.2.0 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 LocOfCustRetDesc:LocOfCustRetItemQty * 0 1 Provide an extension hook to localize CustRetItemQty. NA NA NA NA NA NA

XML-Schema Name:CustRetItemQtyDtl Version:13.2.0 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 LocOfCustRetDesc:LocOfCustRetItemQtyDtl * 0 1 Provide an extension hook to localize CustRetItemQtyDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfCustRetItemQtyDtl Version:13.2.0 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:LocOfCustRetItemQtyDtl Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfCustRetItemQtyDtl Table Name Column Name API Type Column Length API Required API Description InCustRetDesc:InCustRetItemQtyDtl * 0 unbounded India Localization. NA NA NA NA NA NA BrCustRetDesc:BrCustRetItemQtyDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfCustRetItemQty Version:13.2.0 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:LocOfCustRetItemQty Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfCustRetItemQty Table Name Column Name API Type Column Length API Required API Description InCustRetDesc:InCustRetItemQty * 0 unbounded India Localization. NA NA NA NA NA NA BrCustRetDesc:BrCustRetItemQty * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfCustRetItem Version:13.2.0 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:LocOfCustRetItem Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfCustRetItem Table Name Column Name API Type Column Length API Required API Description InCustRetDesc:InCustRetItem * 0 unbounded India Localization. NA NA NA NA NA NA BrCustRetDesc:BrCustRetItem * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfCustRetDesc Version:13.2.0 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

XML-Schema Name:LocOfCustRetDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfCustRetDesc Table Name Column Name API Type Column Length API Required API Description InCustRetDesc:InCustRetDesc * 0 unbounded India Localization. NA NA NA NA NA NA BrCustRetDesc:BrCustRetDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA