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