DW_PURCHASING_CAT_HIERARCHY_D

purchasing category hierarchy dimension table

Details

Module: Purchasing

Key Columns

PURCHASING_CAT_TYPE, PURCHASING_CAT_ID

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