Application
|
Retail Merchandising System
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/InvAvailCriVo/v1
|
Version
|
1.0
|
Description
|
|
XSD Structure
|
|
|
XML-Schema Name:InvAvailCriVo
|
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 InvAvailCriVo 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 |
items |
varchar225 |
1 |
999 |
Contains the transaction level item numbers for which to check inventory. |
N/A |
N/A |
N/A |
N/A |
Yes |
N/A |
InvLocation
|
*
|
1
|
999
|
Contains the locations at which to check inventory.
|
|
|
|
|
|
|
sa:SearchAreaDesc
|
*
|
0
|
1
|
Used for proximity calculation. This defines the criteria to identify the inventory locations. SearchAreaDesc will override InvLocation when present.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
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. |
N/A |
N/A |
N/A |
N/A |
No |
N/A |
|
|
XML-Schema Name:InvLocation
|
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 InvLocation 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 |
location |
number10 |
1 |
1 |
The location at which to check item inventory. |
N/A |
N/A |
N/A |
N/A |
Yes |
N/A |
loc_type |
loc_type |
1 |
1 |
Type of item inventory location. Valid values are 'S' (store) and 'W' (warehouse). |
N/A |
N/A |
N/A |
N/A |
Yes |
N/A |
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. |
N/A |
N/A |
N/A |
N/A |
Yes |
N/A |
|
|