This table holds purchasing taxonomy categories.
Module: Purchasing
CATEGORY_ID
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.