Referencia de tabla o entidad Territory
Nota
¿No está seguro de tabla frente a entidad? Vea Desarrolladores: comprender la terminología en Microsoft Dataverse.
Territory represents sales regions.
Añadido por: solución Application Common
Mensajes
| Mensaje | Operación de API web | Método o clase de SDK |
|---|---|---|
| Create | POST [org URI]/api/data/v9.0/territories Vea Crear |
CreateRequest o Create |
| CreateMultiple | CreateMultiple Action | CreateMultipleRequest |
| Delete | DELETE [org URI]/api/data/v9.0/territories(territoryid) Vea Eliminar |
DeleteRequest o Delete |
| Retrieve | GET [org URI]/api/data/v9.0/territories(territoryid) Vea Recuperar |
RetrieveRequest o Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/territories Vea Consultar datos |
RetrieveMultipleRequest o RetrieveMultiple |
| Update | PATCH [org URI]/api/data/v9.0/territories(territoryid) Vea Actualizar |
UpdateRequest o Update |
| UpdateMultiple | UpdateMultiple Action | UpdateMultipleRequest |
Propiedades
| Propiedad | Valor |
|---|---|
| CollectionSchemaName | Territories |
| DisplayCollectionName | Territories |
| DisplayName | Territory |
| EntitySetName | territories |
| IsBPFEntity | False |
| LogicalCollectionName | territories |
| LogicalName | territory |
| OwnershipType | OrganizationOwned |
| PrimaryIdAttribute | territoryid |
| PrimaryNameAttribute | name |
| SchemaName | Territory |
Columnas/atributos que se pueden escribir
Estas columnas o atributos devuelven true para IsValidForCreate o IsValidForUpdate (generalmente ambos). Listado por SchemaName.
- Description
- EntityImage
- ImportSequenceNumber
- ManagerId
- Name
- OverriddenCreatedOn
- ParentTerritoryId
- TerritoryId
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UTCConversionTimeZoneCode
Description
| Propiedad | Valor |
|---|---|
| Description | Description of the territory. |
| DisplayName | Description |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | description |
| MaxLength | 2000 |
| RequiredLevel | None |
| Type | Memo |
EntityImage
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| Description | Unique identifier of the manager of the territory. |
| DisplayName | Manager |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | managerid |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
Name
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución Second Patch for Application Common
| Propiedad | Valor |
|---|---|
| Description | Choose the parent for this territory. |
| DisplayName | Parent |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | parentterritoryid |
| RequiredLevel | None |
| Targets | territory |
| Type | Lookup |
TerritoryId
| Propiedad | Valor |
|---|---|
| Description | Unique identifier of the territory. |
| DisplayName | Territory |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | territoryid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
TimeZoneRuleVersionNumber
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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 |
Columnas/atributos de sólo lectura
Estas columnas o atributos devuelven false tanto para IsValidForCreate como para IsValidForUpdate. Listado por 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
EntityImage_Timestamp
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimage_timestamp |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
EntityImage_URL
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Url |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimage_url |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
EntityImageId
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimageid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
ExchangeRate
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | manageridname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ManagerIdYomiName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | manageridyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedBy
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OrganizationId
| Propiedad | Valor |
|---|---|
| Description | Unique identifier for the organization |
| DisplayName | Organization Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationid |
| RequiredLevel | SystemRequired |
| Targets | organization |
| Type | Lookup |
OrganizationIdName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationidname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
ParentTerritoryIdName
Añadido por: solución Second Patch for Application Common
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | parentterritoryidname |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
TransactionCurrencyIdName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | transactioncurrencyidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
VersionNumber
| Propiedad | Valor |
|---|---|
| Description | Version Number |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
Relaciones de uno a varios
Listado por 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
Añadido por: solución System Solution
Igual que la relación de varios a uno Territory_SyncErrors de la tabla syncerror.
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución System Solution
Igual que la relación de varios a uno Territory_AsyncOperations de la tabla asyncoperation.
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución System Solution
Igual que la relación de varios a uno territory_MailboxTrackingFolders de la tabla mailboxtrackingfolder.
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución System Solution
Igual que la relación de varios a uno Territory_ProcessSessions de la tabla processsession.
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución System Solution
Igual que la relación de varios a uno Territory_BulkDeleteFailures de la tabla bulkdeletefailure.
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución System Solution
Igual que la relación de varios a uno territory_principalobjectattributeaccess de la tabla principalobjectattributeaccess.
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución System Solution
Igual que la relación de varios a uno territory_connections1 de la tabla connection.
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución System Solution
Igual que la relación de varios a uno territory_connections2 de la tabla connection.
| Propiedad | Valor |
|---|---|
| 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
Igual que la relación de varios a uno territory_system_users de la tabla systemuser.
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución Second Patch for Application Common
Igual que la relación de varios a uno territory_parent_territory de la tabla territory.
| Propiedad | Valor |
|---|---|
| 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 |
Relaciones de varios a uno
Cada relación de varios a uno se define mediante una relación de uno a varios correspondiente con la tabla relacionada. Listado por 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
Añadido por: solución System Solution
Consulte la relación de uno a varios lk_territorybase_createdby de la tabla systemuser.
lk_territory_createdonbehalfby
Añadido por: solución System Solution
Consulte la relación de uno a varios lk_territory_createdonbehalfby de la tabla systemuser.
lk_territorybase_modifiedby
Añadido por: solución System Solution
Consulte la relación de uno a varios lk_territorybase_modifiedby de la tabla systemuser.
lk_territory_modifiedonbehalfby
Añadido por: solución System Solution
Consulte la relación de uno a varios lk_territory_modifiedonbehalfby de la tabla systemuser.
organization_territories
Añadido por: solución System Solution
Consulte la relación de uno a varios organization_territories de la tabla organization.
TransactionCurrency_Territory
Añadido por: solución System Solution
Consulte la relación de uno a varios TransactionCurrency_Territory de la tabla transactioncurrency.
system_user_territories
Añadido por: solución System Solution
Consulte la relación de uno a varios system_user_territories de la tabla systemuser.
territory_parent_territory
Consulte la relación de uno a varios territory_parent_territory de la tabla territory.
Consultar también
Referencia de tabla o entidad de Dataverse Referencia de la API web territory EntityType