Territory table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Territory represents sales regions.
Added by: Application Common Solution
Messages
| Message | Web API Operation | SDK Assembly |
|---|---|---|
| Create | POST [org URI]/api/data/v9.0/territories See Create |
CreateRequest or Create |
| Delete | DELETE [org URI]/api/data/v9.0/territories(territoryid) See Delete |
DeleteRequest or Delete |
| Retrieve | GET [org URI]/api/data/v9.0/territories(territoryid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/territories See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| Update | PATCH [org URI]/api/data/v9.0/territories(territoryid) See Update |
UpdateRequest or Update |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | Territories |
| DisplayCollectionName | Territories |
| DisplayName | Territory |
| EntitySetName | territories |
| IsBPFEntity | False |
| LogicalCollectionName | territories |
| LogicalName | territory |
| OwnershipType | OrganizationOwned |
| PrimaryIdAttribute | territoryid |
| PrimaryNameAttribute | name |
| SchemaName | Territory |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- Description
- EntityImage
- ImportSequenceNumber
- ManagerId
- Name
- OverriddenCreatedOn
- ParentTerritoryId
- TerritoryId
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UTCConversionTimeZoneCode
Description
| Property | Value |
|---|---|
| Description | Description of the territory. |
| DisplayName | Description |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | description |
| MaxLength | 2000 |
| RequiredLevel | None |
| Type | Memo |
EntityImage
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | The default image for the entity. |
| DisplayName | Entity Image |
| IsPrimaryImage | True |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimage |
| MaxHeight | 144 |
| MaxWidth | 144 |
| RequiredLevel | None |
| Type | Image |
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Sequence number of the import that created this record. |
| DisplayName | Import Sequence Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | importsequencenumber |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
ManagerId
| Property | Value |
|---|---|
| Description | Unique identifier of the manager of the territory. |
| DisplayName | Manager |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | managerid |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
Name
| Property | Value |
|---|---|
| Description | Name of the territory. |
| DisplayName | Territory Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | name |
| MaxLength | 200 |
| RequiredLevel | SystemRequired |
| Type | String |
OverriddenCreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time that the record was migrated. |
| DisplayName | Record Created On |
| Format | DateOnly |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | overriddencreatedon |
| RequiredLevel | None |
| Type | DateTime |
ParentTerritoryId
Added by: Second Patch for Application Common Solution
| Property | Value |
|---|---|
| Description | Choose the parent for this territory. |
| DisplayName | Parent |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | parentterritoryid |
| RequiredLevel | None |
| Targets | territory |
| Type | Lookup |
TerritoryId
| Property | Value |
|---|---|
| Description | Unique identifier of the territory. |
| DisplayName | Territory |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | territoryid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| MaxValue | 2147483647 |
| MinValue | -1 |
| RequiredLevel | None |
| Type | Integer |
TransactionCurrencyId
| Property | Value |
|---|---|
| Description | Unique identifier of the currency associated with the territory. |
| DisplayName | Currency |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | transactioncurrencyid |
| RequiredLevel | None |
| Targets | transactioncurrency |
| Type | Lookup |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| MaxValue | 2147483647 |
| MinValue | -1 |
| RequiredLevel | None |
| Type | Integer |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- EntityImage_Timestamp
- EntityImage_URL
- EntityImageId
- ExchangeRate
- ManagerIdName
- ManagerIdYomiName
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OrganizationId
- OrganizationIdName
- ParentTerritoryIdName
- TransactionCurrencyIdName
- VersionNumber
CreatedBy
| Property | Value |
|---|---|
| Description | Unique identifier of the user who created the territory. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the record was created. |
| DisplayName | Created On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
CreatedOnBehalfBy
| Property | Value |
|---|---|
| Description | Unique identifier of the delegate user who created the territory. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
EntityImage_Timestamp
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimage_timestamp |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
EntityImage_URL
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Url |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimage_url |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
EntityImageId
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimageid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
ExchangeRate
| Property | Value |
|---|---|
| Description | Exchange rate for the currency associated with the territory with respect to the base currency. |
| DisplayName | Exchange Rate |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | exchangerate |
| MaxValue | 100000000000 |
| MinValue | 0.000000000001 |
| Precision | 12 |
| RequiredLevel | None |
| Type | Decimal |
ManagerIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | manageridname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ManagerIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | manageridyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedBy
| Property | Value |
|---|---|
| Description | Unique identifier of the user who last modified the territory. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the record was modified. |
| DisplayName | Modified On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | Unique identifier of the delegate user who last modified the territory. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OrganizationId
| Property | Value |
|---|---|
| Description | Unique identifier for the organization |
| DisplayName | Organization Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationid |
| RequiredLevel | SystemRequired |
| Targets | organization |
| Type | Lookup |
OrganizationIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationidname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
ParentTerritoryIdName
Added by: Second Patch for Application Common Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | parentterritoryidname |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
TransactionCurrencyIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | transactioncurrencyidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
VersionNumber
| Property | Value |
|---|---|
| Description | Version Number |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
- Territory_SyncErrors
- Territory_AsyncOperations
- territory_MailboxTrackingFolders
- Territory_ProcessSessions
- Territory_BulkDeleteFailures
- territory_principalobjectattributeaccess
- territory_connections1
- territory_connections2
- territory_system_users
- territory_parent_territory
Territory_SyncErrors
Added by: System Solution Solution
Same as syncerror table Territory_SyncErrors Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Territory_SyncErrors |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Territory_AsyncOperations
Added by: System Solution Solution
Same as asyncoperation table Territory_AsyncOperations Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Territory_AsyncOperations |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
territory_MailboxTrackingFolders
Added by: System Solution Solution
Same as mailboxtrackingfolder table territory_MailboxTrackingFolders Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | mailboxtrackingfolder |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | territory_MailboxTrackingFolders |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Territory_ProcessSessions
Added by: System Solution Solution
Same as processsession table Territory_ProcessSessions Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | processsession |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Territory_ProcessSessions |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Territory_BulkDeleteFailures
Added by: System Solution Solution
Same as bulkdeletefailure table Territory_BulkDeleteFailures Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Territory_BulkDeleteFailures |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
territory_principalobjectattributeaccess
Added by: System Solution Solution
Same as principalobjectattributeaccess table territory_principalobjectattributeaccess Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | territory_principalobjectattributeaccess |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
territory_connections1
Added by: System Solution Solution
Same as connection table territory_connections1 Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | connection |
| ReferencingAttribute | record1id |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | territory_connections1 |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 100 |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
territory_connections2
Added by: System Solution Solution
Same as connection table territory_connections2 Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | connection |
| ReferencingAttribute | record2id |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | territory_connections2 |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
territory_system_users
Same as systemuser table territory_system_users Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | systemuser |
| ReferencingAttribute | territoryid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | territory_system_users |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
territory_parent_territory
Added by: Second Patch for Application Common Solution
Same as territory table territory_parent_territory Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | territory |
| ReferencingAttribute | parentterritoryid |
| IsHierarchical | True |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | territory_parent_territory |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- lk_territorybase_createdby
- lk_territory_createdonbehalfby
- lk_territorybase_modifiedby
- lk_territory_modifiedonbehalfby
- organization_territories
- TransactionCurrency_Territory
- system_user_territories
- territory_parent_territory
lk_territorybase_createdby
Added by: System Solution Solution
See systemuser Table lk_territorybase_createdby One-To-Many relationship.
lk_territory_createdonbehalfby
Added by: System Solution Solution
See systemuser Table lk_territory_createdonbehalfby One-To-Many relationship.
lk_territorybase_modifiedby
Added by: System Solution Solution
See systemuser Table lk_territorybase_modifiedby One-To-Many relationship.
lk_territory_modifiedonbehalfby
Added by: System Solution Solution
See systemuser Table lk_territory_modifiedonbehalfby One-To-Many relationship.
organization_territories
Added by: System Solution Solution
See organization Table organization_territories One-To-Many relationship.
TransactionCurrency_Territory
Added by: System Solution Solution
See transactioncurrency Table TransactionCurrency_Territory One-To-Many relationship.
system_user_territories
Added by: System Solution Solution
See systemuser Table system_user_territories One-To-Many relationship.
territory_parent_territory
See territory Table territory_parent_territory One-To-Many relationship.
See also
About the table reference
Web API Reference
territory EntityType