Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing System
Target Name Space http://www.oracle.com/retail/integration/base/bo/CustRetSaleDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:CustRetSaleDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For CustRetSaleDesc
Table Name Column Name API Type Column Length API Required API Description
store number10 1 1 The contains the non-stockholding location ID in which the item is being returned. This field may contain a store or a warehouse. item_loc_soh loc null null Yes This field contains the non-stockholding location ID for the location at which the item is being returned. This field may indicate a store or a warehouse.
item varchar225 1 1 Unique alphanumeric value that identifies the item. string item_loc_soh xs item Unique alphanumeric value that identifies the item.
shipped_quantity number12_4 1 1 This holds the number of units that was returned. item_loc_soh stock_on_hand null null Yes This field contains the number of units returned.
wh number10 0 1 This contains the stockholding location to which the item is to be returned. item_loc_soh loc null null Yes This field contains the stockholding location to which the item is to be returned.
ExtOfCustRetSaleDesc:ExtOfCustRetSaleDesc * 0 1 Provide an extension hook to customize CustRetSaleDesc. NA NA NA NA NA NA
LocOfCustRetSaleDesc:LocOfCustRetSaleDesc * 0 1 Provide an extension hook to localize CustRetSaleDesc. NA NA NA NA NA NA

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

XML-Schema Name:LocOfCustRetSaleDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfCustRetSaleDesc
Table Name Column Name API Type Column Length API Required API Description
InCustRetSaleDesc:InCustRetSaleDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrCustRetSaleDesc:BrCustRetSaleDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA