DW_CXS_SALES_TERRITORY_RF_DH

Row flattened territory hierarchy dimension

Details

Module:

Key Columns

TERRITORY_HIERARCHY_RF_DN_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TERRITORY_HIERARCHY_RF_DN_ID NUMBER 38 0 True Primary Key    
SOURCE_RECORD_ID VARCHAR2 256     System    
TERRITORY_VERSION_ID NUMBER 38 0   Territory version Identifier    
TERRITORY_ID NUMBER 38 0   Territory Identifier    
NAME VARCHAR2 64     Territory Name    
DESCENDANT_TERRITORY_VERSION_ID NUMBER 38 0   Child Territory Version Identifier    
DESCENDANT_TERRITORY_ID NUMBER 38 0   Child Territory Identifier    
DESCENDANT_NAME VARCHAR2 64     Child Territory Name    
CREATION_DATE TIMESTAMP       Indicates the date and time of the row creation.    
CREATED_BY VARCHAR2 64     Indicates the user who created the row.    
LAST_UPDATED_BY VARCHAR2 64     Indicates the user who last updated the row.    
LAST_UPDATE_DATE TIMESTAMP       Indicates the date and time of the last update of the row.    

Copyright © 2019, 2023, Oracle and/or its affiliates.