DW_CXS_SALES_TERRITORY_D

Territory Extract Dimension

Details

Module:

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 This column is for Oracle Internal use only. 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.