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