Retail Integration Mappings Report Release:16.0.21 (BDI Retail Merchandising System)
Application BDI Retail Merchandising System
Target Name Space http://www.oracle.com/retail/integration/bdi/bdi-interface-module
Version 1.1
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:Diff 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 Diff in BDI-RMS application.
BDI-RMS's Table Name BDI-RMS's Column Name Integration API(RIB or/and RSB or/and RSL) BDI-RMS's Column Length Is Column Required in BDI-RMS's API? BDI-RMS's API Description
diff_id varchar210 1 1 Contains the unique ID of the diff. Data will always be present in this field. DIFF_IDS DIFF_ID VARCHAR2 10 Yes Contains the unique ID of the diff. Data will always be present in this field.
diff_desc varchar2120 1 1 Contains the type code for the diff. All diffs belong to one any only one type. DIFF_IDS DIFF_DESC VARCHAR2 120 Yes Contains the type code for the diff. All diffs belong to one any only one type.
diff_type varchar26 1 1 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_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_type_desc varchar2120 1 1 Contains the description of the diff. Data will always exist in this field. DIFF_TYPE DIFF_TYPE_DESC VARCHAR2 120 Yes Contains the description of the diff. Data will always exist in this field.
industry_code varchar210 0 1 Optionally can 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. For example, mens pants size combination 32x32 has a NRF code number 10492. DIFF_IDS INDUSTRY_CODE VARCHAR2 10 No Optionally can 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. For example, mens pants size combination 32x32 has a NRF code number 10492.
industry_subgroup varchar210 0 1 Optionally can hold a sub-grouping code used by industry standards to further identify the differentiator. For example, in the US, the National 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_IDS INDUSTRY_SUBGROUP VARCHAR2 10 No Optionally can hold a sub-grouping code used by industry standards to further identify the differentiator. For example, in the US, the National 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.).