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

XML-Schema Name:ShlfAdjHdrColDesc 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 ShlfAdjHdrColDesc 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
ShlfAdjHdrDesc:ShlfAdjHdrDesc * 0 unbounded Collection of shelf adjustment headers. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:ShlfAdjHdrDesc 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 ShlfAdjHdrDesc 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
shelf_adjust_id number15 1 1 Unique identifier. SHELF_ADJUST ID NUMBER 15,0 Yes Unique ID of the shelf adjustment list
store_id number10 1 1 Store identifier. SHELF_ADJUST STORE_ID NUMBER 10,0 Yes ID of the store
user_name varchar2128 0 1 User name of the user who created the shelf adjustment. SHELF_ADJUST USER_ID VARCHAR2 128 No ID of the user
create_date xs:dateTime 0 1 Date in GMT that the shelf adjustment was created. SHELF_ADJUST CREATE_DATE_TIME DATE Fill column length. No shelf adjustment list create date time
update_date xs:dateTime 0 1 Date in GMT that the shelf adjustment was updated. SHELF_ADJUST UPDATE_DATE_TIME DATE Fill column length. No shelf adjustment list update date time
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
number_of_line_items number10 1 1 Number of line items on the shelf adjustment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.