Territory Extract Dimension
Module: Opportunity Management
TERRITORY_VERSION_ID
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. |