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 BDI) |
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 |
1 |
1 |
Include only locks owned by this device type. 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 |
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 |
1 |
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, 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 |
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 |
|
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 |
|
Yes |
the date the activity was locked. |
|