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/ShlfAdjModVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:ShlfAdjModVo 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 ShlfAdjModVo 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
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 NEW, 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 SHOP_FLOOR_ADJUST, BACK_ROOM_ADJUST, DISPLAY_LIST, ADHOC_REPLENISH, 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 or/and RSL Fill column length. No Fill this description.

XML-Schema Name:ShlfAdjModItm 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 ShlfAdjModItm 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 0 1 Line item unique identifier. If null, the line item will be created. SHELF_ADJUST_LINE_ITEM ID NUMBER 15,0 No Unique ID for the line item
item_id varchar225 1 1 SKU number. SHELF_ADJUST_LINE_ITEM ITEM_ID VARCHAR2 25 Yes ID of the item
requested_pick_amount number20_4 1 1 Quantity requested. SHELF_ADJUST_LINE_ITEM SUGGESTED_QTY NUMBER 25,4 Yes suggested qty for the item
case_size number10_2 1 1 Case size associated with the item. SHELF_ADJUST_LINE_ITEM CASE_SIZE NUMBER 12,4 Yes Case size of the item