DW_CXS_OPPORTUNITY_PARTNER_CF_DN_DH

Sales partner hierarchy column flatten extract dimension

Details

Module:

Key Columns

TREE_STRUCTURE_CODE, TREE_VERSION_ID, TREE_CODE, CF_TREE_NODE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TREE_STRUCTURE_CODE VARCHAR2 32 True Marketing Opportunity Sales Territory Hierarchy Column Flatten Extract Id
TREE_CODE VARCHAR2 32 True Tree Code
TREE_VERSION_ID VARCHAR2 64 True Tree Version ID
CF_TREE_NODE_ID VARCHAR2 64 True Column Flatten Tree Node ID
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Source Record Id that is Unique
BASE_LEVEL_PARTNER_ID NUMBER 38 0 Partner Identifier at Base Level DW_CXS_PARTNER_D PARTNER_ID
LEVEL1_PARTNER_ID NUMBER 38 0 Partner Identifier at LEVEL1 DW_CXS_PARTNER_D PARTNER_ID
LEVEL2_PARTNER_ID NUMBER 38 0 Partner Identifier at LEVEL2 DW_CXS_PARTNER_D PARTNER_ID
LEVEL3_PARTNER_ID NUMBER 38 0 Partner Identifier at LEVEL3 DW_CXS_PARTNER_D PARTNER_ID
LEVEL4_PARTNER_ID NUMBER 38 0 Partner Identifier at LEVEL4 DW_CXS_PARTNER_D PARTNER_ID
LEVEL5_PARTNER_ID NUMBER 38 0 Partner Identifier at LEVEL5 DW_CXS_PARTNER_D PARTNER_ID
LEVEL6_PARTNER_ID NUMBER 38 0 Partner Identifier at LEVEL6 DW_CXS_PARTNER_D PARTNER_ID
LEVEL7_PARTNER_ID NUMBER 38 0 Partner Identifier at LEVEL7 DW_CXS_PARTNER_D PARTNER_ID
LEVEL8_PARTNER_ID NUMBER 38 0 Partner Identifier at LEVEL8 DW_CXS_PARTNER_D PARTNER_ID
TOP_LEVEL_PARTNER_ID NUMBER 38 0 Partner Identifier at Top Level DW_CXS_PARTNER_D PARTNER_ID
FIXED_HIERARCHY_LEVEL NUMBER 38 0 Fixed partner Hierarchy level
CREATION_DATE TIMESTAMP Creation date
LAST_UPDATE_DATE TIMESTAMP Last Update Date
BASE_LEVEL_PARTNER_NUMBER VARCHAR2 32 Partner Number for Partner at Base Level
LEVEL1_PARTNER_NUMBER VARCHAR2 32 Partner Number for Partner at LEVEL1
LEVEL2_PARTNER_NUMBER VARCHAR2 32 Partner Number for Partner at LEVEL2
LEVEL3_PARTNER_NUMBER VARCHAR2 32 Partner Number for Partner at LEVEL3
LEVEL4_PARTNER_NUMBER VARCHAR2 32 Partner Number for Partner at LEVEL4
LEVEL5_PARTNER_NUMBER VARCHAR2 32 Partner Number for Partner at LEVEL5
LEVEL6_PARTNER_NUMBER VARCHAR2 32 Partner Number for Partner at LEVEL6
LEVEL7_PARTNER_NUMBER VARCHAR2 32 Partner Number for Partner at LEVEL7
LEVEL8_PARTNER_NUMBER VARCHAR2 32 Partner Number for Partner at LEVEL8
TOP_LEVEL_PARTNER_NUMBER VARCHAR2 32 Partner Number for Partner at Top Level