|
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:16.0.030
|
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 BDI) |
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 |
1 |
Yes |
Indicates if the store is stockholding or not. |
|
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
|
|
|
|
XML-Schema Name:AddrRef
|
Version:16.0.030
|
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 BDI) |
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. |
|
|
|
XML-Schema Name:StoreHoursRef
|
Version:16.0.030
|
Return to Top
|
| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StoreHoursRef in RMS application. |
| RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
| store_id |
number10 |
1 |
1 |
Unique ID of the store. |
store_hours |
store |
number |
10,0 |
Yes |
This coulmn contains the number which uniquely identifies the store. |
| day_no |
number1 |
1 |
1 |
This field indicates the day of the week for which store timing is being stored. |
store_hours |
day_no |
number |
1,0 |
Yes |
This column contains the numeric value which indicates the day of the week on which the store will be open/closed. Valid values are 1-Sunday,2-Monday,3-Tuesday,4-Wednesday,5-Thursday,6-Friday,7-Saturday. |
|
|
