Retail Integration Mappings Report Release:15.0.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.
XSD Structure

XML-Schema Name:PendRtrnDesc 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 PendRtrnDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
physical_wh number10 1 1 Physical warehouse dest id. transshipment_setup dc_dest_id varchar2 10 Yes *
rma_nbr varchar220 0 1 Specifies the RMA nbr for electronic returns. Null for Non electronic returns. pending_returns - returns_upload rma_nbr varchar2 20 Yes Return Merchandise Authorization number. This is a system generated number that is placed on every container that is shipped.
cust_order_nbr varchar248 0 1 Specifies the cust_order_nbr non electronic returns. Null for electronic returns. Pending_Returns - Returns_upload cust_order_nbr varchar2 48 No The customer_order_nbr for subscriber and publisher- This can be NULL.
special_instructions varchar2250 0 1 Specifies special instructions for returned inventory. Pending_Returns special_instructions varchar2 1000 No Additional information for performing the returns Not used in Publisher message.
expected_receipt xs:dateTime 0 1 Specifies the expecetd receipt date Pending_Returns EXPECTED_RECEIPT RIBDate Date Yes Date that an item is projected to be received as a return into the DC Not used in publisher message.
PendRtrnDtlDesc * 1 unbounded Placeholder for Pending_return item level details.

XML-Schema Name:PendRtrnDtlDesc 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 PendRtrnDtlDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item_id varchar225 1 1 Specifies the returned item_id pending_returns_detail - returns_upload item_id varchar2 25 Yes Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc.
line_item_nbr number3 1 1 Specifies the line_nbr of the return used to identify unique return details. pending_returns_detail LINE_ITEM_NO number 8 Yes This no. specifies unique line item no. for a record on the return detail in order to differentiate between two same SKUs on an RMA/customer_ordr being returned with different reason code(s)
expected_unit_qty number12 0 1 Specifies the expected quantity of the returned line_item_nbr pending_returns_detail expected_unit_qty number 12 Yes Number of individual units expected. Not used in RWMS Publisher
PendRtrnDtlRsnCodeDesc * 0 unbounded Placeholder for reason_code details.
PendRtrnDtlActCodeDesc * 0 unbounded Placeholder for action_code details

XML-Schema Name:PendRtrnDtlRsnCodeDesc 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 PendRtrnDtlRsnCodeDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
reason_code varchar26 0 1 Specifies the reason_code ret_line_item_reason_codes reason_code varchar2 24 Yes Specifies the reason_code
description varchar2250 0 1 Specifies the reason_code description ret_line_item_reason_codes description varchar2 250 No Specifies the reason_code description

XML-Schema Name:PendRtrnDtlActCodeDesc 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 PendRtrnDtlActCodeDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
action_code varchar26 0 1 Specifies the action_code assigned during processing of the return. returns_upload action_code RIB or/and RSB or/and RSL 6 No Not used in RWMS in Subscribe message
unit_qty number12 0 1 Specifies the item quantity processed for return returns_upload unit_qty Number 12 No Number of individual units Not used in RWMS in Subscribe message
disposition_code varchar26 0 1 Specifies the dispositionassigned during processing of the return. returns_upload disposition VARCHAR2 6 No Not used in RWMS subscribe message
sellable varchar21 0 1 Specifies if an item is sellable or not. returns_upload saleable Varchar2 1 No If Y, then merchandise can be returned to inventory. If N, then merchandise cannot be returned to inventory (i.e. beyond repair, etc.) Not used in RWMS in Subscribe message
comments varchar21000 0 1 Comments returns_upload comments varchar2 1000 Yes Additional supplier comments. Not used in RWMS in Subscriber message