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 class or method |
---|---|---|
Create | POST /territories See Create |
CreateRequest or Create |
Delete | DELETE /territories(territoryid) See Delete |
DeleteRequest or Delete |
Retrieve | GET /territories(territoryid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /territories See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
Update | PATCH /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 the Territory_SyncErrors many-to-one relationship for the syncerror table/entity.
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 the Territory_AsyncOperations many-to-one relationship for the asyncoperation table/entity.
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 the territory_MailboxTrackingFolders many-to-one relationship for the mailboxtrackingfolder table/entity.
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 the Territory_ProcessSessions many-to-one relationship for the processsession table/entity.
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 the Territory_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure table/entity.
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 the territory_principalobjectattributeaccess many-to-one relationship for the principalobjectattributeaccess table/entity.
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 the territory_connections1 many-to-one relationship for the connection table/entity.
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 the territory_connections2 many-to-one relationship for the connection table/entity.
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 the territory_system_users many-to-one relationship for the systemuser table/entity.
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 the territory_parent_territory many-to-one relationship for the territory table/entity.
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 the lk_territorybase_createdby one-to-many relationship for the systemuser table/entity.
lk_territory_createdonbehalfby
Added by: System Solution Solution
See the lk_territory_createdonbehalfby one-to-many relationship for the systemuser table/entity.
lk_territorybase_modifiedby
Added by: System Solution Solution
See the lk_territorybase_modifiedby one-to-many relationship for the systemuser table/entity.
lk_territory_modifiedonbehalfby
Added by: System Solution Solution
See the lk_territory_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
organization_territories
Added by: System Solution Solution
See the organization_territories one-to-many relationship for the organization table/entity.
TransactionCurrency_Territory
Added by: System Solution Solution
See the TransactionCurrency_Territory one-to-many relationship for the transactioncurrency table/entity.
system_user_territories
Added by: System Solution Solution
See the system_user_territories one-to-many relationship for the systemuser table/entity.
territory_parent_territory
See the territory_parent_territory one-to-many relationship for the territory table/entity.
See also
Dataverse table/entity reference
Web API Reference
territory EntityType
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru