Referencia de tabla o entidad Category
Nota
¿No está seguro de tabla frente a entidad? Vea Desarrolladores: comprender la terminología en Microsoft Dataverse.
Entity for categorizing records to make it easier for your customers to find them on portals and through search.
Mensajes
| Mensaje | Operación de API web | Método o clase de SDK |
|---|---|---|
| Assign | PATCH [org URI]/api/data/v9.0/categories(categoryid) Actualizar propiedad ownerid. |
AssignRequest |
| Create | POST [org URI]/api/data/v9.0/categories Vea Crear |
CreateRequest o Create |
| Delete | DELETE [org URI]/api/data/v9.0/categories(categoryid) Vea Eliminar |
DeleteRequest o Delete |
| GrantAccess | GrantAccess Action | GrantAccessRequest |
| Retrieve | GET [org URI]/api/data/v9.0/categories(categoryid) Vea Recuperar |
RetrieveRequest o Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/categories Vea Consultar datos |
RetrieveMultipleRequest o RetrieveMultiple |
| RetrievePrincipalAccess | RetrievePrincipalAccess Function | RetrievePrincipalAccessRequest |
| RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess Function | RetrieveSharedPrincipalsAndAccessRequest |
| RevokeAccess | RevokeAccess Action | RevokeAccessRequest |
| Update | PATCH [org URI]/api/data/v9.0/categories(categoryid) Vea Actualizar |
UpdateRequest o Update |
Propiedades
| Propiedad | Valor |
|---|---|
| CollectionSchemaName | Categories |
| DisplayCollectionName | Categories |
| DisplayName | Category |
| EntitySetName | categories |
| IsBPFEntity | False |
| LogicalCollectionName | categories |
| LogicalName | category |
| OwnershipType | UserOwned |
| PrimaryIdAttribute | categoryid |
| PrimaryNameAttribute | title |
| SchemaName | Category |
Columnas/atributos que se pueden escribir
Estas columnas o atributos devuelven true para IsValidForCreate o IsValidForUpdate (generalmente ambos). Listado por SchemaName.
- CategoryId
- CategoryNumber
- Description
- ImportSequenceNumber
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- ParentCategoryId
- SequenceNumber
- Title
- TransactionCurrencyId
CategoryId
| Propiedad | Valor |
|---|---|
| Description | Shows the category. |
| DisplayName | Category ID |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | categoryid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
CategoryNumber
| Propiedad | Valor |
|---|---|
| Description | Shows the category number for customer reference. |
| DisplayName | Category Number |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | categorynumber |
| MaxLength | 4000 |
| RequiredLevel | SystemRequired |
| Type | String |
Description
| Propiedad | Valor |
|---|---|
| Description | Type a detailed description of the category |
| DisplayName | Description |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | description |
| MaxLength | 2000 |
| RequiredLevel | None |
| Type | Memo |
ImportSequenceNumber
| Propiedad | Valor |
|---|---|
| Description | Unique identifier of the data import or data migration 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 |
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 |
OwnerId
| Propiedad | Valor |
|---|---|
| Description | Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. |
| DisplayName | Owner |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Targets | systemuser,team |
| Type | Owner |
OwnerIdType
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
ParentCategoryId
| Propiedad | Valor |
|---|---|
| Description | Select an existing category article for the category. |
| DisplayName | Parent Category |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | parentcategoryid |
| RequiredLevel | None |
| Targets | category |
| Type | Lookup |
SequenceNumber
| Propiedad | Valor |
|---|---|
| Description | Enter a number to define the display position of the category in the hierarchy. |
| DisplayName | Display Order |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | sequencenumber |
| MaxValue | 2147483647 |
| MinValue | 0 |
| RequiredLevel | None |
| Type | Integer |
Title
| Propiedad | Valor |
|---|---|
| Description | Type a title for the Category. |
| DisplayName | Title |
| FormatName | Text |
| IsLocalizable | True |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | title |
| MaxLength | 155 |
| RequiredLevel | SystemRequired |
| Type | String |
TransactionCurrencyId
| Propiedad | Valor |
|---|---|
| Description | Choose the local currency for the record to make sure budgets are reported in the correct currency. |
| DisplayName | Currency |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | transactioncurrencyid |
| RequiredLevel | None |
| Targets | transactioncurrency |
| Type | Lookup |
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
- ExchangeRate
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OwnerIdName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- ParentCategoryIdName
- TransactionCurrencyIdName
- VersionNumber
CreatedBy
| Propiedad | Valor |
|---|---|
| Description | Unique identifier of the user who created the record. |
| 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 | SystemRequired |
| Type | String |
CreatedOn
| Propiedad | Valor |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the record was created. |
| DisplayName | Record 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 record. |
| 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 | SystemRequired |
| Type | String |
ExchangeRate
| Propiedad | Valor |
|---|---|
| Description | Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency. |
| DisplayName | Exchange Rate |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | exchangerate |
| MaxValue | 100000000000 |
| MinValue | 0.000000000001 |
| Precision | 12 |
| RequiredLevel | None |
| Type | Decimal |
ModifiedBy
| Propiedad | Valor |
|---|---|
| Description | Unique identifier of the user who modified the record. |
| 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 | SystemRequired |
| 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 modified the record. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | True |
| 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 | SystemRequired |
| Type | String |
OwnerIdName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwningBusinessUnit
| Propiedad | Valor |
|---|---|
| Description | Shows the business unit that the record owner belongs to. |
| DisplayName | Owning Business Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Targets | businessunit |
| Type | Lookup |
OwningBusinessUnitName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunitname |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
OwningTeam
| Propiedad | Valor |
|---|---|
| Description | Unique identifier of the team who owns the category. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Targets | team |
| Type | Lookup |
OwningUser
| Propiedad | Valor |
|---|---|
| Description | Unique identifier of the user who owns this category. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ParentCategoryIdName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | parentcategoryidname |
| MaxLength | 100 |
| 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 | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
Relaciones de uno a varios
Listado por SchemaName.
category_parent_category
Igual que la relación de varios a uno category_parent_category de la tabla category.
| Propiedad | Valor |
|---|---|
| ReferencingEntity | category |
| ReferencingAttribute | parentcategoryid |
| IsHierarchical | True |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | category_parent_category |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10 |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Category_SyncErrors
Igual que la relación de varios a uno Category_SyncErrors de la tabla syncerror.
| Propiedad | Valor |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Category_SyncErrors |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
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.
- category_parent_category
- lk_category_createdonbehalfby
- transactioncurrency_category
- lk_category_createdby
- lk_category_modifiedonbehalfby
- lk_category_modifiedby
- business_unit_category
category_parent_category
Consulte la relación de uno a varios category_parent_category de la tabla category.
lk_category_createdonbehalfby
Consulte la relación de uno a varios lk_category_createdonbehalfby de la tabla systemuser.
transactioncurrency_category
Consulte la relación de uno a varios transactioncurrency_category de la tabla transactioncurrency.
lk_category_createdby
Consulte la relación de uno a varios lk_category_createdby de la tabla systemuser.
lk_category_modifiedonbehalfby
Consulte la relación de uno a varios lk_category_modifiedonbehalfby de la tabla systemuser.
lk_category_modifiedby
Consulte la relación de uno a varios lk_category_modifiedby de la tabla systemuser.
business_unit_category
Consulte la relación de uno a varios business_unit_category de la tabla businessunit.
Relaciones de varios a varios
Los detalles de la relación proporcionados cuando la tabla Category es la primera tabla de la relación. Listado por SchemaName.
knowledgearticle_category
Consulte la relación de varios a varios knowledgearticle_category de la tabla knowledgearticle.
Consultar también
Referencia de tabla o entidad de Dataverse Referencia de la API web category EntityType