Retail Integration Mappings Report Release:16.0.030

Application	Store Inventory Management
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	StoreRef AddrRef StoreHoursRef

XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	Mapping for StoreRef in SIM application.
XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	SIM's Table Name	SIM's Column Name	Integration API(RIB or/and RSB or/and BDI)	SIM's Column Length	Is Column Required in SIM's API?	SIM's API Description
store	number10	1	1	The store number for the store or address being deleted.	STORE	ID	NUMBER	10,0	Yes	a unique retailer assigned identifier for a location.
store_type	varchar21	0	1	Indicates the store type of the store. Valid values are: 'C' = company store, 'F' = franchise store.					No	values are STORE_TYPE_COMPANY("C"), STORE_TYPE_FRANCHISE("F"),
stockholding_ind	varchar21	0	1	Indicates if the store is stockholding or not. Valid values are: 'Y' = yes, 'N' = no.					No	values are "Y" or "N"
AddrRef:AddrRef	*	0	unbounded	It's a referenced element. For detailed description, please refer referenced element doc.	NA	NA	NA	NA	NA	NA
StoreHoursRef:StoreHoursRef	*	0	unbounded	It's a referenced element. For detailed description, please refer referenced element doc.	NA	NA	NA	NA	NA	NA

XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	Mapping for AddrRef in SIM application.
XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	SIM's Table Name	SIM's Column Name	Integration API(RIB or/and RSB or/and BDI)	SIM's Column Length	Is Column Required in SIM's API?	SIM'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.	ADDRESS	EXTERNAL_ID	VARCHAR2	25	Yes	this will hold the external reference id

XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	Mapping for StoreHoursRef in SIM application.
XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	SIM's Table Name	SIM's Column Name	Integration API(RIB or/and RSB or/and BDI)	SIM's Column Length	Is Column Required in SIM's API?	SIM's API Description
store_id	number10	1	1	Unique ID of the store.	Fill application table name.	Fill table column name.	RIB or/and RSB	Fill column length.	Yes	Fill this description.
day_no	number1	1	1	This field indicates the day of the week for which store timing is being stored.	Fill application table name.	Fill table column name.	RIB or/and RSB	Fill column length.	Yes	Fill this description.