Sales partner hierarchy column flatten extract dimension
Module: Opportunity Management
TREE_VERSION_ID, TREE_STRUCTURE_CODE, 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 | 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, 2023, Oracle and/or its affiliates.