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/StoreRef/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:StoreRef 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 StoreRef 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
store number10 1 1 The store number for the store or address being deleted. store store number 10 Yes The store number for the store or address being deleted.
store_type varchar21 0 1 Indicates the store type of the store. Valid values are: 'C' = company store, 'F' = franchise store. store store_type varchar2 6 Yes Indicates the store type of the store. Valid values are 'C' = company store, 'F' = franchise store.
stockholding_ind varchar21 0 1 Indicates if the store is stockholding or not. Valid values are: 'Y' = yes, 'N' = no. store stockholding_ind varchar2 'Y' = yes, 'N' = no. Yes Indicates if the store is stockholding or not. Valid values are
AddrRef:AddrRef * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:AddrRef 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 AddrRef 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
addr varchar232 1 1 The unique identifier of the address being deleted. For address delete messages that are interfaced into RMS, it will hold the external store system's address ID. For address delete messages published out of RMS, it will hold RMS's address ID. addr external_ref_id varchar2 32 Yes The unique identifier of the address being deleted. For address delete messages that are interfaced into RMS, it will hold the external store system's address ID. For address delete messages published out of RMS, it will hold RMS's address ID.