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/LocPOTsfItmSlsColDesc/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:LocPOTsfItmSlsColDesc 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 LocPOTsfItmSlsColDesc 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
collection_size number4 1 1 Number of items in the collection. Fill application table name. Fill table column name. number 4 Yes Fill this description.
LocPOTsfItmSlsDesc:LocPOTsfItmSlsDesc * 0 unbounded Description is not available. NA NA NA NA NA NA

XML-Schema Name:LocPOTsfItmSlsDesc 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 LocPOTsfItmSlsDesc 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
eow_date xs:dateTime 1 1 Description is not available. item_loc_hist eow_date date Fill column length. Yes This field contains the end of the week date of the week for the sales total and other calculations.
quantity number12_4 1 1 Description is not available. item_loc_hist sales_issues number (12,4) Yes This field contains the total number of units sold or transferred for item/location/date/sales_type combination depending on if the location type is store or warehouse, respectively.
sales_value number20_4 1 1 Description is not available. item_loc_hist value number (20,4) Yes This field contains the retail value of the sales for the item/location/week/sales type combination. This field is stored in the local currency. This field will only hold a value for stores.
sales_type varchar21 1 1 Description is not available. item_loc_hist sales_type varchar2 1 Yes This field indicates the type of sale or inventory movement.