DW_CUSTOM2_CATEGORIES_DH

This table holds custom 2 taxonomy categories.

Details

Module: Purchasing

Key Columns

CATEGORY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CATEGORY_ID NUMBER 38 0 True Uniquely identifies the category.    
SOURCE_RECORD_ID NUMBER 38 0   This column is for Oracle Internal use only. System column    
TAXONOMY_ID NUMBER 38 0   Unique identifier of the taxonomy. DW_TAXONOMY_HEADER_D TAXONOMY_ID
SEGMENT1_CODE VARCHAR2 256     Taxonomy segment 1 code.    
SEGMENT1_DESCRIPTION VARCHAR2 999     Taxonomy segment 1 description.    
SEGMENT2_CODE VARCHAR2 256     Taxonomy segment 2 code.    
SEGMENT2_DESCRIPTION VARCHAR2 999     Taxonomy segment 2 description.    
SEGMENT3_CODE VARCHAR2 256     Taxonomy segment 3 code.    
SEGMENT3_DESCRIPTION VARCHAR2 999     Taxonomy segment 3 description.    
SEGMENT4_CODE VARCHAR2 256     Taxonomy segment 4 code.    
SEGMENT4_DESCRIPTION VARCHAR2 999     Taxonomy segment 4 description.    
SEGMENT5_CODE VARCHAR2 256     Taxonomy segment 5 code.    
SEGMENT5_DESCRIPTION VARCHAR2 999     Taxonomy segment 5 description.    
SEGMENT6_CODE VARCHAR2 256     Taxonomy segment 6 code.    
SEGMENT6_DESCRIPTION VARCHAR2 999     Taxonomy segment 6 description.    
SEGMENT7_CODE VARCHAR2 256     Taxonomy segment 7 code.    
SEGMENT7_DESCRIPTION VARCHAR2 999     Taxonomy segment 7 description.    
SEGMENT8_CODE VARCHAR2 256     Taxonomy segment 8 code.    
SEGMENT8_DESCRIPTION VARCHAR2 999     Taxonomy segment 8 description.    
SEGMENT9_CODE VARCHAR2 256     Taxonomy segment 9 code.    
SEGMENT9_DESCRIPTION VARCHAR2 999     Taxonomy segment 9 description.    

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