次の方法で共有


Goal テーブル/エンティティの参照

注意

テーブルとエンティティの違いについて不明な点がありますか? 開発者: Microsoft Dataverse の用語を理解するを参照してください。

Target objective for a user or a team for a specified time period.

メッセージ

メッセージ Web API 操作 SDK クラスまたはメソッド
Assign PATCH [org URI]/api/data/v9.0/goals(goalid)
owneridのプロパティを更新する。
AssignRequest
Create POST [org URI]/api/data/v9.0/goals
作成を参照
CreateRequest または
Create
Delete DELETE [org URI]/api/data/v9.0/goals(goalid)
削除を参照
DeleteRequest または
Delete
GrantAccess GrantAccess Action GrantAccessRequest
ModifyAccess ModifyAccess Action ModifyAccessRequest
Recalculate Recalculate Action RecalculateRequest
Retrieve GET [org URI]/api/data/v9.0/goals(goalid)
取得を参照
RetrieveRequest または
Retrieve
RetrieveMultiple GET [org URI]/api/data/v9.0/goals
データのクエリを参照
RetrieveMultipleRequest または
RetrieveMultiple
RetrievePrincipalAccess RetrievePrincipalAccess Function RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccess Function RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess RevokeAccess Action RevokeAccessRequest
SetState PATCH [org URI]/api/data/v9.0/goals(goalid)
statecodestatuscode のプロパティを更新する。
SetStateRequest
Update PATCH [org URI]/api/data/v9.0/goals(goalid)
更新を参照
UpdateRequest または
Update

プロパティ

プロパティ
CollectionSchemaName Goals
DisplayCollectionName Goals
DisplayName Goal
EntitySetName goals
IsBPFEntity False
LogicalCollectionName goals
LogicalName goal
OwnershipType UserOwned
PrimaryIdAttribute goalid
PrimaryNameAttribute title
SchemaName Goal

書き込み可能な列/属性

これらの列/属性は IsValidForCreate または IsValidForUpdate のいずれかについて true を返します (通常は両方)。 SchemaName が一覧表示。

ActualDecimal

プロパティ
Description Shows the actual value (Decimal type) achieved towards the target as of the last rolled-up date. This field appears when the metric type of the goal is Amount and the amount data type is Decimal.
DisplayName Actual (Decimal)
IsValidForForm True
IsValidForRead True
LogicalName actualdecimal
MaxValue 100000000000
MinValue -100000000000
Precision 10
RequiredLevel None
Type Decimal

ActualInteger

プロパティ
Description Shows the actual value (integer) achieved towards the target as of the last rolled-up date. This field appears when the metric type of the goal is Amount or Count and the amount data type is Integer.
DisplayName Actual (Integer)
Format None
IsValidForForm True
IsValidForRead True
LogicalName actualinteger
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

ActualMoney

プロパティ
Description Shows the actual value (Money type) achieved towards the target as of the last rolled-up date. This field appears when the metric type of the goal is Amount and the amount data type is Money.
DisplayName Actual (Money)
IsValidForForm True
IsValidForRead True
LogicalName actualmoney
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

AmountDataType

プロパティ
Description Data type of the amount.
DisplayName Amount Data Type
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName amountdatatype
RequiredLevel None
Type Picklist

AmountDataType の選択肢/オプション

ラベル 内容
0 Money
1 Decimal
2 Integer

ConsiderOnlyGoalOwnersRecords

プロパティ
Description Select whether only the goal owner's records, or all records, should be rolled up for goal results.
DisplayName Record Set for Rollup
IsValidForForm True
IsValidForRead True
LogicalName consideronlygoalownersrecords
RequiredLevel SystemRequired
Type Boolean

ConsiderOnlyGoalOwnersRecords の選択肢/オプション

ラベル 内容
1 Owned by goal owner
0 All

既定値 : 1

CustomRollupFieldDecimal

プロパティ
Description Indicates a placeholder rollup field for a decimal value to track a third category of results other than actuals and in-progress results.
DisplayName Custom Rollup Field (Decimal)
IsValidForForm True
IsValidForRead True
LogicalName customrollupfielddecimal
MaxValue 100000000000
MinValue -100000000000
Precision 10
RequiredLevel None
Type Decimal

CustomRollupFieldInteger

プロパティ
Description Indicates a placeholder rollup field for an integer value to track a third category of results other than actuals and in-progress results.
DisplayName Custom Rollup Field (Integer)
Format None
IsValidForForm True
IsValidForRead True
LogicalName customrollupfieldinteger
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

CustomRollupFieldMoney

プロパティ
Description Indicates a placeholder rollup field for a money value to track a third category of results other than actuals and in-progress results.
DisplayName Custom Rollup Field (Money)
IsValidForForm True
IsValidForRead True
LogicalName customrollupfieldmoney
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

EntityImage

プロパティ
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

FiscalPeriod

プロパティ
Description Select the fiscal period for the goal.
DisplayName Fiscal Period
IsValidForForm True
IsValidForRead True
LogicalName fiscalperiod
RequiredLevel None
Type Picklist

FiscalPeriod の選択肢/オプション

ラベル 内容
1 Quarter 1
2 Quarter 2
3 Quarter 3
4 Quarter 4
101 January
102 February
103 March
104 April
105 May
106 June
107 July
108 August
109 September
110 October
111 November
112 December
201 Semester 1
202 Semester 2
301 Annual
401 P1
402 P2
403 P3
404 P4
405 P5
406 P6
407 P7
408 P8
409 P9
410 P10
411 P11
412 P12
413 P13

FiscalYear

プロパティ
Description Select the fiscal year for the goal that's being tracked.
DisplayName Fiscal Year
IsValidForForm True
IsValidForRead True
LogicalName fiscalyear
RequiredLevel None
Type Picklist

FiscalYear の選択肢/オプション

ラベル 内容
1970 FY1970
1971 FY1971
1972 FY1972
1973 FY1973
1974 FY1974
1975 FY1975
1976 FY1976
1977 FY1977
1978 FY1978
1979 FY1979
1980 FY1980
1981 FY1981
1982 FY1982
1983 FY1983
1984 FY1984
1985 FY1985
1986 FY1986
1987 FY1987
1988 FY1988
1989 FY1989
1990 FY1990
1991 FY1991
1992 FY1992
1993 FY1993
1994 FY1994
1995 FY1995
1996 FY1996
1997 FY1997
1998 FY1998
1999 FY1999
2000 FY2000
2001 FY2001
2002 FY2002
2003 FY2003
2004 FY2004
2005 FY2005
2006 FY2006
2007 FY2007
2008 FY2008
2009 FY2009
2010 FY2010
2011 FY2011
2012 FY2012
2013 FY2013
2014 FY2014
2015 FY2015
2016 FY2016
2017 FY2017
2018 FY2018
2019 FY2019
2020 FY2020
2021 FY2021
2022 FY2022
2023 FY2023
2024 FY2024
2025 FY2025
2026 FY2026
2027 FY2027
2028 FY2028
2029 FY2029
2030 FY2030
2031 FY2031
2032 FY2032
2033 FY2033
2034 FY2034
2035 FY2035
2036 FY2036
2037 FY2037
2038 FY2038

GoalEndDate

プロパティ
DateTimeBehavior UserLocal
Description Enter the date when the goal ends.
DisplayName To
Format DateOnly
IsValidForForm True
IsValidForRead True
LogicalName goalenddate
RequiredLevel None
Type DateTime

GoalId

プロパティ
Description Unique identifier of the goal.
DisplayName Goal
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName goalid
RequiredLevel SystemRequired
Type Uniqueidentifier

GoalOwnerId

プロパティ
Description Choose the user or team responsible for meeting the goal.
DisplayName Goal Owner
IsValidForForm True
IsValidForRead True
LogicalName goalownerid
RequiredLevel ApplicationRequired
Targets systemuser,team
Type Lookup

GoalOwnerIdType

プロパティ
Description
DisplayName Goal Owner Type
IsValidForForm False
IsValidForRead True
LogicalName goalowneridtype
RequiredLevel ApplicationRequired
Type EntityName

GoalStartDate

プロパティ
DateTimeBehavior UserLocal
Description Enter the date and time when the period for tracking the goal begins.
DisplayName From
Format DateOnly
IsValidForForm True
IsValidForRead True
LogicalName goalstartdate
RequiredLevel None
Type DateTime

GoalWithErrorId

プロパティ
Description Unique identifier of the goal that caused an error in the rollup of the goal hierarchy.
DisplayName Goal With Error
IsValidForCreate False
IsValidForForm False
IsValidForRead True
LogicalName goalwitherrorid
RequiredLevel None
Targets goal
Type Lookup

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

InProgressDecimal

プロパティ
Description Shows the in-progress value (decimal) against the target. This value could contribute to a goal, but is not counted yet as actual.
DisplayName In-progress (Decimal)
IsValidForForm True
IsValidForRead True
LogicalName inprogressdecimal
MaxValue 100000000000
MinValue -100000000000
Precision 10
RequiredLevel None
Type Decimal

InProgressInteger

プロパティ
Description Shows the in-progress value (integer) against the target. This value could contribute to a goal, but is not counted yet as actual.
DisplayName In-progress (Integer)
Format None
IsValidForForm True
IsValidForRead True
LogicalName inprogressinteger
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

InProgressMoney

プロパティ
Description Shows the in-progress value (money) against the target. This value could contribute to a goal, but is not counted yet as actual.
DisplayName In-progress (Money)
IsValidForForm True
IsValidForRead True
LogicalName inprogressmoney
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

IsAmount

プロパティ
Description Indicates whether the metric type is Count or Amount.
DisplayName Metric Type
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName isamount
RequiredLevel ApplicationRequired
Type Boolean

IsAmount の選択肢/オプション

ラベル 内容
1 Amount
0 Count

既定値 : 1

IsFiscalPeriodGoal

プロパティ
Description Select whether the goal period is a fiscal period or custom period.
DisplayName Goal Period Type
IsValidForForm True
IsValidForRead True
LogicalName isfiscalperiodgoal
RequiredLevel None
Type Boolean

IsFiscalPeriodGoal の選択肢/オプション

ラベル 内容
1 Fiscal Period
0 Custom Period

既定値 : 1

IsOverridden

プロパティ
Description Select whether the system rollup fields are updated. If set to Yes, the next system rollup will not update the values of the rollup fields with the system calculated values.
DisplayName Overridden
IsValidForForm True
IsValidForRead True
LogicalName isoverridden
RequiredLevel None
Type Boolean

IsOverridden の選択肢/オプション

ラベル 内容
1 Yes
0 No

既定値 : 0

IsOverride

プロパティ
Description Indicates whether the values of system rollup fields can be updated.
DisplayName Override
IsValidForForm False
IsValidForRead True
LogicalName isoverride
RequiredLevel None
Type Boolean

IsOverride の選択肢/オプション

ラベル 内容
1 Yes
0 No

既定値 : 0

LastRolledupDate

プロパティ
DateTimeBehavior UserLocal
Description Shows the date and time when the goal was last rolled up. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName Last Rolled Up Date
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName lastrolledupdate
RequiredLevel None
Type DateTime

MetricId

プロパティ
Description Choose the metric for the goal. This metric determines how the goal is tracked.
DisplayName Goal Metric
IsValidForForm True
IsValidForRead True
LogicalName metricid
RequiredLevel ApplicationRequired
Targets metric
Type Lookup

OverriddenCreatedOn

プロパティ
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

プロパティ
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 Manager
IsValidForForm True
IsValidForRead True
LogicalName ownerid
RequiredLevel SystemRequired
Targets systemuser
Type Owner

OwnerIdType

プロパティ
Description Owner Id Type
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridtype
RequiredLevel SystemRequired
Type EntityName

ParentGoalId

プロパティ
Description Choose a parent goal if the current goal is a child goal. This sets up a parent-child relationship for reporting and analytics.
DisplayName Parent Goal
IsValidForForm True
IsValidForRead True
LogicalName parentgoalid
RequiredLevel None
Targets goal
Type Lookup

Percentage

プロパティ
Description Shows the percentage achieved against the target goal.
DisplayName Percentage Achieved
IsValidForForm True
IsValidForRead True
LogicalName percentage
MaxValue 100000000000
MinValue -100000000000
Precision 0
RequiredLevel None
Type Decimal

RollupErrorCode

プロパティ
Description Error code associated with rollup.
DisplayName Rollup Error Code
Format None
IsValidForCreate False
IsValidForForm False
IsValidForRead True
LogicalName rolluperrorcode
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

RollupOnlyFromChildGoals

プロパティ
Description Select whether the data should be rolled up only from the child goals.
DisplayName Roll Up Only from Child Goals
IsValidForForm True
IsValidForRead True
LogicalName rolluponlyfromchildgoals
RequiredLevel SystemRequired
Type Boolean

RollupOnlyFromChildGoals の選択肢/オプション

ラベル 内容
1 Yes
0 No

既定値 : 0

RollUpQueryActualDecimalId

プロパティ
Description Choose the query that will be used to calculate the actual data for the goal (decimal).
DisplayName Rollup Query - Actual(Decimal)
IsValidForForm True
IsValidForRead True
LogicalName rollupqueryactualdecimalid
RequiredLevel None
Targets goalrollupquery
Type Lookup

RollupQueryActualIntegerId

プロパティ
Description Choose the query that will be used to calculate the actual data for the goal (integer).
DisplayName Rollup Query - Actual(Integer)
IsValidForForm True
IsValidForRead True
LogicalName rollupqueryactualintegerid
RequiredLevel None
Targets goalrollupquery
Type Lookup

RollUpQueryActualMoneyId

プロパティ
Description Choose the query that will be used to calculate the actual data for the goal (money).
DisplayName Rollup Query - Actual(Money)
IsValidForForm True
IsValidForRead True
LogicalName rollupqueryactualmoneyid
RequiredLevel None
Targets goalrollupquery
Type Lookup

RollUpQueryCustomDecimalId

プロパティ
Description Choose the query that will be used to calculate data for the custom rollup field (decimal).
DisplayName Rollup Query - Custom Rollup Field (Decimal)
IsValidForForm True
IsValidForRead True
LogicalName rollupquerycustomdecimalid
RequiredLevel None
Targets goalrollupquery
Type Lookup

RollUpQueryCustomIntegerId

プロパティ
Description Choose the query that will be used to calculate data for the custom rollup field (integer).
DisplayName Rollup Query - Custom Rollup Field (Integer)
IsValidForForm True
IsValidForRead True
LogicalName rollupquerycustomintegerid
RequiredLevel None
Targets goalrollupquery
Type Lookup

RollUpQueryCustomMoneyId

プロパティ
Description Choose the query that will be used to calculate data for the custom rollup field (money).
DisplayName Rollup Query - Custom Rollup Field (Money)
IsValidForForm True
IsValidForRead True
LogicalName rollupquerycustommoneyid
RequiredLevel None
Targets goalrollupquery
Type Lookup

RollUpQueryInprogressDecimalId

プロパティ
Description Choose the query that will be used to calculate data for the in-progress rollup field (decimal).
DisplayName Rollup Query - In-progress(Decimal)
IsValidForForm True
IsValidForRead True
LogicalName rollupqueryinprogressdecimalid
RequiredLevel None
Targets goalrollupquery
Type Lookup

RollUpQueryInprogressIntegerId

プロパティ
Description Choose the query that will be used to calculate data for the in-progress rollup field (integer).
DisplayName Rollup Query - In-progress(Integer)
IsValidForForm True
IsValidForRead True
LogicalName rollupqueryinprogressintegerid
RequiredLevel None
Targets goalrollupquery
Type Lookup

RollUpQueryInprogressMoneyId

プロパティ
Description Choose the query that will be used to calculate data for the in-progress rollup field (money).
DisplayName Rollup Query - In-progress(Money)
IsValidForForm True
IsValidForRead True
LogicalName rollupqueryinprogressmoneyid
RequiredLevel None
Targets goalrollupquery
Type Lookup

StateCode

プロパティ
Description Shows whether the goal is open, completed, or canceled. Completed and canceled goals are read-only and can't be edited.
DisplayName Status
IsValidForCreate False
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State

StateCode の選択肢/オプション

ラベル 既定の状態 不変名
0 Active 0 Active
1 Inactive 1 Inactive

StatusCode

プロパティ
Description Select the goal's status.
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel None
Type Status

StatusCode の選択肢/オプション

ラベル 状態
0 Open 0
1 Closed 1
2 Discarded 1

StretchTargetDecimal

プロパティ
Description Select a stretch target (decimal) of the goal to define a higher or difficult level of goal than the usual ones.
DisplayName Stretch Target (Decimal)
IsValidForForm True
IsValidForRead True
LogicalName stretchtargetdecimal
MaxValue 100000000000
MinValue 0
Precision 2
RequiredLevel None
Type Decimal

StretchTargetInteger

プロパティ
Description Select the stretch target (integer) of the goal to define a higher or difficult level of goal than the usual ones.
DisplayName Stretch Target (Integer)
Format None
IsValidForForm True
IsValidForRead True
LogicalName stretchtargetinteger
MaxValue 2147483647
MinValue 0
RequiredLevel None
Type Integer

StretchTargetMoney

プロパティ
Description Select stretch target (money) of the goal to define a higher or difficult level of goal than the usual ones.
DisplayName Stretch Target (Money)
IsValidForForm True
IsValidForRead True
LogicalName stretchtargetmoney
MaxValue 922337203685477
MinValue 0
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

TargetDecimal

プロパティ
Description Select a goal target of the decimal type to use for tracking data that include partial numbers, such as pounds sold of a product sold by weight.
DisplayName Target (Decimal)
IsValidForForm True
IsValidForRead True
LogicalName targetdecimal
MaxValue 100000000000
MinValue 0
Precision 2
RequiredLevel None
Type Decimal

TargetInteger

プロパティ
Description Select a goal target of the integer type to use for tracking anything countable in whole numbers, such as units sold.
DisplayName Target (Integer)
Format None
IsValidForForm True
IsValidForRead True
LogicalName targetinteger
MaxValue 2147483647
MinValue 0
RequiredLevel None
Type Integer

TargetMoney

プロパティ
Description Select a goal target (money) to track a monetary amount such as revenue from a product.
DisplayName Target (Money)
IsValidForForm True
IsValidForRead True
LogicalName targetmoney
MaxValue 922337203685477
MinValue 0
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

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

Title

プロパティ
Description Type a title or name that describes the goal.
DisplayName Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName title
MaxLength 100
RequiredLevel ApplicationRequired
Type String

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 が一覧表示。

ActualMoney_Base

プロパティ
Description Shows the actual value (money type) in base currency to track goal results against the target.
DisplayName Actual (Money) (Base)
IsValidForForm True
IsValidForRead True
LogicalName actualmoney_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

ActualString

プロパティ
Description Actual Value of the goal.
DisplayName Actual
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName actualstring
MaxLength 100
RequiredLevel None
Type String

ComputedTargetAsOfTodayDecimal

プロパティ
Description Shows the expected amount for actual value (decimal type) against the target goal.
DisplayName Today's Target (Decimal)
IsValidForForm True
IsValidForRead True
LogicalName computedtargetasoftodaydecimal
MaxValue 100000000000
MinValue 0
Precision 2
RequiredLevel None
Type Decimal

ComputedTargetAsOfTodayInteger

プロパティ
Description Shows the expected amount for actual value (integer type) against the target goal as of the current date.
DisplayName Today's Target (Integer)
Format None
IsValidForForm True
IsValidForRead True
LogicalName computedtargetasoftodayinteger
MaxValue 2147483647
MinValue 0
RequiredLevel None
Type Integer

ComputedTargetAsOfTodayMoney

プロパティ
Description Shows the expected amount for actual value (money type) against the target goal as of the current date.
DisplayName Today's Target (Money)
IsValidForForm True
IsValidForRead True
LogicalName computedtargetasoftodaymoney
MaxValue 922337203685477
MinValue 0
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

ComputedTargetAsOfTodayMoney_Base

プロパティ
Description Shows the expected amount in base currency for actual value (money type) against the target goal as of the current date.
DisplayName Today's Target (Money) (Base)
IsValidForForm True
IsValidForRead True
LogicalName computedtargetasoftodaymoney_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

ComputedTargetAsOfTodayPercentageAchieved

プロパティ
Description Shows the expected value for percentage achieved against the target goal as of the current date.
DisplayName Today's Target (Percentage Achieved)
IsValidForForm True
IsValidForRead True
LogicalName computedtargetasoftodaypercentageachieved
MaxValue 100000000000
MinValue 0
Precision 0
RequiredLevel None
Type Decimal

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

CustomRollupFieldMoney_Base

プロパティ
Description Indicates a placeholder rollup field for a money value in base currency to track a third category of results other than actuals and in-progress results.
DisplayName Custom Rollup Field (Money) (Base)
IsValidForForm True
IsValidForRead True
LogicalName customrollupfieldmoney_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

CustomRollupFieldString

プロパティ
Description Placeholder rollup field for the goal.
DisplayName Custom Rollup Field
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName customrollupfieldstring
MaxLength 100
RequiredLevel None
Type String

Depth

プロパティ
Description Depth of the goal in the tree.
DisplayName Depth
Format None
IsValidForForm False
IsValidForRead True
LogicalName depth
MaxValue 2147483647
MinValue 0
RequiredLevel None
Type Integer

EntityImage_Timestamp

プロパティ
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName entityimage_timestamp
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

EntityImage_URL

プロパティ
Description
DisplayName
FormatName Url
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName entityimage_url
MaxLength 200
RequiredLevel None
Type String

EntityImageId

プロパティ
Description For internal use only.
DisplayName Entity Image Id
IsValidForForm False
IsValidForRead True
LogicalName entityimageid
RequiredLevel None
Type Uniqueidentifier

ExchangeRate

プロパティ
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

GoalOwnerIdName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName goalowneridname
MaxLength 160
RequiredLevel ApplicationRequired
Type String

GoalOwnerIdYomiName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName goalowneridyominame
MaxLength 160
RequiredLevel ApplicationRequired
Type String

GoalWithErrorIdName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName goalwitherroridname
MaxLength 100
RequiredLevel None
Type String

InProgressMoney_Base

プロパティ
Description Shows the in-progress value (money) in base currency to track goal results against the target.
DisplayName In-progress (Money) (Base)
IsValidForForm True
IsValidForRead True
LogicalName inprogressmoney_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

InProgressString

プロパティ
Description In-progress value of the goal.
DisplayName In-Progress
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName inprogressstring
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

OwnerIdName

プロパティ
Description Name of the manager
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owneridname
MaxLength 100
RequiredLevel SystemRequired
Type String

OwnerIdYomiName

プロパティ
Description Yomi name of the owner
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owneridyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

OwningBusinessUnit

プロパティ
Description Unique identifier for the business unit that owns the record.
DisplayName Owning Business Unit
IsValidForForm True
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel None
Targets businessunit
Type Lookup

OwningBusinessUnitName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owningbusinessunitname
MaxLength 160
RequiredLevel None
Type String

OwningTeam

プロパティ
Description Unique identifier of the team who owns the goal.
DisplayName Owning Team
IsValidForForm False
IsValidForRead True
LogicalName owningteam
RequiredLevel None
Targets team
Type Lookup

OwningUser

プロパティ
Description Unique identifier for the user who owns the record.
DisplayName Owning User
IsValidForForm False
IsValidForRead True
LogicalName owninguser
RequiredLevel None
Targets systemuser
Type Lookup

ParentGoalIdName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName parentgoalidname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryActualDecimalIdName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupqueryactualdecimalidname
MaxLength 100
RequiredLevel None
Type String

RollupQueryActualIntegerIdName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupqueryactualintegeridname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryActualMoneyIdName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupqueryactualmoneyidname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryCustomDecimalIdName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupquerycustomdecimalidname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryCustomIntegerIdName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupquerycustomintegeridname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryCustomMoneyIdName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupquerycustommoneyidname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryInprogressDecimalIdName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupqueryinprogressdecimalidname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryInprogressIntegerIdName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupqueryinprogressintegeridname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryInprogressMoneyIdName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupqueryinprogressmoneyidname
MaxLength 100
RequiredLevel None
Type String

StretchTargetMoney_Base

プロパティ
Description Shows the stretch target (money) in base currency to indicate a higher or difficult level of goal than the usual ones.
DisplayName Stretch Target (Money) (Base)
IsValidForForm True
IsValidForRead True
LogicalName stretchtargetmoney_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

StretchTargetString

プロパティ
Description Stretch target value for all data types.
DisplayName Stretched Target
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName stretchtargetstring
MaxLength 100
RequiredLevel None
Type String

TargetMoney_Base

プロパティ
Description Shows the goal target of the money type in base currency.
DisplayName Target (Money) (Base)
IsValidForForm True
IsValidForRead True
LogicalName targetmoney_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

TargetString

プロパティ
Description Target value of the goal.
DisplayName Target
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName targetstring
MaxLength 100
RequiredLevel None
Type String

TransactionCurrencyId

プロパティ
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

TransactionCurrencyIdName

プロパティ
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName transactioncurrencyidname
MaxLength 100
RequiredLevel None
Type String

TreeId

プロパティ
Description Unique identifier of the goal tree.
DisplayName Tree ID
IsValidForForm False
IsValidForRead True
LogicalName treeid
RequiredLevel None
Type Uniqueidentifier

VersionNumber

プロパティ
Description Version number of the goal.
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

一対多関連付け

SchemaName が一覧表示。

goal_parent_goal

goal テーブル/エンティティの多対一のリレーションシップ goal_parent_goal と同じです。

プロパティ
ReferencingEntity goal
ReferencingAttribute parentgoalid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName goal_parent_goal
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 140
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Goal_DuplicateBaseRecord

duplicaterecord テーブル/エンティティの多対一のリレーションシップ Goal_DuplicateBaseRecord と同じです。

プロパティ
ReferencingEntity duplicaterecord
ReferencingAttribute baserecordid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Goal_DuplicateBaseRecord
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Goal_RollupError_Goal

goal テーブル/エンティティの多対一のリレーションシップ Goal_RollupError_Goal と同じです。

プロパティ
ReferencingEntity goal
ReferencingAttribute goalwitherrorid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Goal_RollupError_Goal
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Goal_SyncErrors

syncerror テーブル/エンティティの多対一のリレーションシップ Goal_SyncErrors と同じです。

プロパティ
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Goal_SyncErrors
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

Goal_Annotation

annotation テーブル/エンティティの多対一のリレーションシップ Goal_Annotation と同じです。

プロパティ
ReferencingEntity annotation
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Goal_Annotation
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

Goal_AsyncOperations

asyncoperation テーブル/エンティティの多対一のリレーションシップ Goal_AsyncOperations と同じです。

プロパティ
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Goal_AsyncOperations
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Goal_ProcessSessions

processsession テーブル/エンティティの多対一のリレーションシップ Goal_ProcessSessions と同じです。

プロパティ
ReferencingEntity processsession
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Goal_ProcessSessions
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 110
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

goal_connections1

connection テーブル/エンティティの多対一のリレーションシップ goal_connections1 と同じです。

プロパティ
ReferencingEntity connection
ReferencingAttribute record1id
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName goal_connections1
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 100
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

goal_connections2

connection テーブル/エンティティの多対一のリレーションシップ goal_connections2 と同じです。

プロパティ
ReferencingEntity connection
ReferencingAttribute record2id
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName goal_connections2
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order: 100
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Goal_DuplicateMatchingRecord

duplicaterecord テーブル/エンティティの多対一のリレーションシップ Goal_DuplicateMatchingRecord と同じです。

プロパティ
ReferencingEntity duplicaterecord
ReferencingAttribute duplicaterecordid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Goal_DuplicateMatchingRecord
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

goal_principalobjectattributeaccess

principalobjectattributeaccess テーブル/エンティティの多対一のリレーションシップ goal_principalobjectattributeaccess と同じです。

プロパティ
ReferencingEntity principalobjectattributeaccess
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName goal_principalobjectattributeaccess
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

多対一関連付け

各多対一の関係付けは、関連するテーブルとの対応する一対多の関係付けによって定義されます。 SchemaName が一覧表示。

team_goal

team テーブル/エンティティの一対多のリレーションシップ team_goal を参照してください。

goalrollupquery_actualint

goalrollupquery テーブル/エンティティの一対多のリレーションシップ goalrollupquery_actualint を参照してください。

goal_rollupquery_actualmoney

goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_actualmoney を参照してください。

goal_rollupquery_actualdecimal

goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_actualdecimal を参照してください。

goal_rollupquery_customint

goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_customint を参照してください。

goal_rollupquery_custommoney

goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_custommoney を参照してください。

goal_rollupquery_customdecimal

goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_customdecimal を参照してください。

goal_rollupquery_inprogressint

goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_inprogressint を参照してください。

goal_rollupquery_inprogressmoney

goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_inprogressmoney を参照してください。

goal_rollupquery_inprogressdecimal

goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_inprogressdecimal を参照してください。

lk_goal_createdby

systemuser テーブル/エンティティの一対多のリレーションシップ lk_goal_createdby を参照してください。

lk_goal_createdonbehalfby

systemuser テーブル/エンティティの一対多のリレーションシップ lk_goal_createdonbehalfby を参照してください。

lk_goal_modifiedby

systemuser テーブル/エンティティの一対多のリレーションシップ lk_goal_modifiedby を参照してください。

lk_goal_modifiedonbehalfby

systemuser テーブル/エンティティの一対多のリレーションシップ lk_goal_modifiedonbehalfby を参照してください。

user_goal

systemuser テーブル/エンティティの一対多のリレーションシップ user_goal を参照してください。

business_unit_goal

businessunit テーブル/エンティティの一対多のリレーションシップ business_unit_goal を参照してください。

user_goal_goalowner

systemuser テーブル/エンティティの一対多のリレーションシップ user_goal_goalowner を参照してください。

goal_parent_goal

goal テーブル/エンティティの一対多のリレーションシップ goal_parent_goal を参照してください。

TransactionCurrency_Goal

transactioncurrency テーブル/エンティティの一対多のリレーションシップ TransactionCurrency_Goal を参照してください。

metric_goal

metric テーブル/エンティティの一対多のリレーションシップ metric_goal を参照してください。

Goal_RollupError_Goal

goal テーブル/エンティティの一対多のリレーションシップ Goal_RollupError_Goal を参照してください。

team_goal_goalowner

team テーブル/エンティティの一対多のリレーションシップ team_goal_goalowner を参照してください。

関連項目

Dataverse テーブル/エンティティ参照 Web API リファレンス goal EntityType