Diff Group Head

This field will hold a unique number (identifier) for the differentiator group.

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 group (for example: Mens Shirt Sizes, Womens Shoe Sizes, Girls Dress Sizes, Shower Gel Scents, Yogurt Flavors, etc.).

Date/time stamp of when the record was created. This date/time will be used in export processing. This value should only be populated on insert - it should never be updated.

Holds the Oracle user-id of the user who most recently updated this record.

Holds the date time stamp of the most recent update by the last_update_id.

The ID of the organziational hierarchy to which the diff group is assigned. The level of the organziational hierarchy is determined based on SECURITY_CONFIG_OPTIONS.DIFF_GROUP_ORG_LEVEL_CODE. The value in this column will be used to control the Diff Groups a user can use when Diff Groups are utilized in RMS, if data level security has been set up for users in the system. This value is not required.

The ID of the merchandise hierarchy to which the diff group is assigned. The level of the merchandise hierarchy is determined based on SECURITY_CONFIG_OPTIONS.DIFF_GROUP_MERCH_LEVEL_CODE. The value in this column will be used to control the Diff Groups a user can use when Diff Groups are utilized in RMS, if data level security has been set up for users in the system. This value is not required.

If SECURITY_CONFIG_OPTIONS.DIFF_GROUP_MERCH_LEVEL_CODE is C (class) or S (subclass), then the FILTER_MERCH_ID column on this table will hold the department and the class associated with that department is held in this column.

If SECURITY_CONFIG_OPTIONS.DIFF_GROUP_MERCH_LEVEL_CODE is S (subclass), then the FILTER_MERCH_ID column on this table will hold the department, FILTER_MERCH_ID_CLASS will hold the class and the subclass associated with that department is held in this column.

This column holds the User id of the user who created the record.