Territory Hierarchy Column Flatten Extract Dimension
Module:
TERRITORY_HIERARCHY_CF_DN_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| TERRITORY_HIERARCHY_CF_DN_ID | NUMBER | 38 | 0 | True | Marketing Opportunity Sales Territory Hierarchy Column Flatten Extract Id | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Source Record Id that is Unique | ||||
| BASE_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at base level | |||
| BASE_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at base level | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| CREATED_BY | VARCHAR2 | 64 | indicates the user who created the row. | ||||
| CREATION_DATE | TIMESTAMP | indicates the date and time of the row creation. | |||||
| CURRENT_FLAG | VARCHAR2 | 32 | Current Flag | ||||
| FIXED_HIERARCHY_LEVEL | NUMBER | 38 | 0 | Fixed Territory Hierarchy Level | |||
| TERRITORY_HIERARCHY_END_DATE | TIMESTAMP | Territory Hierarchy End Date | |||||
| TERRITORY_HIERARCHY_START_DATE | TIMESTAMP | Territory Hierarchy Start Date | |||||
| LAST_REFRESH_DATE | TIMESTAMP | Last Refresh Date of Territory Hierarchy | |||||
| LAST_UPDATE_DATE | TIMESTAMP | indicates the date and time of the last update of the row. | |||||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Indicates the session login associated to the user who last updated the row. | ||||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Iindicates the user who last updated the row. | ||||
| LEVEL1_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 2 | |||
| LEVEL1_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 2 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL2_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 3 | |||
| LEVEL2_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 3 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL3_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 4 | |||
| LEVEL3_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 4 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL4_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 5 | |||
| LEVEL4_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 5 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL5_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 6 | |||
| LEVEL5_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 6 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL6_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 7 | |||
| LEVEL6_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 7 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL7_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 8 | |||
| LEVEL7_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 8 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL8_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 9 | |||
| LEVEL8_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 9 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL9_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 10 | |||
| LEVEL9_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 10 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL10_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 11 | |||
| LEVEL10_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 11 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL11_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 12 | |||
| LEVEL11_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 12 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL12_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 13 | |||
| LEVEL12_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 13 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL13_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 14 | |||
| LEVEL13_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 14 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL14_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 15 | |||
| LEVEL14_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 15 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL15_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 16 | |||
| LEVEL15_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 16 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| LEVEL16_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at level 17 | |||
| LEVEL16_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at level 17 | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
| TOP_LEVEL_TERRITORY_ID | NUMBER | 38 | 0 | Identifier of territory at top level | |||
| TOP_LEVEL_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Identifier of territory version at top level | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID |
Copyright © 2019, 2025, Oracle and/or its affiliates.