Retail Integration Bus Mappings Report Release:13.1.1

(Retail Merchandising System)

Application	Retail Merchandising 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.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.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