XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for LocStoreDesc in SIM application. |
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 |
SIM internal identifier |
STORE |
ID |
NUMBER |
10,0 |
Yes |
a unique retailer assigned identifier for a location. |
name |
varchar2150 |
1 |
1 |
Store name |
STORE |
NAME |
VARCHAR2 |
150 |
Yes |
name of the store |
language |
varchar22 |
1 |
1 |
Store's language of operation. A standardized 2 character code defined in ISO-639. |
STORE |
LOCALE_LANGUAGE |
VARCHAR2 |
2 |
Yes |
The 2-letter language code from ISO-639. |
country |
varchar22 |
1 |
1 |
Store's country of operation. A standardized 2 character code defined in ISO-3166. |
STORE |
LOCALE_COUNTRY |
VARCHAR2 |
3 |
Yes |
The 2-letter country code from ISO-3166. |
currency_code |
varchar240 |
1 |
1 |
Store's currency code of operation. A standardized 3 character code defined in ISO-4217. |
STORE |
CURRENCY_CODE |
VARCHAR2 |
40 |
Yes |
a code that signifies the currency that this location is operating under. |
transfer_zone |
varchar2128 |
0 |
1 |
Store's transfer zone. |
STORE |
TRANSFER_ZONE_ID |
VARCHAR2 |
128 |
No |
the unique identifier of the inventory transfer zone that the store belongs to. used to determine which locations are valid for inventory transfers from one location to another. |
timezone |
varchar280 |
1 |
1 |
Store's timezone as defined by the java TimeZone object. |
STORE |
TIMEZONE |
VARCHAR2 |
80 |
Yes |
contains the time zone that this store is located in. |
is_managed |
xs:boolean |
1 |
1 |
Indicates if the store is using the sim application. valid values are y or n. |
STORE |
SIM_STORE |
CHAR |
1 |
Yes |
indicates if the store is using the sim application. valid values are y or n. |