XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ShlfRplCriVo 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 |
store_id |
number10 |
1 |
1 |
Includes only shelf replenishments for this store. |
SHELF_REPLENISH |
STORE_ID |
NUMBER |
10,0 |
Yes |
The store id this shelf replenishment is associated to |
replenishment_id |
varchar215 |
0 |
1 |
Includes only shelf replenishments with this identifier. This will limit the response to a single shelf replenishment. |
SHELF_REPLENISH |
ID |
NUMBER |
12,0 |
Yes |
the unique identifier for shelf replenishment |
status |
shlf_repl_cri_status |
1 |
1 |
Includes only shelf replenishments with this status. Valid values are NEW, IN_PROGRESS, COMPLETE, CANCELED, PENDING_ALTERED, NO_VALUE. |
SHELF_REPLENISH |
STATUS |
NUMBER |
2,0 |
Yes |
the status of the shelf replenishment. valid values |
type |
shlf_repl_cri_type |
1 |
1 |
Includes only shelf replenishments with this type. Valid values are CAPACITY, SALES, AD_HOC, DISPLAY, NO_VALUE. |
SHELF_REPLENISH |
TYPE |
NUMBER |
2,0 |
Yes |
The type of shelf replenishment being generated. valid values |
product_group_id |
number12 |
0 |
1 |
Includes only shelf replenishments with this product group id. |
SHELF_REPLENISH |
PRODUCT_GROUP_ID |
NUMBER |
12,0 |
No |
the unique identifier of the product group associated with this shelf replenishment |
item_id |
varchar225 |
0 |
1 |
Includes only shelf replenishments with this SKU number. |
SHELF_REPLENISH_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
the unique identifier of the item |
replenishment_mode |
shlf_repl_cri_mode |
1 |
1 |
Includes only shelf replenishments with this mode. Valid values are END_OF_DAY, WITHIN_DAY, NO_VALUE. |
SHELF_REPLENISH |
REPLENISH_MODE |
NUMBER |
2,0 |
No |
The mode of Capacity/Sales type shelf replenishment. valid values |
shelf_adjust_id |
number15 |
0 |
1 |
Includes only shelf replenishments with this adjustment id. |
SHELF_REPLENISH |
SHELF_ADJUST_ID |
NUMBER |
15,0 |
No |
ID of the shelf adjustment list |
user_name |
varchar2128 |
0 |
1 |
Include only shelf replenishments created by this user. |
SHELF_REPLENISH |
USER_ID |
VARCHAR2 |
128 |
No |
the unique user id of the user that created the shelf replenishment |
from_date |
xs:dateTime |
0 |
1 |
Include only shelf replenishments created at or after this date in GMT. |
SHELF_REPLENISH |
CREATE_DATETIME |
DATE |
Fill column length. |
Yes |
the date and time that the shelf replenishment was created |
to_date |
xs:dateTime |
0 |
1 |
Include only shelf replenishments created at or before this date in GMT. |
SHELF_REPLENISH |
CREATE_DATETIME |
DATE |
Fill column length. |
Yes |
the date and time that the shelf replenishment was created |
department_id |
number12 |
0 |
1 |
Includes only sales based shelf replenishments with this department id. |
SHELF_REPLENISH |
DEPARTMENT_ID |
NUMBER |
12,0 |
No |
hierarchy department id |
class_id |
number12 |
0 |
1 |
Includes only sales based shelf replenishments with this class id. |
SHELF_REPLENISH |
CLASS_ID |
NUMBER |
12,0 |
No |
hierarchy class id |
subclass_id |
number12 |
0 |
1 |
Includes only sales based shelf replenishments with this subclass id. |
SHELF_REPLENISH |
SUBCLASS_ID |
NUMBER |
12,0 |
No |
hierarchy subclass id |