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

XML-Schema Name:ShlfRplHdrColDesc 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 ShlfRplHdrColDesc 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
ShlfRplHdrDesc:ShlfRplHdrDesc * 0 unbounded Collection of shelf replenishment 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:ShlfRplHdrDesc 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 ShlfRplHdrDesc 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 number15 1 1 Unique identifier. SHELF_REPLENISH ID NUMBER 12,0 Yes the unique identifier for shelf replenishment
store_id number10 1 1 Store identifier. SHELF_REPLENISH STORE_ID NUMBER 10,0 Yes The store id this shelf replenishment is associated to
description varchar2128 0 1 Description/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.
user_name varchar2128 0 1 User that 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 0 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
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 Yes the status of the shelf replenishment. valid values
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
replenish_quantity number20_4 1 1 Quantity to be replenished. SHELF_REPLENISH AMOUNT_TO_PICK NUMBER 20,4 No the total number of items to be picked
actual_quantity number20_4 1 1 Actual quantity picked. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
number_of_line_items number10 1 1 Number of line items on 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.