RollupField テーブル/エンティティの参照
注意
テーブルとエンティティの違いについて不明な点がありますか? 開発者: Microsoft Dataverse の用語を理解するを参照してください。
Field to be rolled up to calculate the actual and in-progress values against the goal.
メッセージ
| メッセージ | Web API 操作 | SDK クラスまたはメソッド |
|---|---|---|
| Create | POST [org URI]/api/data/v9.0/rollupfields 作成を参照 |
CreateRequest または Create |
| Delete | DELETE [org URI]/api/data/v9.0/rollupfields(rollupfieldid) 削除を参照 |
DeleteRequest または Delete |
| Retrieve | GET [org URI]/api/data/v9.0/rollupfields(rollupfieldid) 取得を参照 |
RetrieveRequest または Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/rollupfields データのクエリを参照 |
RetrieveMultipleRequest または RetrieveMultiple |
| Update | PATCH [org URI]/api/data/v9.0/rollupfields(rollupfieldid) 更新を参照 |
UpdateRequest または Update |
プロパティ
| プロパティ | 値 |
|---|---|
| CollectionSchemaName | RollupFields |
| DisplayCollectionName | Rollup Fields |
| DisplayName | Rollup Field |
| EntitySetName | rollupfields |
| IsBPFEntity | False |
| LogicalCollectionName | rollupfields |
| LogicalName | rollupfield |
| OwnershipType | None |
| PrimaryIdAttribute | rollupfieldid |
| PrimaryNameAttribute | |
| SchemaName | RollupField |
書き込み可能な列/属性
これらの列/属性は IsValidForCreate または IsValidForUpdate のいずれかについて true を返します (通常は両方)。 SchemaName が一覧表示。
- DateAttribute
- EntityForDateAttribute
- GoalAttribute
- ImportSequenceNumber
- IsStateParentEntityAttribute
- MetricId
- RollupFieldId
- SourceAttribute
- SourceEntity
- SourceState
- SourceStatus
- TimeZoneRuleVersionNumber
- UTCConversionTimeZoneCode
DateAttribute
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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 |
IsStateParentEntityAttribute の選択肢/オプション
| 値 | ラベル | 内容 |
|---|---|---|
| 1 | Yes | |
| 0 | No |
既定値 : 0
MetricId
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | Unique identifier of the rollup field. |
| DisplayName | Rollup Field |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | rollupfieldid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
SourceAttribute
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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 |
読み取り専用列/属性
これらの列/属性は IsValidForCreate または IsValidForUpdate の両方について false を返します。 SchemaName が一覧表示。
- CreatedBy
- CreatedByName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- MetricIdName
- ModifiedBy
- ModifiedByName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OrganizationId
- VersionNumber
CreatedBy
| プロパティ | 値 |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
MetricIdName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | metricidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedBy
| プロパティ | 値 |
|---|---|
| Description | Shows who last updated the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OrganizationId
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | Version number of the rollup field. |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
一対多関連付け
SchemaName が一覧表示。
rollupfield_ProcessSessions
processsession テーブル/エンティティの多対一のリレーションシップ rollupfield_ProcessSessions と同じです。
| プロパティ | 値 |
|---|---|
| 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
syncerror テーブル/エンティティの多対一のリレーションシップ RollupField_SyncErrors と同じです。
| プロパティ | 値 |
|---|---|
| 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
asyncoperation テーブル/エンティティの多対一のリレーションシップ rollupfield_AsyncOperations と同じです。
| プロパティ | 値 |
|---|---|
| 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 |
多対一関連付け
各多対一の関係付けは、関連するテーブルとの対応する一対多の関係付けによって定義されます。 SchemaName が一覧表示。
- lk_rollupfield_createdby
- lk_rollupfield_createdonbehalfby
- lk_rollupfield_modifiedby
- lk_rollupfield_modifiedonbehalfby
- metric_rollupfield
lk_rollupfield_createdby
systemuser テーブル/エンティティの一対多のリレーションシップ lk_rollupfield_createdby を参照してください。
lk_rollupfield_createdonbehalfby
systemuser テーブル/エンティティの一対多のリレーションシップ lk_rollupfield_createdonbehalfby を参照してください。
lk_rollupfield_modifiedby
systemuser テーブル/エンティティの一対多のリレーションシップ lk_rollupfield_modifiedby を参照してください。
lk_rollupfield_modifiedonbehalfby
systemuser テーブル/エンティティの一対多のリレーションシップ lk_rollupfield_modifiedonbehalfby を参照してください。
metric_rollupfield
metric テーブル/エンティティの一対多のリレーションシップ metric_rollupfield を参照してください。
関連項目
Dataverse テーブル/エンティティ参照 Web API リファレンス rollupfield EntityType