XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for SiUinDesc 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 |
uin |
varchar2128 |
1 |
1 |
Unique identifier number (also known as serial number) |
ITEM_UIN |
UIN |
VARCHAR2 |
128 |
Yes |
an identifier of universal identification number |
uin_type |
si_uin_type |
1 |
1 |
UIN type Valid values are SERIAL_NUMBER, AGSN, UNKNOWN. |
ITEM_UIN |
TYPE |
NUMBER |
2 |
Yes |
uni_type. ex: serial |
item_id |
varchar225 |
1 |
1 |
Sku number |
ITEM_UIN |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
an identifier of an item |
store_id |
number10 |
1 |
1 |
Store identifier |
ITEM_UIN |
STORE_ID |
NUMBER |
10,0 |
Yes |
ITEM_UIN |
status |
si_uin_status |
1 |
1 |
Current status 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 of serialization. these values are in the java application. ex in_stock(0,in stock), sold(1,sold) |
transaction_id |
varchar2128 |
0 |
1 |
Reference to the last transaction that updated 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 |
transaction_type |
si_uin_tran_type |
1 |
1 |
Type of transaction that last updated 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 |
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 |
carton_id |
varchar2128 |
0 |
1 |
Reference to a carton associated to the UIN |
ITEM_UIN |
CARTON_ID |
VARCHAr2 |
128 |
No |
identifier of carton |
nonsellable_type_id |
number12 |
0 |
1 |
Non-sellable quantity type (sub-bucket) identifier. Only available if UIN is non-sellable and non-available tracking is activated. |
ITEM_UIN |
NONSELLABLE_TYPE_ID |
NUMBER |
12 |
No |
Nonseelable type id |
damaged |
xs:boolean |
1 |
1 |
True if UIN is considered damaged, false otherwise |
ITEM_UIN |
DAMAGED |
VARCHAR2 |
1 |
No |
Indicates if this UIN is damaged.Valid values are Y or N |
|