XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ShlfAdjModVo 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 |
adjustment_id |
number15 |
0 |
1 |
Shelf adjustment identifier. If left black, a new shelf adjustment will be created. |
SHELF_ADJUST_LINE_ITEM |
SHELF_ADJUST_ID |
NUMBER |
15,0 |
Yes |
shelf adjustment list ID |
store_id |
number10 |
1 |
1 |
Store identifier. |
SHELF_ADJUST |
STORE_ID |
NUMBER |
10,0 |
Yes |
ID of the store |
user_name |
varchar2128 |
1 |
1 |
The user name of the user requesting the changes. |
SHELF_ADJUST |
USER_ID |
VARCHAR2 |
128 |
Yes |
ID of the user |
status |
shlf_adj_status |
1 |
1 |
Status of the shelf adjustment. Valid values are IN_PROGRESS, COMPLETE, UNKNOWN. |
SHELF_ADJUST |
STATUS |
NUMBER |
2,0 |
Yes |
Status of the Shelf adjustment list. 0- New, 1- Closed |
type |
shlf_adj_type |
1 |
1 |
Type of the shelf adjustment. Valid values are MOVE_TO_BACKROOM, UPDATE_SHOPFLOOR, UPDATE_BACKROOM, UNKNOWN. |
SHELF_ADJUST |
TYPE |
NUMBER |
2,0 |
Yes |
The type of shelf adjustment list. Valid values |
ShlfAdjModItm
|
*
|
0
|
999
|
Collection of shelf adjustment line items.
|
|
|
|
|
|
|
removed_line_id_col |
number12 |
0 |
5000 |
Collections of removed line items indicated by their unique identifer. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
No |
Fill this description. |
|