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

XML-Schema Name:PendRtrnDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For PendRtrnDesc
Table Name Column Name API Type Column Length API Required API Description
physical_wh number10 1 1 Description is not available. transshipment_setup dc_dest_id number 10 Yes *
return_order_number varchar218 1 1 This type can hold a number of digits count _order_number. pending_returns pro_nbr varchar2 18 Yes *
rma_nbr varchar220 1 1 Description is not available. pending_returns rma_nbr varchar2 20 Yes *
creation_date xs:dateTime 1 1 Description is not available. pending_returns expected_receipt RIBDate * Yes *
PendRtrnDtlDesc * 1 unbounded Description is not available.
ExtOfPendRtrnDesc:ExtOfPendRtrnDesc * 0 1 Provide an extension hook to customize PendRtrnDesc. NA NA NA NA NA NA
LocOfPendRtrnDesc:LocOfPendRtrnDesc * 0 1 Provide an extension hook to localize PendRtrnDesc. NA NA NA NA NA NA

XML-Schema Name:PendRtrnDtlDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For PendRtrnDtlDesc
Table Name Column Name API Type Column Length API Required API Description
return_order_number varchar218 1 1 This type can hold a number of digits count _order_number. pending_returns_detail pro_nbr varchar2 18 Yes *
physical_wh number10 1 1 Description is not available. * * number 10 * *
rma_nbr varchar220 1 1 Description is not available. pending_returns_detail rma_nbr varchar2 20 Yes *
item varchar225 1 1 Description is not available. pending_returns_detail item_id varchar2 25 Yes *
ordered_quantity number12_4 1 1 Description is not available. pending_returns_detail unit_qty number 12 Yes *
return_type varchar21 1 1 Description is not available. NA NA NA NA NA NA
ExtOfPendRtrnDesc:ExtOfPendRtrnDtlDesc * 0 1 Provide an extension hook to customize PendRtrnDtlDesc. NA NA NA NA NA NA
LocOfPendRtrnDesc:LocOfPendRtrnDtlDesc * 0 1 Provide an extension hook to localize PendRtrnDtlDesc. NA NA NA NA NA NA

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

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

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

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