|
Application
|
Store Inventory Management
|
|
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:14.1.0
|
Return to Top
|
| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItemLocRef in SIM application. |
| SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
| item |
varchar225 |
1 |
1 |
Unique identifier for the item. |
Store_Item_Stock |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
Unique identifier for the item. |
|
ItemLocPhysRef
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
|
|
|
XML-Schema Name:ItemLocPhysRef
|
Version:14.1.0
|
Return to Top
|
| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItemLocPhysRef in SIM application. |
| SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
| physical_loc |
number10 |
1 |
1 |
Identifier of the physical location where the item is located. |
STORE_ITEM |
STORE_ID |
number |
10,0 |
No |
warehouse or store id |
| loc_type |
varchar21 |
0 |
1 |
Type of location in the physical_loc field. Valid values are: S = Store, W = Warehouse, E = external finisher. |
|
|
|
|
|
Possible value LOC_TYPE_STORE("S") |
| 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. |
|
|
|
|
|
Possible values STORE_TYPE_COMPANY("C"),
STORE_TYPE_FRANCHISE("F"), |
| 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. |
|
|
|
|
|
values are either "Y" or "N" |
|
ItemLocVirtRef
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
|
|
|
XML-Schema Name:ItemLocVirtRef
|
Version:14.1.0
|
Return to Top
|
| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItemLocVirtRef in SIM application. |
| SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM'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. |
STORE_ITEM |
STORE_ID |
number |
10,0 |
Yes |
store id |
|
|
