DW_CXS_SALES_TERRITORY_D

Territory Extract Dimension

Details

Module: Opportunity Management

Key Columns

TERRITORY_VERSION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TERRITORY_VERSION_ID NUMBER 38 0 True Marketing Opportunity Sales Territory Version Id    
SOURCE_RECORD_ID VARCHAR2 64     Source Record Id that is Unique    
NAME VARCHAR2 64     Sales Territory Name    
OWNER_RESOURCE_ID NUMBER 38 0   Territory Owner Sales Resource Identifier DW_CXS_RESOURCE_D RESOURCE_ID
OWNER_RESOURCE_NAME VARCHAR2 512     Territory Owner Sales Resource name    
OWNER_RESOURCE_EMAIL VARCHAR2 512     Territory Owner Sales Resource email address    
TERRITORY_TYPE_CODE VARCHAR2 32     The code indicating the type of the territory. For example, PRIME or OVERLAY. A list of accepted values is defined in the lookup type MOT_TERRITORY_TYPE. DW_CXS_TERRITORY_TYPE_D_TL CODE
TERRITORY_ID NUMBER 38 0   Identifier of the Sales Territory    
STATUS_CODE VARCHAR2 32     Indicates the Status in which the Territory is. DW_CXS_TERRITORY_VERSION_STATUS_D_TL CODE
TERRITORY_NUMBER VARCHAR2 32     Identification number for this active territory    
COVERAGE_MODEL VARCHAR2 32     Identifies whether the territory dimensionality is based on sales account attributes or partner attributes. DW_CXS_TERRITORY_COVERAGE_MODEL_D_TL CODE
TERRITORY_EFFECTIVE_START_DATE DATE       Beginning of the date range where this row is Effective    
TERRITORY_EFFECTIVE_END_DATE DATE       End of the date range where this row is Effective    
PARENT_TERRITORY_ID NUMBER 38 0   Points to parent territory    
GROUPING_TERRITORY_FLAG VARCHAR2 16     Indicates whether the territory is a shell territory.    
ELIGIBLE_FOR_QUOTA_FLAG VARCHAR2 16     Indicates whether the territory is going to change during a territory realignment. If the value is True, then the territory is unlikely to change during a major realignment and therefore a quota can be entered for the proposed definition. The default value is Y.    
DESCRIPTION VARCHAR2 256     A brief description of the territory.    
TERRITORY_FUNCTION_CODE VARCHAR2 32     Indicates the function code in which the Territory is. DW_CXS_TERRITORY_FUNCTION_D_TL CODE
TERRITORY_LEVEL NUMBER 38 0   Level of Territory in Territory Hierarchy.