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

XML-Schema Name:ActLckCriVo 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 ActLckCriVo 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
user_name varchar2128 0 1 Include only locks owned by this user. ACTIVITY_LOCK USERNAME VARCHAR2 128 Yes the unique identifier of the user that owns the lock.
device_type act_lck_device_type 0 1 Include only locks owned by this device type. 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 0 1 Include only locks for this activity identifier. ACTIVITY_LOCK ACTIVITY_ID VARCHAR2 128 Yes the unique identifier of the activity that is locked.
activity_type act_lck_activity_type 0 1 Include only locks for this activity type. Valid values are BILL_OF_LADING, 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, ITEM_TICKET_REQUEST, TICKET_FORMAT, SHELF_ADJUSTMENT, SHELF_REPLENISHMENT, PRICE_CHANGE, PRODUCT_GROUP, PRODUCT_GROUP_SCHEDULE, SHIPMENT_REASON, STOCK_COUNT_CHILD, STORE_SEQUENCE, STORE_SEQUENCE_ALL, TRANSFER, TRANSFER_DELIVERY_CARTON, TRANSFER_SHIPMENT_CARTON, VENDOR_DELIVERY_CARTON, VENDOR_SHIPMENT_CARTON, VENDOR_RETURN, UNKNOWN.. ACTIVITY_LOCK ACTIVITY_TYPE VARCHAR2 40 Yes the type of activity that is locked.
session_id varchar2128 0 1 Include only locks owned by this session identifier. ACTIVITY_LOCK SESSION_ID VARCHAR2 128 Yes the unique identifier of the session that owns the lock.
from_date xs:dateTime 0 1 Include only locks created on or after this date. ACTIVITY_LOCK LOCK_DATE Date Fill column length. Yes the date the activity was locked.
to_date xs:dateTime 0 1 Include only locks created on or before this date. ACTIVITY_LOCK LOCK_DATE Date Fill column length. Yes the date the activity was locked.