Retail Integration Mappings Report Release:15.0.0 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/ShlfRplDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:ShlfRplDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ShlfRplDesc 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
replenishment_id varchar215 1 1 Shelf replenishment unique identifier. SHELF_REPLENISH ID NUMBER 15,0 Yes the unique identifier for shelf replenishment
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
product_group_id number12 0 1 Product group unique identifier for sales or capacity based replenishment. SHELF_REPLENISH PRODUCT_GROUP_ID NUMBER 12,0 No the unique identifier of the product group associated with this 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
shelf_adjust_id number15 0 1 Shelf adjustment list unique identifier. SHELF_REPLENISH SHELF_ADJUST_ID NUMBER 15,0 No ID of the shelf adjustment list
description varchar2128 0 1 Description or name of the shelf replenishment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
replenish_quantity number20_4 0 1 Quantity to replenish. SHELF_REPLENISH AMOUNT_TO_PICK NUMBER 20,4 No the total number of items to be picked
status shlf_repl_status 1 1 Status of the shelf replenishment. Valid values are NEW, IN_PROGRESS, COMPLETE, CANCELED, PENDING_ALTERED, UNKNOWN. SHELF_REPLENISH STATUS NUMBER 2,0 No the status of the shelf replenishment. valid values
type shlf_repl_type 1 1 Type of the 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
user_name varchar2128 1 1 User name of the user who created the shelf replenishment. SHELF_REPLENISH USER_ID VARCHAR2 128 No the unique user id of the user that created the shelf replenishment
create_date xs:dateTime 1 1 Date in GMT that the shelf replenishment was created. SHELF_REPLENISH CREATE_DATETIME DATE Fill column length. Yes the date and time that the shelf replenishment was created
update_date xs:dateTime 1 1 Date in GMT that the shelf replenishment was updated. SHELF_REPLENISH STATUS_DATE DATE Fill column length. No The date of shelf replenishment status was set
ShlfRplItm * 0 999 Collection of shelf replenishment line items.

XML-Schema Name:ShlfRplItm Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ShlfRplItm 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
line_id number12 1 1 Line item unique identifier. SHELF_REPLENISH_LINE_ITEM ID NUMBER 15,0 Yes an unique identifier of shelf replenishment line item that is generated by system
item_id varchar225 1 1 SKU number. SHELF_REPLENISH_LINE_ITEM ITEM_ID VARCHAR2 25 Yes the unique identifier of the item
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
requested_pick_amount number20_4 1 1 Quantity to be picked. SHELF_REPLENISH_LINE_ITEM REQUESTED_PICK_AMOUNT NUMBER 20,4 No the number of items to be picked
actual_pick_amount number20_4 1 1 Quantity actually picked. SHELF_REPLENISH_LINE_ITEM ACTUAL_PICK_AMOUNT NUMBER 20,4 No the actual amount that was picked
case_size number10_2 1 1 Case size associated with the item. SHELF_REPLENISH_LINE_ITEM CASE_SIZE NUMBER 12,4 No the pack size of the item to be picked
substitute_item_id varchar225 0 1 SKU number of the original item. SHELF_REPLENISH_LINE_ITEM SUBSTITUTE_LINE_ITEM_ID NUMBER 12,0 No The SIM identifier of another shelf replenishment line item for which this line item is being substituted for.