DW_CXS_PRODUCT_GROUP_D

This table contains information for product groups

Details

Module: Opportunity Management

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

Copyright © 2019, 2023, Oracle and/or its affiliates.