XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ShlfAdjCriVo 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 adjustments for this store. |
SHELF_ADJUST |
STORE_ID |
NUMBER |
10,0 |
Yes |
ID of the store |
shelf_adjust_id |
number15 |
0 |
1 |
Includes only shelf adjustment with this identifier. This will limit the response to a single shelf adjustment. |
SHELF_ADJUST |
ID |
NUMBER |
15,0 |
No |
Unique ID of the shelf adjustment list |
status |
shlf_adj_cri_status |
1 |
1 |
Includes only shelf adjustments with this shelf adjustment status. Valid values are NEW, COMPLETE, NO_VALUE. |
SHELF_ADJUST |
STATUS |
NUMBER |
2,0 |
Yes |
Status of the Shelf adjustment list. 0- New, 1- Closed |
type |
shlf_adj_cri_type |
1 |
1 |
Includes only shelf adjustments with this shelf adjustment type. Valid values are SHOP_FLOOR_ADJUST, BACK_ROOM_ADJUST, DISPLAY_LIST, ADHOC_REPLENISH, NO_VALUE. |
SHELF_ADJUST |
TYPE |
NUMBER |
2,0 |
Yes |
The type of shelf adjustment list. Valid values |
item_id |
varchar225 |
0 |
1 |
Includes only shelf adjustments with this SKU number. |
SHELF_ADJUST_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
No |
ID of the item |
user_name |
varchar2128 |
0 |
1 |
Include only shelf adjustments created by this user. |
SHELF_ADJUST |
USER_ID |
VARCHAR2 |
128 |
No |
ID of the user |
from_date |
xs:dateTime |
0 |
1 |
Include only shelf adjustments created at or after this date in GMT. |
SHELF_ADJUST |
CREATE_DATE_TIME |
DATE |
Fill column length. |
No |
shelf adjustment list create date time |
to_date |
xs:dateTime |
0 |
1 |
Include only shelf adjustments created at or before this date in GMT. |
SHELF_ADJUST |
UPDATE_DATE_TIME |
DATE |
Fill column length. |
No |
shelf adjustment list update date time |