Retail Integration Mappings Report Release:15.0.0

(Retail Merchandising System)

Application Retail Merchandising System Target Name Space http://www.oracle.com/retail/integration/base/bo/LocPOTsfItmSlsCriVo/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure LocPOTsfItmSlsCriVo

XML-Schema Name:LocPOTsfItmSlsCriVo 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 LocPOTsfItmSlsCriVo in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description item varchar225 1 1 Description is not available. item_loc_hist item varchar2 25 Yes Unique alphanumeric value that identifies the item for which sales information is to be retrieved loc number10 1 1 Description is not available. item_loc_hist loc number 10 Yes Number of the location in which the item is to be found. This field may contain a store or a warehouse. loc_type varchar21 1 1 Description is not available. item_loc_hist loc_type varchar2 1 Yes Type of location in the loc field. Valid values are S = Store and W = Warehouse.