# 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, 2025, Oracle and/or its affiliates.