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

XML-Schema Name:SiUinGenDesc 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 SiUinGenDesc 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 that supports AGSN type STORE_UIN_ADMIN_ITEM ITEM_ID VARCHAR2 25 Yes an item identification
store_id number10 1 1 Store identifier STORE_UIN_ADMIN_ITEM STORE_ID NUMBER 10,0 Yes an identification of store
quantity number4 1 1 Quantity of UINs to generate. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Quantiy of UINs to generate(AGSN)
transaction_type si_uin_tran_type 1 1 Type of a transaction to associate to all the generated UINS 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 all the generated UINs. ITEM_UIN FUNCTIONAL_ID VARCHAR2 128 Yes functional identifier or transaction id ex for inventory adjustment, it would be unique identifer of inventory adjustment