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

XML-Schema Name:ItmBasketDesc Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItmBasketDesc 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 1 1 Item basket identifier internal to SIM. ITEM_BASKET ID NUMBER 12,0 Yes this column is the primary key for item basket data.
external_id varchar2128 1 1 Item basket identifier external to SIM. ITEM_BASKET EXTERNAL_ID VARCHAR2 128 Yes this column contains the customer reference.
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.
type_id number2 1 1 Item basket type identifier ITEM_BASKET_TYPE ID NUMBER 2,0 Yes this is primary key
type_description varchar240 1 1 Item basket type identifier ITEM_BASKET_TYPE DESCRIPTION VARCHAR2 40 Yes The item basket type id defined in ITEM_BASKET_TYPE table
ItmBasketItm * 1 unbounded Collection of item basket items.

XML-Schema Name:ItmBasketItm Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItmBasketItm 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 1 1 Unique line item identifier 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 uom. If uom is not the item's standard unit of measure, conversion to standard unit of measure will be attempted. 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 of the quantity. If not standard unit of measure, it must be a uom with a conversion factor to standard uom. STORE_ITEM SELLING_UNIT_OF_MEASURE VARCHAR2 4 Yes Selling unit of measure at the store.