Goal table/entity reference

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
Create Event: True	POST /goals See Create	Create records
Delete Event: True	DELETE /goals(goalid) See Delete	Delete 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

goal_parent_goal

Many-To-One Relationship: goal goal_parent_goal

Property	Value
ReferencingEntity	goal
ReferencingAttribute	parentgoalid
ReferencedEntityNavigationPropertyName	goal_parent_goal
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 140 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

goal_principalobjectattributeaccess

Many-To-One Relationship: principalobjectattributeaccess goal_principalobjectattributeaccess

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

Goal_ProcessSessions

Many-To-One Relationship: processsession Goal_ProcessSessions

Property	Value
ReferencingEntity	processsession
ReferencingAttribute	regardingobjectid
ReferencedEntityNavigationPropertyName	Goal_ProcessSessions
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 110 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Goal_RollupError_Goal

Many-To-One Relationship: goal Goal_RollupError_Goal

Property	Value
ReferencingEntity	goal
ReferencingAttribute	goalwitherrorid
ReferencedEntityNavigationPropertyName	Goal_RollupError_Goal
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Goal_SyncErrors

Many-To-One Relationship: syncerror Goal_SyncErrors

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

See also

Dataverse table/entity reference
Dataverse Web API Reference
goal