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/DiffDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:DiffDesc 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 DiffDesc 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
diff_id varchar210 1 1 This field will hold a unique number (identifier) of the differentiator. DIFFERENTIATOR ID VARCHAR2 10 Yes This field will hold a unique number (identifier) of the differentiator.
diff_type varchar26 1 1 This field holds a value of all possible differential types. Valid values are stored in the code_detail table with the code_type of 'DIFF'. Valid values are also found in the diff_type table. DIFFERENTIATOR DIFF_TYPE_ID VARCHAR2 10 No This field holds a value of all possible differential types. Valid values are stored in the code_detail table with the code_type of 'DIFF'. Valid values are also found in the diff_type table.
diff_desc varchar2120 1 1 Not Yet Available DIFFERENTIATOR DESCRIPTION VARCHAR2 255 Yes description of the differential number. (for example, blueberry, shower fresh, red, etc.)
industry_code varchar210 0 1 A unique number that represents all possible combinations of sizes according to the National Retail Federation. Fill application table name. null varchar2 10 null Not used in SIM
industry_subcode varchar210 0 1 A unique number that represents all different color range groups. Fill application table name. null varchar2 10 null Not used in SIM