Diff Ids

Contains the code to uniquely identify a differentiator.

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.

Description of the differentiator (for example, Blueberry, Shower Fresh, Red, etc.)

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.

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.).