Territory
Global dimensional table for Territory(dim_territory_gbl_DDS__v) sourced from Align.
| Global DDS Field | Field Type |
Source Data Connector: Global Table: territory_gbl_ods__v |
|---|---|---|
| dim_global_territory_id__v | bigint | |
| territory_name__v | varchar(384) | territory_name__v |
| territory_description__v | varchar(3000) | territory_description__v |
| territory_start_date__v | date | territory_start_date__v |
| territory_end_date__v | date | territory_end_date__v |
| vault_territory_id__v | varchar(18) | native_id__v |
| parent_territory_id__v | varchar(18) | parent_terrtory_id__v |
| parent_territory_name__v | varchar(384) | parent_territory_name__v |
| hierarchy_level__v | varchar(1280) | hierarchy_level__v |
| territory_external_id__v | varchar(360) | territory_external_id__v |
| start_date__v | date | start_date__v |
| end_date__v | date | end_date__v |
