Retail Integration Mappings Report Release:15.0.0 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/ItmBasketModVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:ItmBasketModVo Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItmBasketModVo 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_basket_id number12 0 1 SIM internal identifier. If null, new item basket will be created otherwise existing item basket will be updated. ITEM_BASKET ID VARCHAR2 128 Yes this column contains the customer reference.
external_id varchar2128 1 1 Item basket identifier external to SIM. ITEM_BASKET EXTERNAL_ID varchar2 128 Yes this column contains the customer reference.
type_id number2 1 1 Item basket type identifier ITEM_BASKET_TYPE ID NUMBER 2,0 Yes The item basket type id defined in ITEM_BASKET_TYPE table
store_id number10 1 1 Store identifier ITEM_BASKET STORE_ID NUMBER 10,0 Yes store id of the store to which this item basket belongs.
ItmBasketModItm * 0 5000 Collection of added or modified item basket line items.
removed_line_id_col number10 0 1000 Collections of removed items indicated by its unique line identifier. ITEM_BASKET_LINE_ITEM ID NUMBER 12,0 Yes this column value is generated from the sequence.

XML-Schema Name:ItmBasketModItm Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItmBasketModItm 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
line_id number12 0 1 Unique line item identifier. If null, new item basket line item will be created otherwise existing item will be updated. ITEM_BASKET_LINE_ITEM ID NUMBER 12,0 Yes this column value is generated from the sequence.
item_id varchar225 1 1 Sku number ITEM_BASKET_LINE_ITEM ITEM_ID VARCHAR2 25 Yes this column contains the item id.
uin varchar2128 0 1 Universal identifier number ITEM_BASKET_LINE_ITEM UIN VARCHAR2 128 No uin of this item.
quantity number12_4 1 1 Quantity in units. Quantity will be overridden with 1 if uin exists. ITEM_BASKET_LINE_ITEM QUANTITY NUMBER 12,4 Yes this column contains the quantity of this item in this item basket.
case_size number12_4 1 1 Default case size of item ITEM_BASKET_LINE_ITEM CASE_SIZE NUMBER 12,4 No pack size of the item.
uom varchar240 1 1 Unit of measure STORE_ITEM SELLING_UNIT_OF_MEASURE VARCHAR2 4 Yes Selling unit of measure at the store.