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/ItemLocRef/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:ItemLocRef 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 ItemLocRef 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 Unique identifier for the item. item_loc item varchar2 25 Yes Unique identifier for the item.
ItemLocPhysRef * 1 unbounded Description is not available.

XML-Schema Name:ItemLocPhysRef 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 ItemLocPhysRef 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
physical_loc number10 1 1 Identifier of the physical location where the item is located. Fill application table name. Fill table column name. number 10 Yes Identifier of the physical location where the item is located.
loc_type varchar21 0 1 Type of location in the physical_loc field. Valid values are: S = Store, W = Warehouse, E = external finisher. item_loc loc_type varchar2 1 Yes Type of location in the location field. Valid values are S (store), W (warehouse), and E (external finisher).
store_type varchar21 0 1 Indicates the store type of the physical_loc store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. store store_type varchar2 6 Yes This will indicate whether a particular store is a franchise or company store.
stockholding_ind varchar21 0 1 Indicates if the physical_loc store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. store, wh stockholding_ind varchar2 1 Yes This column indicates whether the store can hold stock. In a non-multichannel environment this will always be Y. This column will indicate if the warehouse is a stock holding location. In a non-multichannel environment, this will always be Y. In a multichannel environment it will be N for a physical warehouse and Y for a virtual warehouse.
ItemLocVirtRef * 1 unbounded Description is not available.

XML-Schema Name:ItemLocVirtRef 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 ItemLocVirtRef 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
loc number10 1 1 Numeric identifier of the location in which the item is to be found. This field may contain a store, warehouse, or external finisher. item_loc loc number10 10 Yes Numeric identifier of the location in which the item is to be found. This field may contain a store, warehouse, or external finisher.