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 BDI) |
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 CLIENT, SERVER, INT_SERVICE, UNKNOWN, NO_VALUE. |
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 BILL_OF_LADING, DIRECT_DELIVERY_INVOICE, FULFILLMENT_ORDER, FULFILLMENT_ORDER_DELIVERY, FULFILLMENT_ORDER_PICK, FULFILLMENT_ORDER_REVERSE_PICK, INVENTORY_ADJUSTMENT, INVENTORY_ADJUSTMENT_REASON, SHELF_ADJUSTMENT, SHELF_REPLENISHMENT, PRODUCT_GROUP, PRODUCT_GROUP_SCHEDULE, RETURN_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, NO_VALUE. |
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 |
|
Yes |
the date the activity was locked. |
|