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

XML-Schema Name:SiUinColModVo 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 SiUinColModVo 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 identifier STORE ID NUMBER 10,0 Yes a unique retailer assigned identifier for a location.
SiUinModVo:SiUinModVo * 0 500 Modification objects to be processed. NA NA NA NA NA NA

XML-Schema Name:SiUinModVo 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 SiUinModVo 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
item_id varchar225 1 1 Sku number ITEM_UIN ITEM_ID VARCHAR2 25 Yes an identifier of an item
uin varchar2128 1 1 Unique identifier number. ITEM_UIN UIN VARCHAR2 128 Yes an identifier of universal identification number
status si_uin_status 1 1 Status to assign to the UIN when it is created. Valid values are CUSTOMER_RESERVED, CUSTOMER_FULFILLED, IN_RECEIVING, IN_STOCK, MISSING, RESERVED_FOR_SHIPPING, REMOVE_FROM_INVENTORY, SHIPPED_TO_FINISHER, SHIPPED_TO_VENDOR, SHIPPED_TO_WAREHOUSE, SHIPPED_TO_STORE, SOLD, UNAVAILABLE, UNCONFIRMED, UNKNOWN. ITEM_UIN STATUS NUMBER 2,0 Yes Status to assign to the UIN when it is created. Valid values are CUSTOMER_RESERVED, CUSTOMER_FULFILLED, IN_RECEIVING, IN_STOCK, MISSING, RESERVED_FOR_SHIPPING, REMOVE_FROM_INVENTORY, SHIPPED_TO_FINISHER, SHIPPED_TO_VENDOR, SHIPPED_TO_WAREHOUSE, SHIPPED_TO_STORE, SOLD, UNAVAILABLE, UNCONFIRMED, UNKNOWN.
damaged xs:boolean 1 1 True if UIN is to be considered damaged, false otherwise. ITEM_UIN DAMAGED VARCHAR2 1 No Indicates if this UIN is damaged.Valid values are Y or N
transaction_type si_uin_tran_type 1 1 Type of a transaction to associate to the UIN. Valid values are CREATE_RETURN, CREATE_TRANSFER, CUSTOMER_ORDER, DIRECT_DELIVERY_RECEIPT, DISPATCH_RETURN, DISPATCH_TRANSFER, INVENTORY_ADJUSTMENT, MANUAL, POS_SALE, POS_RETURN, POS_SALES_VOID, POS_RETURN_VOID, RECEIVE_TRANSFER, RECEIPT_ADJUSTMENT, STOCK_COUNT, STOCK_RECOUNT, STOCK_COUNT_AUTHORIZED, UIN_WEB_SERVICE, WAREHOUSE_DELIVERY_RECEIPT, UNKNOWN. ITEM_UIN FUNCTIONAL_AREA NUMBER 2,0 No This field describes the business area and potentially phase of the business area that is affecting the data. 0 - Warehouse Delivery Receipt, 1 - Direct Delivery Receipt, 2 - Create Transfer, 3 - Dispatch Transfer, 4 - Receive Transfer, 5 - Receipt Adjustment, 6 - Create Return, 7 - Dispatch Return, 8 - Inventory Adjustment, 9 - Stock Count, 10 - Stock Re-Count, 11 - Stock Count Authorized, 12 - Manual, 13 - POS Sale, 14 - POS Return, 15 - POS Sale Void, 16 - POS Return Void, 17 - UIN Web Service, 18 - Customer Order
transaction_id varchar2128 0 1 Identifier of a transaction to associate to the UIN. ITEM_UIN FUNCTIONAL_ID VARCHAR2 128 No functional identifier or transaction id. ex for inventory adjustment, it would be unique identifer of inventory adjustment