DW_CXS_SALES_ACCOUNT_CF_DN_DH

Sales account 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 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 This column is for Oracle Internal use only. 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