DW_CXS_PRODUCT_GROUP_D

This table contains information for product groups

Details

Module:

Key Columns

PRODUCT_GROUP_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PRODUCT_GROUP_ID NUMBER 38 0 True Product Group Identifier
SOURCE_RECORD_ID VARCHAR2 32 This column is for Oracle Internal use only. System generated
INTERNAL_NAME VARCHAR2 256 Internal name of the product group
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
ACTIVE_FLAG VARCHAR 16 Flag to indicate whether the related group relationship is active.
ALLOW_DUPLICATE_CONTENT_FLAG VARCHAR 16 Flag to determine whether a duplicate product/product group can be allowed in this product group hierarchy.
APPLY_ELIGIBILITY_COMPATIBILITY_RULE_FLG VARCHAR 16 Flag indicating whether or not to apply eligibility and compatibility rules to the product group.
USAGE_ROOT_FLAG VARCHAR 16 Flag to indicate that the product group can be assigned and displayed as a root product group in the context of an application usage type.
START_DATE TIMESTAMP Date from which the product group is active.
END_DATE TIMESTAMP Date after which the product group is not active.