XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for SiUinModVo 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 |
item_id |
varchar225 |
1 |
1 |
Sku number |
ITEM_UIN |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
an identifier of an item |
uin |
varchar2128 |
1 |
1 |
Unique identifier number. |
ITEM_UIN |
UIN |
VARCHAR2 |
128 |
Yes |
an identifier of universal identification number |
status |
si_uin_status |
1 |
1 |
Status to assign to the UIN when it is created. Valid values are CUSTOMER_RESERVED, CUSTOMER_FULFILLED, IN_RECEIVING, IN_STOCK, MISSING, RESERVED_FOR_SHIPPING, REMOVE_FROM_INVENTORY, SHIPPED_TO_FINISHER, SHIPPED_TO_VENDOR, SHIPPED_TO_WAREHOUSE, SHIPPED_TO_STORE, SOLD, UNAVAILABLE, UNCONFIRMED, UNKNOWN. |
ITEM_UIN |
STATUS |
NUMBER |
2,0 |
Yes |
Status to assign to the UIN when it is created. Valid values are CUSTOMER_RESERVED, CUSTOMER_FULFILLED, IN_RECEIVING, IN_STOCK, MISSING, RESERVED_FOR_SHIPPING, REMOVE_FROM_INVENTORY, SHIPPED_TO_FINISHER, SHIPPED_TO_VENDOR, SHIPPED_TO_WAREHOUSE, SHIPPED_TO_STORE, SOLD, UNAVAILABLE, UNCONFIRMED, UNKNOWN. |
damaged |
xs:boolean |
1 |
1 |
True if UIN is to be considered damaged, false otherwise. |
ITEM_UIN |
DAMAGED |
VARCHAR2 |
1 |
No |
Indicates if this UIN is damaged.Valid values are
Y or N |
transaction_type |
si_uin_tran_type |
1 |
1 |
Type of a transaction to associate to the UIN. Valid values are CREATE_RETURN, CREATE_TRANSFER, CUSTOMER_ORDER, DIRECT_DELIVERY_RECEIPT, DISPATCH_RETURN, DISPATCH_TRANSFER, INVENTORY_ADJUSTMENT, MANUAL, POS_SALE, POS_RETURN, POS_SALES_VOID, POS_RETURN_VOID, RECEIVE_TRANSFER, RECEIPT_ADJUSTMENT, STOCK_COUNT, STOCK_RECOUNT, STOCK_COUNT_AUTHORIZED, UIN_WEB_SERVICE, WAREHOUSE_DELIVERY_RECEIPT, UNKNOWN. |
ITEM_UIN |
FUNCTIONAL_AREA |
NUMBER |
2,0 |
No |
This field describes the business area and potentially phase of the business area that is affecting
the data.
0 - Warehouse Delivery Receipt,
1 - Direct Delivery Receipt,
2 - Create Transfer,
3 - Dispatch Transfer,
4 - Receive Transfer,
5 - Receipt Adjustment,
6 - Create Return,
7 - Dispatch Return,
8 - Inventory Adjustment,
9 - Stock Count,
10 - Stock Re-Count,
11 - Stock Count Authorized,
12 - Manual,
13 - POS Sale,
14 - POS Return,
15 - POS Sale Void,
16 - POS Return Void,
17 - UIN Web Service,
18 - Customer Order |
transaction_id |
varchar2128 |
0 |
1 |
Identifier of a transaction to associate to the UIN. |
ITEM_UIN |
FUNCTIONAL_ID |
VARCHAR2 |
128 |
No |
functional identifier or transaction id.
ex for inventory adjustment, it would be unique identifer of inventory adjustment |
|