DW_PURCHASING_CAT_HIERARCHY_D
purchasing category hierarchy dimension table
Details
Module: Purchasing
Key Columns
PURCHASING_CAT_TYPE, PURCHASING_CAT_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PURCHASING_CAT_ID | NUMBER | 38 | 0 | True | Purchasing category ID | DW_ITEM_CATEGORIES_D | CATEGORY_ID |
| PURCHASING_CAT_TYPE | VARCHAR2 | 32 | True | Purchasing category Type | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Source record identifier. | ||||
| LEVEL1_CAT_ID | NUMBER | 38 | 0 | Level1 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID | |
| LEVEL2_CAT_ID | NUMBER | 38 | 0 | Level2 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID | |
| LEVEL3_CAT_ID | NUMBER | 38 | 0 | Level3 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID | |
| LEVEL4_CAT_ID | NUMBER | 38 | 0 | Level4 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID | |
| LEVEL5_CAT_ID | NUMBER | 38 | 0 | Level5 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID | |
| LEVEL6_CAT_ID | NUMBER | 38 | 0 | Level6 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID | |
| LEVEL7_CAT_ID | NUMBER | 38 | 0 | Level7 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID | |
| LEVEL8_CAT_ID | NUMBER | 38 | 0 | Level8 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID | |
| LEVEL9_CAT_ID | NUMBER | 38 | 0 | Level9 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID | |
| LEVEL10_CAT_ID | NUMBER | 38 | 0 | Level10 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID | |
| NODE_LEVEL | NUMBER | 38 | 0 | Node Level |