| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ShlfRplCreVo 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 |
Store unique identifier. |
SHELF_REPLENISH |
STORE_ID |
NUMBER |
10,0 |
Yes |
The store id this shelf replenishment is associated to |
| type |
shlf_repl_type |
1 |
1 |
Type of shelf replenishment. Valid values are CAPACITY, SALES, AD_HOC, DISPLAY, UNKNOWN. |
SHELF_REPLENISH |
TYPE |
NUMBER |
2,0 |
Yes |
The type of shelf replenishment being generated. valid values |
| replenishment_mode |
shlf_repl_mode |
1 |
1 |
Mode of the shelf replenishment. Valid values are END_OF_DAY, WITHIN_DAY, UNKNOWN. |
SHELF_REPLENISH |
REPLENISH_MODE |
NUMBER |
2,0 |
No |
The mode of Capacity/Sales type shelf replenishment. valid values |
| product_group_id |
number12 |
0 |
1 |
Product group unique identifier. |
SHELF_REPLENISH |
PRODUCT_GROUP_ID |
NUMBER |
12,0 |
No |
the unique identifier of the product group associated with this shelf replenishment |
| shelf_adjust_id |
number15 |
0 |
1 |
Shelf adjustment id for shelf replenishment. |
SHELF_REPLENISH |
SHELF_ADJUST_ID |
NUMBER |
15,0 |
No |
ID of the shelf adjustment list |
| user_name |
varchar2128 |
0 |
1 |
User name. |
SHELF_REPLENISH |
USER_ID |
VARCHAR2 |
128 |
No |
the unique user id of the user that created the shelf replenishment |
| department_id |
number12 |
0 |
1 |
Department id for sales based replenishment. |
SHELF_REPLENISH |
DEPARTMENT_ID |
NUMBER |
12,0 |
No |
hierarchy department id |
| class_id |
number12 |
0 |
1 |
Class id for sales based replenishment. |
SHELF_REPLENISH |
CLASS_ID |
NUMBER |
12,0 |
No |
hierarchy class id |
| subclass_id |
number12 |
0 |
1 |
Subclass id for sales based replenishment. |
SHELF_REPLENISH |
SUBCLASS_ID |
NUMBER |
12,0 |
No |
hierarchy subclass id |
| replenishment_quantity |
number20_4 |
1 |
1 |
Quantity to be replenished for Within day replenishment. |
SHELF_REPLENISH |
AMOUNT_TO_PICK |
NUMBER |
20,4 |
No |
the total number of items to be picked |
| check_available_soh |
xs:boolean |
1 |
1 |
True indicates stock on hand should be checked or validated, false indicates not. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
