|
Application
|
Store Inventory Management
|
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/StrInvItmColDesc/v1
|
|
Version
|
1.0
|
|
Description
|
|
|
XSD Structure
|
|
|
|
XML-Schema Name:StrInvItmColDesc
|
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 StrInvItmColDesc 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 |
|
StrInvItmDesc:StrInvItmDesc
|
*
|
0
|
unbounded
|
Collection of store item inventory information.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
| collection_size |
number4 |
1 |
1 |
Size of the collection. |
STORE_ITEM_STOCK |
n/a |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
|
|
|
XML-Schema Name:StrInvItmDesc
|
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 StrInvItmDesc 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 |
| item_id |
varchar225 |
1 |
1 |
Sku number |
ITEM, WAREHOUSE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
Item identifier. |
| store_id |
number10 |
1 |
1 |
Store identifier |
STORE_ITEM, WAREHOUSE_ITEM |
STORE_ID, WAREHOUSE_ID |
NUMBER |
10 |
Yes |
Location identifier of the inventory location |
| available_qty |
number20_4 |
1 |
1 |
Available quantity |
|
|
|
|
No |
Calculated Available SOH at the store/warehouse. |
| uom_code |
varchar24 |
1 |
1 |
Unit of measure code of the quantities. |
ITEM |
UNIT_OF_MEASURE |
VARCHAR2 |
4 |
Yes |
unit of measure which the stock for this item is tracked at the coporate level. |
|
|
