Retail Integration Bus Mappings Report Release:13.1

(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. CustRetSaleDesc ExtOfCustRetSaleDesc

XML-Schema Name:CustRetSaleDesc Version:13.1 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 The contains the non-stockholding location ID in which the item is being returned. This field may contain a store or a warehouse. item varchar225 1 1 Unique alphanumeric value that identifies the item. item_loc_soh item xs:string * Yes 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 holds the number of units that was 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 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

XML-Schema Name:ExtOfCustRetSaleDesc Version:13.1 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