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

XML-Schema Name:ActLckDesc 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 ActLckDesc 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
lock_id number12 1 1 Lock identifier. ACTIVITY_LOCK ID NUMBER 12,0 Yes the unique identifier of an activity lock.
user_name varchar2128 1 1 User that owns the lock. ACTIVITY_LOCK USERNAME VARCHAR2 128 Yes the unique identifier of the user that owns the lock.
device_type act_lck_device_type 1 1 Device type of the lock. Valid values are PC, HH, SERVER, INT_SERVICE. ACTIVITY_LOCK DEVICE_TYPE NUMBER 4,0 Yes the type of device associated with the session that owns the lock.
activity_id varchar2128 1 1 Identifier of the activity that is locked. ACTIVITY_LOCK ACTIVITY_ID VARCHAR2 128 Yes the unique identifier of the activity that is locked.
activity_type act_lck_activity_type 1 1 Type of activity that is locked. Valid values are DIRECT_DELIVERY, DIRECT_DELIVERY_INVOICE, FULFILLMENT_ORDER, FULFILLMENT_ORDER_DELIVERY, FULFILLMENT_ORDER_PICK, FULFILLMENT_ORDER_REVERSE_PICK, INVENTORY_ADJUSTMENT, INVENTORY_ADJUSTMENT_REASON, INVENTORY_ADJUSTMENT_TEMPLATE, ITEM_BASKET, ITEM_REQUEST, ITEM_TICKET, SHELF_REPLENISHMENT, PRICE_CHANGE, PRODUCT_GROUP, PRODUCT_GROUP_SCHEDULE, RETURN, RETURN_REASON, STOCK_COUNT_CHILD, STORE_SEQUENCE, STORE_SEQUENCE_ALL, TRANSFER, WAREHOUSE_DELIVERY, UNKNOWN. ACTIVITY_LOCK ACTIVITY_TYPE VARCHAR2 40 Yes the type of activity that is locked.
session_id varchar2128 1 1 Identifier of the session that owns the lock. ACTIVITY_LOCK SESSION_ID VARCHAR2 128 Yes the unique identifier of the session that owns the lock.
lock_date xs:dateTime 1 1 Date the lock was created. ACTIVITY_LOCK LOCK_DATE DATE Fill column length. Yes the date the activity was locked.