Sales partner 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 | 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 | This column is for Oracle Internal use only. 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 |
Copyright © 2019, 2025, Oracle and/or its affiliates.