Goal table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

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

Messages

Message	Web API Operation	SDK class or method
Assign	PATCH /goals(goalid) Update ownerid property.	AssignRequest
Create	POST /goals See Create	CreateRequest or Create
Delete	DELETE /goals(goalid) See Delete	DeleteRequest or Delete
GrantAccess	GrantAccess	GrantAccessRequest
ModifyAccess	ModifyAccess	ModifyAccessRequest
Recalculate	Recalculate	RecalculateRequest
Retrieve	GET /goals(goalid) See Retrieve	RetrieveRequest or Retrieve
RetrieveMultiple	GET /goals See Query Data	RetrieveMultipleRequest or RetrieveMultiple
RetrievePrincipalAccess	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess	RevokeAccess	RevokeAccessRequest
SetState	PATCH /goals(goalid) Update statecode and statuscode properties.	SetStateRequest
Update	PATCH /goals(goalid) See Update	UpdateRequest or Update

Properties

Property	Value
CollectionSchemaName	Goals
DisplayCollectionName	Goals
DisplayName	Goal
EntitySetName	goals
IsBPFEntity	False
LogicalCollectionName	goals
LogicalName	goal
OwnershipType	UserOwned
PrimaryIdAttribute	goalid
PrimaryNameAttribute	title
SchemaName	Goal

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

• ActualDecimal
• ActualInteger
• ActualMoney
• AmountDataType
• ConsiderOnlyGoalOwnersRecords
• CustomRollupFieldDecimal
• CustomRollupFieldInteger
• CustomRollupFieldMoney
• EntityImage
• FiscalPeriod
• FiscalYear
• GoalEndDate
• GoalId
• GoalOwnerId
• GoalOwnerIdType
• GoalStartDate
• GoalWithErrorId
• ImportSequenceNumber
• InProgressDecimal
• InProgressInteger
• InProgressMoney
• IsAmount
• IsFiscalPeriodGoal
• IsOverridden
• IsOverride
• LastRolledupDate
• MetricId
• OverriddenCreatedOn
• OwnerId
• OwnerIdType
• ParentGoalId
• Percentage
• RollupErrorCode
• RollupOnlyFromChildGoals
• RollUpQueryActualDecimalId
• RollupQueryActualIntegerId
• RollUpQueryActualMoneyId
• RollUpQueryCustomDecimalId
• RollUpQueryCustomIntegerId
• RollUpQueryCustomMoneyId
• RollUpQueryInprogressDecimalId
• RollUpQueryInprogressIntegerId
• RollUpQueryInprogressMoneyId
• StateCode
• StatusCode
• StretchTargetDecimal
• StretchTargetInteger
• StretchTargetMoney
• TargetDecimal
• TargetInteger
• TargetMoney
• TimeZoneRuleVersionNumber
• Title
• UTCConversionTimeZoneCode

ActualDecimal

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
Description	Data type of the amount.
DisplayName	Amount Data Type
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	amountdatatype
RequiredLevel	None
Type	Picklist

AmountDataType Choices/Options

Value	Label	Description
0	Money
1	Decimal
2	Integer

ConsiderOnlyGoalOwnersRecords

Property	Value
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 Choices/Options

Value	Label	Description
1	Owned by goal owner
0	All

DefaultValue: 1

CustomRollupFieldDecimal

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
Description	Select the fiscal period for the goal.
DisplayName	Fiscal Period
IsValidForForm	True
IsValidForRead	True
LogicalName	fiscalperiod
RequiredLevel	None
Type	Picklist

FiscalPeriod Choices/Options

Value	Label	Description
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

Property	Value
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 Choices/Options

Value	Label	Description
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

Property	Value
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

Property	Value
Description	Unique identifier of the goal.
DisplayName	Goal
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	goalid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

GoalOwnerId

Property	Value
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

Property	Value
Description
DisplayName	Goal Owner Type
IsValidForForm	False
IsValidForRead	True
LogicalName	goalowneridtype
RequiredLevel	ApplicationRequired
Type	EntityName

GoalStartDate

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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 Choices/Options

Value	Label	Description
1	Amount
0	Count

DefaultValue: 1

IsFiscalPeriodGoal

Property	Value
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 Choices/Options

Value	Label	Description
1	Fiscal Period
0	Custom Period

DefaultValue: 1

IsOverridden

Property	Value
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 Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

IsOverride

Property	Value
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 Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

LastRolledupDate

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
Description	Owner Id Type
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridtype
RequiredLevel	SystemRequired
Type	EntityName

ParentGoalId

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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 Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

RollUpQueryActualDecimalId

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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 Choices/Options

Value	Label	DefaultStatus	InvariantName
0	Active	0	Active
1	Inactive	1	Inactive

StatusCode

Property	Value
Description	Select the goal's status.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	statuscode
RequiredLevel	None
Type	Status

StatusCode Choices/Options

Value	Label	State
0	Open	0
1	Closed	1
2	Discarded	1

StretchTargetDecimal

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.

• ActualMoney_Base
• ActualString
• ComputedTargetAsOfTodayDecimal
• ComputedTargetAsOfTodayInteger
• ComputedTargetAsOfTodayMoney
• ComputedTargetAsOfTodayMoney_Base
• ComputedTargetAsOfTodayPercentageAchieved
• CreatedBy
• CreatedByName
• CreatedOn
• CreatedOnBehalfBy
• CreatedOnBehalfByName
• CreatedOnBehalfByYomiName
• CustomRollupFieldMoney_Base
• CustomRollupFieldString
• Depth
• EntityImage_Timestamp
• EntityImage_URL
• EntityImageId
• ExchangeRate
• GoalOwnerIdName
• GoalOwnerIdYomiName
• GoalWithErrorIdName
• InProgressMoney_Base
• InProgressString
• MetricIdName
• ModifiedBy
• ModifiedByName
• ModifiedOn
• ModifiedOnBehalfBy
• ModifiedOnBehalfByName
• ModifiedOnBehalfByYomiName
• OwnerIdName
• OwnerIdYomiName
• OwningBusinessUnit
• OwningBusinessUnitName
• OwningTeam
• OwningUser
• ParentGoalIdName
• RollUpQueryActualDecimalIdName
• RollupQueryActualIntegerIdName
• RollUpQueryActualMoneyIdName
• RollUpQueryCustomDecimalIdName
• RollUpQueryCustomIntegerIdName
• RollUpQueryCustomMoneyIdName
• RollUpQueryInprogressDecimalIdName
• RollUpQueryInprogressIntegerIdName
• RollUpQueryInprogressMoneyIdName
• StretchTargetMoney_Base
• StretchTargetString
• TargetMoney_Base
• TargetString
• TransactionCurrencyId
• TransactionCurrencyIdName
• TreeId
• VersionNumber

ActualMoney_Base

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
Description	Shows who created the record.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedOn

Property	Value
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

Property	Value
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

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedOnBehalfByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

CustomRollupFieldMoney_Base

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	entityimage_timestamp
MaxValue	9223372036854775807
MinValue	-9223372036854775808
RequiredLevel	None
Type	BigInt

EntityImage_URL

Property	Value
Description
DisplayName
FormatName	Url
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	entityimage_url
MaxLength	200
RequiredLevel	None
Type	String

EntityImageId

Property	Value
Description	For internal use only.
DisplayName	Entity Image Id
IsValidForForm	False
IsValidForRead	True
LogicalName	entityimageid
RequiredLevel	None
Type	Uniqueidentifier

ExchangeRate

Property	Value
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

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	goalowneridname
MaxLength	160
RequiredLevel	ApplicationRequired
Type	String

GoalOwnerIdYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	goalowneridyominame
MaxLength	160
RequiredLevel	ApplicationRequired
Type	String

GoalWithErrorIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	goalwitherroridname
MaxLength	100
RequiredLevel	None
Type	String

InProgressMoney_Base

Property	Value
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

Property	Value
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

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	metricidname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedBy

Property	Value
Description	Shows who last updated the record.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOn

Property	Value
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

Property	Value
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

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOnBehalfByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

OwnerIdName

Property	Value
Description	Name of the manager
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

OwnerIdYomiName

Property	Value
Description	Yomi name of the owner
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridyominame
MaxLength	100
RequiredLevel	SystemRequired
Type	String

OwningBusinessUnit

Property	Value
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

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owningbusinessunitname
MaxLength	160
RequiredLevel	None
Type	String

OwningTeam

Property	Value
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

Property	Value
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

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	parentgoalidname
MaxLength	100
RequiredLevel	None
Type	String

RollUpQueryActualDecimalIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	rollupqueryactualdecimalidname
MaxLength	100
RequiredLevel	None
Type	String

RollupQueryActualIntegerIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	rollupqueryactualintegeridname
MaxLength	100
RequiredLevel	None
Type	String

RollUpQueryActualMoneyIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	rollupqueryactualmoneyidname
MaxLength	100
RequiredLevel	None
Type	String

RollUpQueryCustomDecimalIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	rollupquerycustomdecimalidname
MaxLength	100
RequiredLevel	None
Type	String

RollUpQueryCustomIntegerIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	rollupquerycustomintegeridname
MaxLength	100
RequiredLevel	None
Type	String

RollUpQueryCustomMoneyIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	rollupquerycustommoneyidname
MaxLength	100
RequiredLevel	None
Type	String

RollUpQueryInprogressDecimalIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	rollupqueryinprogressdecimalidname
MaxLength	100
RequiredLevel	None
Type	String

RollUpQueryInprogressIntegerIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	rollupqueryinprogressintegeridname
MaxLength	100
RequiredLevel	None
Type	String

RollUpQueryInprogressMoneyIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	rollupqueryinprogressmoneyidname
MaxLength	100
RequiredLevel	None
Type	String

StretchTargetMoney_Base

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
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

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	transactioncurrencyidname
MaxLength	100
RequiredLevel	None
Type	String

TreeId

Property	Value
Description	Unique identifier of the goal tree.
DisplayName	Tree ID
IsValidForForm	False
IsValidForRead	True
LogicalName	treeid
RequiredLevel	None
Type	Uniqueidentifier

VersionNumber

Property	Value
Description	Version number of the goal.
DisplayName	Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	versionnumber
MaxValue	9223372036854775807
MinValue	-9223372036854775808
RequiredLevel	None
Type	BigInt

One-To-Many Relationships

Listed by SchemaName.

• goal_parent_goal
• Goal_RollupError_Goal
• msdyn_goal_msdyn_forecastinstance

goal_parent_goal

Same as the goal_parent_goal many-to-one relationship for the goal table/entity.

Property	Value
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_RollupError_Goal

Same as the Goal_RollupError_Goal many-to-one relationship for the goal table/entity.

Property	Value
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

msdyn_goal_msdyn_forecastinstance

Added by: Forecasting Solution

Same as the msdyn_goal_msdyn_forecastinstance many-to-one relationship for the msdyn_forecastinstance table/entity.

Property	Value
ReferencingEntity	msdyn_forecastinstance
ReferencingAttribute	msdyn_matchinggoalid
IsHierarchical	False
IsCustomizable	False
ReferencedEntityNavigationPropertyName	msdyn_goal_msdyn_forecastinstance
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order: 10000
CascadeConfiguration	Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.

• goalrollupquery_actualint
• goal_rollupquery_actualmoney
• goal_rollupquery_actualdecimal
• goal_rollupquery_customint
• goal_rollupquery_custommoney
• goal_rollupquery_customdecimal
• goal_rollupquery_inprogressint
• goal_rollupquery_inprogressmoney
• goal_rollupquery_inprogressdecimal
• goal_parent_goal
• metric_goal
• Goal_RollupError_Goal

goalrollupquery_actualint

See the goalrollupquery_actualint one-to-many relationship for the goalrollupquery table/entity.

goal_rollupquery_actualmoney

See the goal_rollupquery_actualmoney one-to-many relationship for the goalrollupquery table/entity.

goal_rollupquery_actualdecimal

See the goal_rollupquery_actualdecimal one-to-many relationship for the goalrollupquery table/entity.

goal_rollupquery_customint

See the goal_rollupquery_customint one-to-many relationship for the goalrollupquery table/entity.

goal_rollupquery_custommoney

See the goal_rollupquery_custommoney one-to-many relationship for the goalrollupquery table/entity.

goal_rollupquery_customdecimal

See the goal_rollupquery_customdecimal one-to-many relationship for the goalrollupquery table/entity.

goal_rollupquery_inprogressint

See the goal_rollupquery_inprogressint one-to-many relationship for the goalrollupquery table/entity.

goal_rollupquery_inprogressmoney

See the goal_rollupquery_inprogressmoney one-to-many relationship for the goalrollupquery table/entity.

goal_rollupquery_inprogressdecimal

See the goal_rollupquery_inprogressdecimal one-to-many relationship for the goalrollupquery table/entity.

goal_parent_goal

See the goal_parent_goal one-to-many relationship for the goal table/entity.

metric_goal

See the metric_goal one-to-many relationship for the metric table/entity.

Goal_RollupError_Goal

See the Goal_RollupError_Goal one-to-many relationship for the goal table/entity.

Related information

Dataverse table/entity reference
Web API Reference