Sales account hierarchy column flatten extract dimension
Module:
CF_TREE_NODE_ID, TREE_CODE, TREE_VERSION_ID, TREE_STRUCTURE_CODE
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 |
Copyright © 2019, 2023, Oracle and/or its affiliates.