Goal Entity Reference

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

Messages

Message Web API Operation SDK Assembly
Assign PATCH [org URI]/api/data/v9.0/goals(goalid)
Update ownerid property.
AssignRequest
Create POST [org URI]/api/data/v9.0/goals
See Create
CreateRequest or
Create
Delete DELETE [org URI]/api/data/v9.0/goals(goalid)
See Delete
DeleteRequest or
Delete
GrantAccess GrantAccess Action GrantAccessRequest
ModifyAccess ModifyAccess Action ModifyAccessRequest
Recalculate Recalculate Action RecalculateRequest
Retrieve GET [org URI]/api/data/v9.0/goals(goalid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveMultiple GET [org URI]/api/data/v9.0/goals
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple
RetrievePrincipalAccess RetrievePrincipalAccess Function RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccess Function RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess RevokeAccess Action RevokeAccessRequest
SetState PATCH [org URI]/api/data/v9.0/goals(goalid)
Update statecode and statuscode properties.
SetStateRequest
Update PATCH [org URI]/api/data/v9.0/goals(goalid)
See Update
UpdateRequest or
Update

Entity 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 attributes

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

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 Options

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

Value Label
1 Owned by goal owner
0 All

DefaultValue: True

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 False
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 Options

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

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

Value Label
1 Amount
0 Count

DefaultValue: True

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 Options

Value Label
1 Fiscal Period
0 Custom Period

DefaultValue: True

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 Options

Value Label
1 Yes
0 No

DefaultValue: False

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 Options

Value Label
1 Yes
0 No

DefaultValue: False

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 Options

Value Label
1 Yes
0 No

DefaultValue: False

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 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 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 attributes

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

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.0000000001
Precision 10
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 False
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel None
Targets businessunit
Type Lookup

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

Same as goal entity goal_parent_goal Many-To-One relationship.

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_DuplicateBaseRecord

Same as duplicaterecord entity Goal_DuplicateBaseRecord Many-To-One relationship.

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

Same as goal entity Goal_RollupError_Goal Many-To-One relationship.

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: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Goal_SyncErrors

Same as syncerror entity Goal_SyncErrors Many-To-One relationship.

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

Same as annotation entity Goal_Annotation Many-To-One relationship.

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

Same as asyncoperation entity Goal_AsyncOperations Many-To-One relationship.

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

Same as processsession entity Goal_ProcessSessions Many-To-One relationship.

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

Same as connection entity goal_connections1 Many-To-One relationship.

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

Same as connection entity goal_connections2 Many-To-One relationship.

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

Same as duplicaterecord entity Goal_DuplicateMatchingRecord Many-To-One relationship.

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

Same as principalobjectattributeaccess entity goal_principalobjectattributeaccess Many-To-One relationship.

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

Many-To-One Relationships

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

team_goal

See team Entity team_goal One-To-Many relationship.

goalrollupquery_actualint

See goalrollupquery Entity goalrollupquery_actualint One-To-Many relationship.

goal_rollupquery_actualmoney

See goalrollupquery Entity goal_rollupquery_actualmoney One-To-Many relationship.

goal_rollupquery_actualdecimal

See goalrollupquery Entity goal_rollupquery_actualdecimal One-To-Many relationship.

goal_rollupquery_customint

See goalrollupquery Entity goal_rollupquery_customint One-To-Many relationship.

goal_rollupquery_custommoney

See goalrollupquery Entity goal_rollupquery_custommoney One-To-Many relationship.

goal_rollupquery_customdecimal

See goalrollupquery Entity goal_rollupquery_customdecimal One-To-Many relationship.

goal_rollupquery_inprogressint

See goalrollupquery Entity goal_rollupquery_inprogressint One-To-Many relationship.

goal_rollupquery_inprogressmoney

See goalrollupquery Entity goal_rollupquery_inprogressmoney One-To-Many relationship.

goal_rollupquery_inprogressdecimal

See goalrollupquery Entity goal_rollupquery_inprogressdecimal One-To-Many relationship.

lk_goal_createdby

See systemuser Entity lk_goal_createdby One-To-Many relationship.

lk_goal_createdonbehalfby

See systemuser Entity lk_goal_createdonbehalfby One-To-Many relationship.

lk_goal_modifiedby

See systemuser Entity lk_goal_modifiedby One-To-Many relationship.

lk_goal_modifiedonbehalfby

See systemuser Entity lk_goal_modifiedonbehalfby One-To-Many relationship.

user_goal

See systemuser Entity user_goal One-To-Many relationship.

business_unit_goal

See businessunit Entity business_unit_goal One-To-Many relationship.

user_goal_goalowner

See systemuser Entity user_goal_goalowner One-To-Many relationship.

goal_parent_goal

See goal Entity goal_parent_goal One-To-Many relationship.

TransactionCurrency_Goal

See transactioncurrency Entity TransactionCurrency_Goal One-To-Many relationship.

metric_goal

See metric Entity metric_goal One-To-Many relationship.

Goal_RollupError_Goal

See goal Entity Goal_RollupError_Goal One-To-Many relationship.

team_goal_goalowner

See team Entity team_goal_goalowner One-To-Many relationship.

See also

About the Entity Reference
Web API Reference
goal EntityType