Application
|
Store Inventory Management
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/ShlfRplModVo/v1
|
Version
|
1.0
|
Description
|
|
XSD Structure
|
|
|
XML-Schema Name:ShlfRplModVo
|
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 ShlfRplModVo 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 |
replenishment_id |
varchar215 |
1 |
1 |
Shelf replenishment identifier. |
SHELF_REPLENISH_LINE_ITEM |
SHELF_REPLENISH_ID |
NUMBER |
12,0 |
Yes |
the unique identifier of the shelf replenishment that this line item is associated to |
store_id |
number10 |
1 |
1 |
Store id. |
SHELF_REPLENISH |
STORE_ID |
NUMBER |
10,0 |
Yes |
The store id this shelf replenishment is associated to |
ShlfRplItmMod
|
*
|
1
|
999
|
Collection of shelf replenishment line items.
|
|
|
|
|
|
|
|
|
XML-Schema Name:ShlfRplItmMod
|
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 ShlfRplItmMod 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 |
line_id |
number12 |
1 |
1 |
Line item unique identifier |
SHELF_REPLENISH_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
the unique identifier of the item |
actual_pick_amount |
number20_4 |
1 |
1 |
Quantity picked in standard unit of measure. |
SHELF_REPLENISH_LINE_ITEM |
ACTUAL_PICK_AMOUNT |
NUMBER |
20,4 |
No |
the actual amount that was picked |
pick_from_area |
shlf_repl_pick_area |
1 |
1 |
Pick from area in the store. Valid values are BACKROOM, DELIVERY_BAY, UNKNOWN. |
SHELF_REPLENISH_LINE_ITEM |
PICK_FROM_AREA |
NUMBER |
2,0 |
Yes |
the location where to pick the stock from |
ShlfRplSubMod
|
*
|
0
|
unbounded
|
Collection of shelf replenishment substitute line items.
|
|
|
|
|
|
|
|
|
XML-Schema Name:ShlfRplSubMod
|
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 ShlfRplSubMod 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. |
SHELF_REPLENISH_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
the unique identifier of the item |
actual_pick_amount |
number20_4 |
1 |
1 |
Quantity picked in standard unit of measure. |
SHELF_REPLENISH_LINE_ITEM |
ACTUAL_PICK_AMOUNT |
NUMBER |
20,4 |
No |
the actual amount that was picked |
pick_from_area |
shlf_repl_pick_area |
1 |
1 |
Pick from area in the store. Valid values are BACKROOM, DELIVERY_BAY, UNKNOWN. |
SHELF_REPLENISH_LINE_ITEM |
PICK_FROM_AREA |
NUMBER |
2,0 |
Yes |
the location where to pick the stock from |
|
|