DW_CXS_OPPORTUNITY_PARTNER_CF_DN_DH

Sales partner hierarchy column flatten extract dimension

Details

Module: Opportunity Management

Key Columns

TREE_STRUCTURE_CODE, TREE_CODE, CF_TREE_NODE_ID, TREE_VERSION_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     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