Referencia de tabla o entidad RollupField
Nota
¿No está seguro de tabla frente a entidad? Vea Desarrolladores: comprender la terminología en Microsoft Dataverse.
Field to be rolled up to calculate the actual and in-progress values against the goal.
Mensajes
Mensaje | Operación de API web | Método o clase de SDK |
---|---|---|
Create | POST [org URI]/api/data/v9.0/rollupfields Vea Crear |
CreateRequest o Create |
Delete | DELETE [org URI]/api/data/v9.0/rollupfields(rollupfieldid) Vea Eliminar |
DeleteRequest o Delete |
Retrieve | GET [org URI]/api/data/v9.0/rollupfields(rollupfieldid) Vea Recuperar |
RetrieveRequest o Retrieve |
RetrieveMultiple | GET [org URI]/api/data/v9.0/rollupfields Vea Consultar datos |
RetrieveMultipleRequest o RetrieveMultiple |
Update | PATCH [org URI]/api/data/v9.0/rollupfields(rollupfieldid) Vea Actualizar |
UpdateRequest o Update |
Propiedades
Propiedad | Valor |
---|---|
CollectionSchemaName | RollupFields |
DisplayCollectionName | Rollup Fields |
DisplayName | Rollup Field |
EntitySetName | rollupfields |
IsBPFEntity | False |
LogicalCollectionName | rollupfields |
LogicalName | rollupfield |
OwnershipType | None |
PrimaryIdAttribute | rollupfieldid |
PrimaryNameAttribute | |
SchemaName | RollupField |
Columnas/atributos que se pueden escribir
Estas columnas o atributos devuelven true para IsValidForCreate o IsValidForUpdate (generalmente ambos). Listado por SchemaName.
- DateAttribute
- EntityForDateAttribute
- GoalAttribute
- ImportSequenceNumber
- IsStateParentEntityAttribute
- MetricId
- RollupFieldId
- SourceAttribute
- SourceEntity
- SourceState
- SourceStatus
- TimeZoneRuleVersionNumber
- UTCConversionTimeZoneCode
DateAttribute
Propiedad | Valor |
---|---|
Description | Select a date field for the selected record type, such as Actual Closed Date for the Opportunity record type. A record participates in the goal rollup, if the selected date falls between the start date and the end date for the goal. |
DisplayName | Date Field |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | dateattribute |
MaxLength | 100 |
RequiredLevel | ApplicationRequired |
Type | String |
EntityForDateAttribute
Propiedad | Valor |
---|---|
Description | Select the record type that contains the date field that will be considered while rolling up data to the goal. |
DisplayName | Record Type |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | entityfordateattribute |
RequiredLevel | ApplicationRequired |
Type | EntityName |
GoalAttribute
Propiedad | Valor |
---|---|
Description | Select a rollup field where the metric rollup data will be displayed in the goal. The options are an integer or money, depending on the Metric Type you chose for the goal metric. |
DisplayName | Rollup Field |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | goalattribute |
MaxLength | 100 |
RequiredLevel | ApplicationRequired |
Type | String |
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 |
IsStateParentEntityAttribute
Propiedad | Valor |
---|---|
Description | Tells whether the state or status belongs to the parent entity. |
DisplayName | Is State/Status From Parent Entity |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | isstateparententityattribute |
RequiredLevel | None |
Type | Boolean |
Elecciones/opciones de IsStateParentEntityAttribute
Valor | Etiqueta | Descripción |
---|---|---|
1 | Yes | |
0 | No |
Valor predeterminado: 0
MetricId
Propiedad | Valor |
---|---|
Description | Unique identifier of the goal metric associated with the rollup field. |
DisplayName | Goal Metric |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | metricid |
RequiredLevel | ApplicationRequired |
Targets | metric |
Type | Lookup |
RollupFieldId
Propiedad | Valor |
---|---|
Description | Unique identifier of the rollup field. |
DisplayName | Rollup Field |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | rollupfieldid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
SourceAttribute
Propiedad | Valor |
---|---|
Description | Type the name of the field that the data for the goal rolls up from. |
DisplayName | Source Field |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | sourceattribute |
MaxLength | 100 |
RequiredLevel | ApplicationRequired |
Type | String |
SourceEntity
Propiedad | Valor |
---|---|
Description | Type the name of the record type (entity) that the data for the goal must roll up from. |
DisplayName | Source Record Type |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | sourceentity |
RequiredLevel | ApplicationRequired |
Type | EntityName |
SourceState
Propiedad | Valor |
---|---|
Description | Select the state of the records you want to use as the source of the rollup data for the metric. |
DisplayName | Source Record Type State |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | sourcestate |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
SourceStatus
Propiedad | Valor |
---|---|
Description | Select the status of the records you want to use as the source of the rollup data for the metric. |
DisplayName | Source Record Type Status |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | sourcestatus |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
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 |
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
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- MetricIdName
- ModifiedBy
- ModifiedByName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OrganizationId
- VersionNumber
CreatedBy
Propiedad | Valor |
---|---|
Description | Shows 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 |
CreatedOn
Propiedad | Valor |
---|---|
DateTimeBehavior | UserLocal |
Description | Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
DisplayName | Created On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
CreatedOnBehalfBy
Propiedad | Valor |
---|---|
Description | Shows who created the record on behalf of another user. |
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 |
MetricIdName
Propiedad | Valor |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | metricidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedBy
Propiedad | Valor |
---|---|
Description | Shows who last updated 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 |
ModifiedOn
Propiedad | Valor |
---|---|
DateTimeBehavior | UserLocal |
Description | Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
DisplayName | Modified On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
ModifiedOnBehalfBy
Propiedad | Valor |
---|---|
Description | Shows who last updated the record on behalf of another user. |
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 | None |
Type | String |
OrganizationId
Propiedad | Valor |
---|---|
Description | Choose the ID of the organization that the record is associated with. |
DisplayName | Organization Id |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | organizationid |
RequiredLevel | None |
Targets | |
Type | Lookup |
VersionNumber
Propiedad | Valor |
---|---|
Description | Version number of the rollup field. |
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.
rollupfield_ProcessSessions
Igual que la relación de varios a uno rollupfield_ProcessSessions de la tabla processsession.
Propiedad | Valor |
---|---|
ReferencingEntity | processsession |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | rollupfield_ProcessSessions |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
RollupField_SyncErrors
Igual que la relación de varios a uno RollupField_SyncErrors de la tabla syncerror.
Propiedad | Valor |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | RollupField_SyncErrors |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
rollupfield_AsyncOperations
Igual que la relación de varios a uno rollupfield_AsyncOperations de la tabla asyncoperation.
Propiedad | Valor |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | rollupfield_AsyncOperations |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade 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_rollupfield_createdby
- lk_rollupfield_createdonbehalfby
- lk_rollupfield_modifiedby
- lk_rollupfield_modifiedonbehalfby
- metric_rollupfield
lk_rollupfield_createdby
Consulte la relación de uno a varios lk_rollupfield_createdby de la tabla systemuser.
lk_rollupfield_createdonbehalfby
Consulte la relación de uno a varios lk_rollupfield_createdonbehalfby de la tabla systemuser.
lk_rollupfield_modifiedby
Consulte la relación de uno a varios lk_rollupfield_modifiedby de la tabla systemuser.
lk_rollupfield_modifiedonbehalfby
Consulte la relación de uno a varios lk_rollupfield_modifiedonbehalfby de la tabla systemuser.
metric_rollupfield
Consulte la relación de uno a varios metric_rollupfield de la tabla metric.
Consultar también
Referencia de tabla o entidad de Dataverse Referencia de la API web rollupfield EntityType