Goal table/entity reference (Microsoft Dataverse)

2025-08-28

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

Messages

The following table lists the messages for the Goal table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
`Assign` Event: True	`PATCH` /goals(goalid) Update the `ownerid` property.	AssignRequest
`Associate` Event: True	Associate records	Associate records
`Create` Event: True	`POST` /goals See Create	Create records
`Delete` Event: True	`DELETE` /goals(goalid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`GrantAccess` Event: True	GrantAccess	GrantAccessRequest
`ModifyAccess` Event: True	ModifyAccess	ModifyAccessRequest
`Recalculate` Event: True	Recalculate	RecalculateRequest
`Retrieve` Event: True	`GET` /goals(goalid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: True	`GET` /goals See Query data	Query data
`RetrievePrincipalAccess` Event: True	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
`RetrieveSharedPrincipalsAndAccess` Event: True	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
`RevokeAccess` Event: True	RevokeAccess	RevokeAccessRequest
`SetState` Event: True	`PATCH` /goals(goalid) Update the `statecode` and `statuscode` properties.	SetStateRequest
`Update` Event: True	`PATCH` /goals(goalid) See Update	Update records
`Upsert` Event: False	`PATCH` /goals(goalid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Goal table.

Property	Value
DisplayName	Goal
DisplayCollectionName	Goals
SchemaName	`Goal`
CollectionSchemaName	`Goals`
EntitySetName	`goals`
LogicalName	`goal`
LogicalCollectionName	`goals`
PrimaryIdAttribute	`goalid`
PrimaryNameAttribute	`title`
TableType	`Standard`
OwnershipType	`UserOwned`

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`
RequiredLevel	None
Type	Decimal
ImeMode	Disabled
MaxValue	100000000000
MinValue	-100000000000
Precision	10
SourceTypeMask	0

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)
IsValidForForm	True
IsValidForRead	True
LogicalName	`actualinteger`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

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`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

AmountDataType

Property	Value
Description	Data type of the amount.
DisplayName	Amount Data Type
IsValidForForm	False
IsValidForRead	True
LogicalName	`amountdatatype`
RequiredLevel	None
Type	Picklist
DefaultFormValue	1
GlobalChoiceName	`metric_goaltype`

AmountDataType Choices/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
GlobalChoiceName	`goal_consideronlygoalownersrecords`
DefaultValue	True
True Label	Owned by goal owner
False Label	All

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`
RequiredLevel	None
Type	Decimal
ImeMode	Disabled
MaxValue	100000000000
MinValue	-100000000000
Precision	10
SourceTypeMask	0

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)
IsValidForForm	True
IsValidForRead	True
LogicalName	`customrollupfieldinteger`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

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`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

EntityImage

Property	Value
Description	The default image for the entity.
DisplayName	Entity Image
IsValidForForm	False
IsValidForRead	True
LogicalName	`entityimage`
RequiredLevel	None
Type	Image
CanStoreFullImage	False
IsPrimaryImage	True
MaxHeight	144
MaxSizeInKB	10240
MaxWidth	144

FiscalPeriod

Property	Value
Description	Select the fiscal period for the goal.
DisplayName	Fiscal Period
IsValidForForm	True
IsValidForRead	True
LogicalName	`fiscalperiod`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`goal_fiscalperiod`

FiscalPeriod Choices/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
DefaultFormValue	-1
GlobalChoiceName	`goal_fiscalyear`

FiscalYear Choices/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
Description	Enter the date when the goal ends.
DisplayName	To
IsValidForForm	True
IsValidForRead	True
LogicalName	`goalenddate`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Auto
SourceTypeMask	0

GoalId

Property	Value
Description	Unique identifier of the goal.
DisplayName	Goal
IsValidForForm	False
IsValidForRead	True
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
Type	Lookup
Targets	systemuser, team

GoalOwnerIdType

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

GoalStartDate

Property	Value
Description	Enter the date and time when the period for tracking the goal begins.
DisplayName	From
IsValidForForm	True
IsValidForRead	True
LogicalName	`goalstartdate`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Auto
SourceTypeMask	0

GoalWithErrorId

Property	Value
Description	Unique identifier of the goal that caused an error in the rollup of the goal hierarchy.
DisplayName	Goal With Error
IsValidForForm	False
IsValidForRead	True
LogicalName	`goalwitherrorid`
RequiredLevel	None
Type	Lookup
Targets	goal

ImportSequenceNumber

Property	Value
Description	Sequence number of the import that created this record.
DisplayName	Import Sequence Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`importsequencenumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

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`
RequiredLevel	None
Type	Decimal
ImeMode	Disabled
MaxValue	100000000000
MinValue	-100000000000
Precision	10
SourceTypeMask	0

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)
IsValidForForm	True
IsValidForRead	True
LogicalName	`inprogressinteger`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

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`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

IsAmount

Property	Value
Description	Indicates whether the metric type is Count or Amount.
DisplayName	Metric Type
IsValidForForm	False
IsValidForRead	True
LogicalName	`isamount`
RequiredLevel	ApplicationRequired
Type	Boolean
GlobalChoiceName	`metric_type`
DefaultValue	True
True Label	Amount
False Label	Count

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
GlobalChoiceName	`goal_isfiscalperiodgoal`
DefaultValue	True
True Label	Fiscal Period
False Label	Custom Period

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
GlobalChoiceName	`goal_isoverridden`
DefaultValue	False
True Label	Yes
False Label	No

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
GlobalChoiceName	`goal_isoverride`
DefaultValue	False
True Label	Yes
False Label	No

LastRolledupDate

Property	Value
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
IsValidForForm	True
IsValidForRead	True
LogicalName	`lastrolledupdate`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Auto
SourceTypeMask	0

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
Type	Lookup
Targets	metric

OverriddenCreatedOn

Property	Value
Description	Date and time that the record was migrated.
DisplayName	Record Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	`overriddencreatedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

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
Type	Owner
Targets	systemuser

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
Type	Lookup
Targets	goal

Percentage

Property	Value
Description	Shows the percentage achieved against the target goal.
DisplayName	Percentage Achieved
IsValidForForm	True
IsValidForRead	True
LogicalName	`percentage`
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	100000000000
MinValue	-100000000000
Precision	0
SourceTypeMask	0

RollupErrorCode

Property	Value
Description	Error code associated with rollup.
DisplayName	Rollup Error Code
IsValidForForm	False
IsValidForRead	True
LogicalName	`rolluperrorcode`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

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
GlobalChoiceName	`goal_rolluponlyfromchildgoals`
DefaultValue	False
True Label	Yes
False Label	No

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
Type	Lookup
Targets	goalrollupquery

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
Type	Lookup
Targets	goalrollupquery

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
Type	Lookup
Targets	goalrollupquery

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
Type	Lookup
Targets	goalrollupquery

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
Type	Lookup
Targets	goalrollupquery

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
Type	Lookup
Targets	goalrollupquery

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
Type	Lookup
Targets	goalrollupquery

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
Type	Lookup
Targets	goalrollupquery

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
Type	Lookup
Targets	goalrollupquery

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
IsValidForForm	True
IsValidForRead	True
LogicalName	`statecode`
RequiredLevel	SystemRequired
Type	State
DefaultFormValue
GlobalChoiceName	`goal_statecode`

StateCode Choices/Options

Value	Details
0	Label: Active DefaultStatus: 0 InvariantName: `Active`
1	Label: Inactive DefaultStatus: 1 InvariantName: `Inactive`

StatusCode

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

StatusCode Choices/Options

Value	Details
0	Label: Open State:0 TransitionData: None
1	Label: Closed State:1 TransitionData: None
2	Label: Discarded State:1 TransitionData: None

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`
RequiredLevel	None
Type	Decimal
ImeMode	Disabled
MaxValue	100000000000
MinValue	0
Precision	2
SourceTypeMask	0

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)
IsValidForForm	True
IsValidForRead	True
LogicalName	`stretchtargetinteger`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

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`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	922337203685477
MinValue	0
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

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`
RequiredLevel	None
Type	Decimal
ImeMode	Disabled
MaxValue	100000000000
MinValue	0
Precision	2
SourceTypeMask	0

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)
IsValidForForm	True
IsValidForRead	True
LogicalName	`targetinteger`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

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`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	922337203685477
MinValue	0
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`timezoneruleversionnumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

Title

Property	Value
Description	Type a title or name that describes the goal.
DisplayName	Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`title`
RequiredLevel	ApplicationRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
IsValidForForm	False
IsValidForRead	True
LogicalName	`utcconversiontimezonecode`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

Read-only columns/attributes

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

ActualMoney_Base
ActualString
ComputedTargetAsOfTodayDecimal
ComputedTargetAsOfTodayInteger
ComputedTargetAsOfTodayMoney
ComputedTargetAsOfTodayMoney_Base
ComputedTargetAsOfTodayPercentageAchieved
CreatedBy
CreatedOn
CreatedOnBehalfBy
CustomRollupFieldMoney_Base
CustomRollupFieldString
Depth
EntityImage_Timestamp
EntityImage_URL
EntityImageId
ExchangeRate
InProgressMoney_Base
InProgressString
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OwnerIdName
OwnerIdYomiName
OwningBusinessUnit
OwningTeam
OwningUser
StretchTargetMoney_Base
StretchTargetString
TargetMoney_Base
TargetString
TransactionCurrencyId
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`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

ActualString

Property	Value
Description	Actual Value of the goal.
DisplayName	Actual
IsValidForForm	False
IsValidForRead	True
LogicalName	`actualstring`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

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`
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	100000000000
MinValue	0
Precision	2
SourceTypeMask	0

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)
IsValidForForm	True
IsValidForRead	True
LogicalName	`computedtargetasoftodayinteger`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

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`
RequiredLevel	None
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	922337203685477
MinValue	0
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

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`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

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`
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	100000000000
MinValue	0
Precision	0
SourceTypeMask	0

CreatedBy

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

CreatedOn

Property	Value
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
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

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
Type	Lookup
Targets	systemuser

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`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

CustomRollupFieldString

Property	Value
Description	Placeholder rollup field for the goal.
DisplayName	Custom Rollup Field
IsValidForForm	False
IsValidForRead	True
LogicalName	`customrollupfieldstring`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

Depth

Property	Value
Description	Depth of the goal in the tree.
DisplayName	Depth
IsValidForForm	False
IsValidForRead	True
LogicalName	`depth`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

EntityImage_Timestamp

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

EntityImage_URL

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

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`
RequiredLevel	None
Type	Decimal
ImeMode	Disabled
MaxValue	100000000000
MinValue	1E-12
Precision	12
SourceTypeMask	0

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`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

InProgressString

Property	Value
Description	In-progress value of the goal.
DisplayName	In-Progress
IsValidForForm	False
IsValidForRead	True
LogicalName	`inprogressstring`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

ModifiedBy

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

ModifiedOn

Property	Value
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
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

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
Type	Lookup
Targets	systemuser

OwnerIdName

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

OwnerIdYomiName

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

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
Type	Lookup
Targets	businessunit

OwningTeam

Property	Value
Description	Unique identifier of the team who owns the goal.
DisplayName	Owning Team
IsValidForForm	False
IsValidForRead	True
LogicalName	`owningteam`
RequiredLevel	None
Type	Lookup
Targets	team

OwningUser

Property	Value
Description	Unique identifier for the user who owns the record.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	`owninguser`
RequiredLevel	None
Type	Lookup
Targets	systemuser

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`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

StretchTargetString

Property	Value
Description	Stretch target value for all data types.
DisplayName	Stretched Target
IsValidForForm	False
IsValidForRead	True
LogicalName	`stretchtargetstring`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

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`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

TargetString

Property	Value
Description	Target value of the goal.
DisplayName	Target
IsValidForForm	False
IsValidForRead	True
LogicalName	`targetstring`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

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
Type	Lookup
Targets	transactioncurrency

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`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

business_unit_goal
goal_parent_goal
Goal_RollupError_Goal
goal_rollupquery_actualdecimal
goal_rollupquery_actualmoney
goal_rollupquery_customdecimal
goal_rollupquery_customint
goal_rollupquery_custommoney
goal_rollupquery_inprogressdecimal
goal_rollupquery_inprogressint
goal_rollupquery_inprogressmoney
goalrollupquery_actualint
lk_goal_createdby
lk_goal_createdonbehalfby
lk_goal_modifiedby
lk_goal_modifiedonbehalfby
metric_goal
owner_goal
team_goal
team_goal_goalowner
TransactionCurrency_Goal
user_goal
user_goal_goalowner

business_unit_goal

One-To-Many Relationship: businessunit business_unit_goal

Property	Value
ReferencedEntity	`businessunit`
ReferencedAttribute	`businessunitid`
ReferencingAttribute	`owningbusinessunit`
ReferencingEntityNavigationPropertyName	`owningbusinessunit`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

goal_parent_goal

One-To-Many Relationship: goal goal_parent_goal

Property	Value
ReferencedEntity	`goal`
ReferencedAttribute	`goalid`
ReferencingAttribute	`parentgoalid`
ReferencingEntityNavigationPropertyName	`parentgoalid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

Goal_RollupError_Goal

One-To-Many Relationship: goal Goal_RollupError_Goal

Property	Value
ReferencedEntity	`goal`
ReferencedAttribute	`goalid`
ReferencingAttribute	`goalwitherrorid`
ReferencingEntityNavigationPropertyName	`goalwitherrorid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

goal_rollupquery_actualdecimal

One-To-Many Relationship: goalrollupquery goal_rollupquery_actualdecimal

Property	Value
ReferencedEntity	`goalrollupquery`
ReferencedAttribute	`goalrollupqueryid`
ReferencingAttribute	`rollupqueryactualdecimalid`
ReferencingEntityNavigationPropertyName	`rollupqueryactualdecimalid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

goal_rollupquery_actualmoney

One-To-Many Relationship: goalrollupquery goal_rollupquery_actualmoney

Property	Value
ReferencedEntity	`goalrollupquery`
ReferencedAttribute	`goalrollupqueryid`
ReferencingAttribute	`rollupqueryactualmoneyid`
ReferencingEntityNavigationPropertyName	`rollupqueryactualmoneyid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

goal_rollupquery_customdecimal

One-To-Many Relationship: goalrollupquery goal_rollupquery_customdecimal

Property	Value
ReferencedEntity	`goalrollupquery`
ReferencedAttribute	`goalrollupqueryid`
ReferencingAttribute	`rollupquerycustomdecimalid`
ReferencingEntityNavigationPropertyName	`rollupquerycustomdecimalid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

goal_rollupquery_customint

One-To-Many Relationship: goalrollupquery goal_rollupquery_customint

Property	Value
ReferencedEntity	`goalrollupquery`
ReferencedAttribute	`goalrollupqueryid`
ReferencingAttribute	`rollupquerycustomintegerid`
ReferencingEntityNavigationPropertyName	`rollupquerycustomintegerid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

goal_rollupquery_custommoney

One-To-Many Relationship: goalrollupquery goal_rollupquery_custommoney

Property	Value
ReferencedEntity	`goalrollupquery`
ReferencedAttribute	`goalrollupqueryid`
ReferencingAttribute	`rollupquerycustommoneyid`
ReferencingEntityNavigationPropertyName	`rollupquerycustommoneyid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

goal_rollupquery_inprogressdecimal

One-To-Many Relationship: goalrollupquery goal_rollupquery_inprogressdecimal

Property	Value
ReferencedEntity	`goalrollupquery`
ReferencedAttribute	`goalrollupqueryid`
ReferencingAttribute	`rollupqueryinprogressdecimalid`
ReferencingEntityNavigationPropertyName	`rollupqueryinprogressdecimalid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

goal_rollupquery_inprogressint

One-To-Many Relationship: goalrollupquery goal_rollupquery_inprogressint

Property	Value
ReferencedEntity	`goalrollupquery`
ReferencedAttribute	`goalrollupqueryid`
ReferencingAttribute	`rollupqueryinprogressintegerid`
ReferencingEntityNavigationPropertyName	`rollupqueryinprogressintegerid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

goal_rollupquery_inprogressmoney

One-To-Many Relationship: goalrollupquery goal_rollupquery_inprogressmoney

Property	Value
ReferencedEntity	`goalrollupquery`
ReferencedAttribute	`goalrollupqueryid`
ReferencingAttribute	`rollupqueryinprogressmoneyid`
ReferencingEntityNavigationPropertyName	`rollupqueryinprogressmoneyid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

goalrollupquery_actualint

One-To-Many Relationship: goalrollupquery goalrollupquery_actualint

Property	Value
ReferencedEntity	`goalrollupquery`
ReferencedAttribute	`goalrollupqueryid`
ReferencingAttribute	`rollupqueryactualintegerid`
ReferencingEntityNavigationPropertyName	`rollupqueryactualintegerid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_goal_createdby

One-To-Many Relationship: systemuser lk_goal_createdby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdby`
ReferencingEntityNavigationPropertyName	`createdby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_goal_createdonbehalfby

One-To-Many Relationship: systemuser lk_goal_createdonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdonbehalfby`
ReferencingEntityNavigationPropertyName	`createdonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_goal_modifiedby

One-To-Many Relationship: systemuser lk_goal_modifiedby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedby`
ReferencingEntityNavigationPropertyName	`modifiedby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_goal_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_goal_modifiedonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedonbehalfby`
ReferencingEntityNavigationPropertyName	`modifiedonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

metric_goal

One-To-Many Relationship: metric metric_goal

Property	Value
ReferencedEntity	`metric`
ReferencedAttribute	`metricid`
ReferencingAttribute	`metricid`
ReferencingEntityNavigationPropertyName	`metricid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

owner_goal

One-To-Many Relationship: owner owner_goal

Property	Value
ReferencedEntity	`owner`
ReferencedAttribute	`ownerid`
ReferencingAttribute	`ownerid`
ReferencingEntityNavigationPropertyName	`ownerid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

team_goal

One-To-Many Relationship: team team_goal

Property	Value
ReferencedEntity	`team`
ReferencedAttribute	`teamid`
ReferencingAttribute	`owningteam`
ReferencingEntityNavigationPropertyName	`owningteam`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

team_goal_goalowner

One-To-Many Relationship: team team_goal_goalowner

Property	Value
ReferencedEntity	`team`
ReferencedAttribute	`teamid`
ReferencingAttribute	`goalownerid`
ReferencingEntityNavigationPropertyName	`goalownerid_team`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

TransactionCurrency_Goal

One-To-Many Relationship: transactioncurrency TransactionCurrency_Goal

Property	Value
ReferencedEntity	`transactioncurrency`
ReferencedAttribute	`transactioncurrencyid`
ReferencingAttribute	`transactioncurrencyid`
ReferencingEntityNavigationPropertyName	`transactioncurrencyid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

user_goal

One-To-Many Relationship: systemuser user_goal

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`owninguser`
ReferencingEntityNavigationPropertyName	`owninguser`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

user_goal_goalowner

One-To-Many Relationship: systemuser user_goal_goalowner

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`goalownerid`
ReferencingEntityNavigationPropertyName	`goalownerid_systemuser`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

Goal_Annotation
Goal_AsyncOperations
goal_connections1
goal_connections2
Goal_DuplicateBaseRecord
Goal_DuplicateMatchingRecord
goal_parent_goal
goal_principalobjectattributeaccess
Goal_ProcessSessions
Goal_RollupError_Goal
Goal_SyncErrors

Goal_Annotation

Many-To-One Relationship: annotation Goal_Annotation

Property	Value
ReferencingEntity	`annotation`
ReferencingAttribute	`objectid`
ReferencedEntityNavigationPropertyName	`Goal_Annotation`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Goal_AsyncOperations

Many-To-One Relationship: asyncoperation Goal_AsyncOperations

Property	Value
ReferencingEntity	`asyncoperation`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`Goal_AsyncOperations`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

goal_connections1

Many-To-One Relationship: connection goal_connections1

Property	Value
ReferencingEntity	`connection`
ReferencingAttribute	`record1id`
ReferencedEntityNavigationPropertyName	`goal_connections1`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 100 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

goal_connections2

Many-To-One Relationship: connection goal_connections2

Property	Value
ReferencingEntity	`connection`
ReferencingAttribute	`record2id`
ReferencedEntityNavigationPropertyName	`goal_connections2`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: 100 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Goal_DuplicateBaseRecord

Many-To-One Relationship: duplicaterecord Goal_DuplicateBaseRecord

Property	Value
ReferencingEntity	`duplicaterecord`
ReferencingAttribute	`baserecordid`
ReferencedEntityNavigationPropertyName	`Goal_DuplicateBaseRecord`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Goal_DuplicateMatchingRecord

Many-To-One Relationship: duplicaterecord Goal_DuplicateMatchingRecord

Property	Value
ReferencingEntity	`duplicaterecord`
ReferencingAttribute	`duplicaterecordid`
ReferencedEntityNavigationPropertyName	`Goal_DuplicateMatchingRecord`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`