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.