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 | 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, 2023, Oracle and/or its affiliates.