DW_CXS_SALES_ACCOUNT_CF_DN_DH

Sales account 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 Tree structure Code    
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 512     Source Record Id that is Unique    
BASE_LEVEL_ACCOUNT_PARTY_ID NUMBER 38 0   Account Identifier at Base Level DW_CXS_SALES_ACCOUNT_D PARTY_ID
LEVEL1_ACCOUNT_PARTY_ID NUMBER 38 0   Account Identifier at LEVEL1 DW_CXS_SALES_ACCOUNT_D PARTY_ID
LEVEL2_ACCOUNT_PARTY_ID NUMBER 38 0   Account Identifier at LEVEL2 DW_CXS_SALES_ACCOUNT_D PARTY_ID
LEVEL3_ACCOUNT_PARTY_ID NUMBER 38 0   Account Identifier at LEVEL3 DW_CXS_SALES_ACCOUNT_D PARTY_ID
LEVEL4_ACCOUNT_PARTY_ID NUMBER 38 0   Account Identifier at LEVEL4 DW_CXS_SALES_ACCOUNT_D PARTY_ID
LEVEL5_ACCOUNT_PARTY_ID NUMBER 38 0   Account Identifier at LEVEL5 DW_CXS_SALES_ACCOUNT_D PARTY_ID
LEVEL6_ACCOUNT_PARTY_ID NUMBER 38 0   Account Identifier at LEVEL6 DW_CXS_SALES_ACCOUNT_D PARTY_ID
LEVEL7_ACCOUNT_PARTY_ID NUMBER 38 0   Account Identifier at LEVEL7 DW_CXS_SALES_ACCOUNT_D PARTY_ID
LEVEL8_ACCOUNT_PARTY_ID NUMBER 38 0   Account Identifier at LEVEL8 DW_CXS_SALES_ACCOUNT_D PARTY_ID
TOP_LEVEL_ACCOUNT_PARTY_ID NUMBER 38 0   Account Identifier at Top Level DW_CXS_SALES_ACCOUNT_D PARTY_ID
FIXED_HIERARCHY_LEVEL NUMBER 38 0   Fixed Account Hierarchy level    
CREATION_DATE TIMESTAMP       Creation Date    
LAST_UPDATE_DATE TIMESTAMP       Last Update Date    
BASE_LEVEL_SALES_ACCOUNT_FLAG VARCHAR2 16     Sales account flag for account at Base Level    
LEVEL1_SALES_ACCOUNT_FLAG VARCHAR2 16     Sales account flag for account at LEVEL1    
LEVEL2_SALES_ACCOUNT_FLAG VARCHAR2 16     Sales account flag for account at LEVEL2    
LEVEL3_SALES_ACCOUNT_FLAG VARCHAR2 16     Sales account flag for account at LEVEL3    
LEVEL4_SALES_ACCOUNT_FLAG VARCHAR2 16     Sales account flag for account at LEVEL4    
LEVEL5_SALES_ACCOUNT_FLAG VARCHAR2 16     Sales account flag for account at LEVEL5    
LEVEL6_SALES_ACCOUNT_FLAG VARCHAR2 16     Sales account flag for account at LEVEL6    
LEVEL7_SALES_ACCOUNT_FLAG VARCHAR2 16     Sales account flag for account at LEVEL7    
LEVEL8_SALES_ACCOUNT_FLAG VARCHAR2 16     Sales account flag for account at LEVEL8    
TOP_LEVEL_SALES_ACCOUNT_FLAG VARCHAR2 16     Sales account flag for account at Top Level