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. | |