purchasing category hierarchy dimension table
Module: Purchasing
PURCHASING_CAT_ID, PURCHASING_CAT_TYPE
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 | 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 |
Copyright © 2019, 2022, Oracle and/or its affiliates.