Retail Integration Mappings Report Release:16.0.030 (Retail Merchandising System)
Application Retail Merchandising System
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:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DiffDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
diff_id varchar210 1 1 This field will hold a unique number (identifier) of the differentiator. diff_ids diff_id varchar2 10 Yes Contains the code to uniquely identify a 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. diff_ids diff_type varchar2 6 Yes This field will hold a value of the types of differentiators contained in this differentiator group, such as S - size, C - color, F - flavor, E - scent, P - pattern. Valid values are stored in the DIFF_TYPE table.
diff_desc varchar2120 1 1 Not Yet Available diff_ids diff_desc varchar2 120 Yes Description of the differentiator (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. diff_ids industry_code varchar2 10 No Can be used to hold the unique code used by industry standards to identify the differentiator. For example, in the US, the National Retail Federation defines a standard Color and Size Codes that gives retailers, vendors and manufacturers a common language for product color and size identification for EDI purposes. This supplements the information conveyed by UPC codes. This columns holds the NRF code defined for size or color for example, mens pants size combination 32x32 has a NRF code number 10492.
industry_subcode varchar210 0 1 A unique number that represents all different color range groups. diff_ids industry_subgroup varchar2 10 No Can be used to hold a sub-grouping code used by industry standards to further identify the differentiator. For example, in the US, the National Retail Federation uses a subgroup for colors (e.g. purple is defined as 500; dark purple represents a range from 501 - 509, medium purple represents a range from 510 - 519, bright purple represents a range from 520 - 529, etc.).
diff_type_desc varchar2120 0 1 This field holds the description of the diff type. diff_type diff_type_desc varchar2 120 Yes Contains the description of the differentiator type.