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/StrItmRelColDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:StrItmRelColDesc 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 StrItmRelColDesc 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
StrItmRelDesc:StrItmRelDesc * 0 unbounded Collection of related items. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:StrItmRelDesc 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 StrItmRelDesc 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 Related sku number RELATED_ITEM ITEM_ID VARCHAR2 25 Yes Item whose related items are recorded
short_description varchar2120 1 1 Short description ITEM SHORT_DESCRIPTION VARCHAR2 255 Yes the textural description of the item and its characteristics.
long_description varchar2250 0 1 Long description ITEM LONG_DESCRIPTION VARCHAR2 400 No long description of the item.
unit_of_measure varchar225 1 1 Unit of measure ITEM UNIT_OF_MEASURE VARCHAR2 4 Yes unit of measure which the stock for this item is tracked at the coporate level.
available_soh_qty number12_4 0 1 Available stock on hand quantity. STORE_ITEM_STOCK QUANTITY_RESERVED, QUANTITY_CUSTOMER_RESERVE, QUANTITY_NON_SELLABLE, QUANTITY_VENDOR_RETURN 12,4 NUMBER Yes available stock on hand quantity
diff_type1 varchar210 0 1 Item differentiator type 1. DIFFERENTIATOR_TYPE DESCRIPTION varchar2 255 Yes contains the diff type description.
diff_description1 varchar2255 0 1 Item differentiator type 1 description. DIFFERENTIATOR DESCRIPTION varchar2 255 Yes description of the differential number. (for example, blueberry, shower fresh, red, etc.)
diff_type2 varchar210 0 1 Item differentiator type 2. DIFFERENTIATOR_TYPE DESCRIPTION varchar2 255 Yes contains the diff type description.
diff_description2 varchar2255 0 1 Item differentiator type 2 description. DIFFERENTIATOR DESCRIPTION varchar2 255 Yes description of the differential number. (for example, blueberry, shower fresh, red, etc.)
diff_type3 varchar210 0 1 Item differentiator type 3. DIFFERENTIATOR_TYPE DESCRIPTION varchar2 255. Yes contains the diff type description.
diff_description3 varchar2255 0 1 Item differentiator type 3 description. DIFFERENTIATOR DESCRIPTION varchar2 255 Yes description of the differential number. (for example, blueberry, shower fresh, red, etc.)
diff_type4 varchar210 0 1 Item differentiator type 4. DIFFERENTIATOR_TYPE DESCRIPTION varchar2 255 Yes contains the diff type description.
diff_description4 varchar2255 0 1 Item differentiator type 4 description. DIFFERENTIATOR DESCRIPTION varchar2 255 Yes description of the differential number. (for example, blueberry, shower fresh, red, etc.)
effective_date xs:dateTime 0 1 The date this related item becomes effective. RELATED_ITEM EFFECTIVE_DATE date Fill column length. No Date from which this relationship is effective
end_date xs:dateTime 0 1 The date this related item is no longer effective. RELATED_ITEM END_DATE date Fill column length. No Date till when this relationship is effective
relationship_type varchar26 1 1 Relationship type RELATED_ITEM RELATIONSHIP_TYPE VARCHAR2 6 Yes Relationship type. valid values RLTD - Related, SUBS - Substitute, UPSL - Upsell, CSSL - Crosssell
mandatory_ind xs:boolean 1 1 Mandatory indicator RELATED_ITEM MANDATORY_IND VARCHAR2 1 Yes Fill this description.