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 | serial | Yes | uni_type. ex | 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 affectingthe 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 | |