DW_PURCHASING_CAT_HIERARCHY_D

purchasing category hierarchy dimension table

Details

Module: Purchasing

Key Columns

PURCHASING_CAT_ID, PURCHASING_CAT_TYPE

Columns

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     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.