Application
|
Store Inventory Management
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/InvAvailCriVo/v1
|
Version
|
1.0
|
Description
|
|
XSD Structure
|
|
|
XML-Schema Name:InvAvailCriVo
|
Version:14.0.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for InvAvailCriVo 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 |
items |
varchar225 |
1 |
unbounded |
Contains the transaction level item numbers for which to check inventory. |
|
|
|
|
Yes |
Contains the transaction level item numbers for which to check inventory. |
InvLocation
|
*
|
1
|
unbounded
|
Contains the locations at which to check inventory.
|
|
|
|
|
|
|
store_pickup_ind |
store_pickup_ind |
1 |
1 |
Indicates if the inventory availability lookup is for general purpose or specific for store pickup. Valid values are 'Y' (store pickup) and 'N' (others). This field will be used for routing the input request. |
|
|
|
|
Yes |
not used in SIM |
|
|
XML-Schema Name:InvLocation
|
Version:14.0.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for InvLocation 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 |
location |
number10 |
1 |
1 |
The location at which to check item inventory. |
|
|
|
|
Yes |
store identifier |
loc_type |
loc_type |
1 |
1 |
Type of item inventory location. Valid values are 'S' (store) and 'W' (warehouse). |
|
|
|
|
Yes |
valid values are S and W |
channel_id |
number4 |
0 |
1 |
Only used when a physical WH is passed. If a channel is passed the results will be limited by the passed in channel. |
|
|
|
|
Yes |
Only used when a physical WH is passed. If a channel is passed the results will be limited by the passed in channel. |
|
|