Partager via


Référence d’entité/de table Goal

Notes

Vous n’êtes pas sûr de la table par rapport à l’entité ? Voir Développeurs : Comprendre la terminologie dans Microsoft Dataverse.

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

Messages

Message Opération de l'API web Classe ou méthode SDK
Assign PATCH [org URI]/api/data/v9.0/goals(goalid)
Mettre à jour la propriété ownerid.
AssignRequest
Create POST [org URI]/api/data/v9.0/goals
Voir Créer
CreateRequest ou
Create
Delete DELETE [org URI]/api/data/v9.0/goals(goalid)
Voir Supprimer
DeleteRequest ou
Delete
GrantAccess GrantAccess Action GrantAccessRequest
ModifyAccess ModifyAccess Action ModifyAccessRequest
Recalculate Recalculate Action RecalculateRequest
Retrieve GET [org URI]/api/data/v9.0/goals(goalid)
Voir Récupérer
RetrieveRequest ou
Retrieve
RetrieveMultiple GET [org URI]/api/data/v9.0/goals
Voir Rechercher des données
RetrieveMultipleRequest ou
RetrieveMultiple
RetrievePrincipalAccess RetrievePrincipalAccess Function RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccess Function RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess RevokeAccess Action RevokeAccessRequest
SetState PATCH [org URI]/api/data/v9.0/goals(goalid)
Mettre à jour les propriétés statecode et statuscode.
SetStateRequest
Update PATCH [org URI]/api/data/v9.0/goals(goalid)
Voir Mettre à jour
UpdateRequest ou
Update

Propriétés

Propriété Valeur
CollectionSchemaName Goals
DisplayCollectionName Goals
DisplayName Goal
EntitySetName goals
IsBPFEntity False
LogicalCollectionName goals
LogicalName goal
OwnershipType UserOwned
PrimaryIdAttribute goalid
PrimaryNameAttribute title
SchemaName Goal

Colonnes/Attributs inscriptibles

Ces colonnes/attributs renvoient la valeur true pour IsValidForCreate ou IsValidForUpdate (généralement les deux). Répertorié par SchemaName.

ActualDecimal

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

ActualInteger

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

ActualMoney

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

AmountDataType

Propriété Valeur
Description Data type of the amount.
DisplayName Amount Data Type
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName amountdatatype
RequiredLevel None
Type Picklist

Choix/Options AmountDataType

Valeur Étiquette Description
0 Money
1 Decimal
2 Integer

ConsiderOnlyGoalOwnersRecords

Propriété Valeur
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

Choix/Options ConsiderOnlyGoalOwnersRecords

Valeur Étiquette Description
1 Owned by goal owner
0 All

Valeur par défaut : 1

CustomRollupFieldDecimal

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

CustomRollupFieldInteger

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

CustomRollupFieldMoney

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

EntityImage

Propriété Valeur
Description The default image for the entity.
DisplayName Entity Image
IsPrimaryImage True
IsValidForForm False
IsValidForRead True
LogicalName entityimage
MaxHeight 144
MaxWidth 144
RequiredLevel None
Type Image

FiscalPeriod

Propriété Valeur
Description Select the fiscal period for the goal.
DisplayName Fiscal Period
IsValidForForm True
IsValidForRead True
LogicalName fiscalperiod
RequiredLevel None
Type Picklist

Choix/Options FiscalPeriod

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

FiscalYear

Propriété Valeur
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

Choix/Options FiscalYear

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

GoalEndDate

Propriété Valeur
DateTimeBehavior UserLocal
Description Enter the date when the goal ends.
DisplayName To
Format DateOnly
IsValidForForm True
IsValidForRead True
LogicalName goalenddate
RequiredLevel None
Type DateTime

GoalId

Propriété Valeur
Description Unique identifier of the goal.
DisplayName Goal
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName goalid
RequiredLevel SystemRequired
Type Uniqueidentifier

GoalOwnerId

Propriété Valeur
Description Choose the user or team responsible for meeting the goal.
DisplayName Goal Owner
IsValidForForm True
IsValidForRead True
LogicalName goalownerid
RequiredLevel ApplicationRequired
Targets systemuser,team
Type Lookup

GoalOwnerIdType

Propriété Valeur
Description
DisplayName Goal Owner Type
IsValidForForm False
IsValidForRead True
LogicalName goalowneridtype
RequiredLevel ApplicationRequired
Type EntityName

GoalStartDate

Propriété Valeur
DateTimeBehavior UserLocal
Description Enter the date and time when the period for tracking the goal begins.
DisplayName From
Format DateOnly
IsValidForForm True
IsValidForRead True
LogicalName goalstartdate
RequiredLevel None
Type DateTime

GoalWithErrorId

Propriété Valeur
Description Unique identifier of the goal that caused an error in the rollup of the goal hierarchy.
DisplayName Goal With Error
IsValidForCreate False
IsValidForForm False
IsValidForRead True
LogicalName goalwitherrorid
RequiredLevel None
Targets goal
Type Lookup

ImportSequenceNumber

Propriété Valeur
Description Sequence number of the import that created this record.
DisplayName Import Sequence Number
Format None
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName importsequencenumber
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

InProgressDecimal

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

InProgressInteger

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

InProgressMoney

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

IsAmount

Propriété Valeur
Description Indicates whether the metric type is Count or Amount.
DisplayName Metric Type
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName isamount
RequiredLevel ApplicationRequired
Type Boolean

Choix/Options IsAmount

Valeur Étiquette Description
1 Amount
0 Count

Valeur par défaut : 1

IsFiscalPeriodGoal

Propriété Valeur
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

Choix/Options IsFiscalPeriodGoal

Valeur Étiquette Description
1 Fiscal Period
0 Custom Period

Valeur par défaut : 1

IsOverridden

Propriété Valeur
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

Choix/Options IsOverridden

Valeur Étiquette Description
1 Yes
0 No

Valeur par défaut : 0

IsOverride

Propriété Valeur
Description Indicates whether the values of system rollup fields can be updated.
DisplayName Override
IsValidForForm False
IsValidForRead True
LogicalName isoverride
RequiredLevel None
Type Boolean

Choix/Options IsOverride

Valeur Étiquette Description
1 Yes
0 No

Valeur par défaut : 0

LastRolledupDate

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

MetricId

Propriété Valeur
Description Choose the metric for the goal. This metric determines how the goal is tracked.
DisplayName Goal Metric
IsValidForForm True
IsValidForRead True
LogicalName metricid
RequiredLevel ApplicationRequired
Targets metric
Type Lookup

OverriddenCreatedOn

Propriété Valeur
DateTimeBehavior UserLocal
Description Date and time that the record was migrated.
DisplayName Record Created On
Format DateOnly
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName overriddencreatedon
RequiredLevel None
Type DateTime

OwnerId

Propriété Valeur
Description Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user.
DisplayName Manager
IsValidForForm True
IsValidForRead True
LogicalName ownerid
RequiredLevel SystemRequired
Targets systemuser
Type Owner

OwnerIdType

Propriété Valeur
Description Owner Id Type
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridtype
RequiredLevel SystemRequired
Type EntityName

ParentGoalId

Propriété Valeur
Description Choose a parent goal if the current goal is a child goal. This sets up a parent-child relationship for reporting and analytics.
DisplayName Parent Goal
IsValidForForm True
IsValidForRead True
LogicalName parentgoalid
RequiredLevel None
Targets goal
Type Lookup

Percentage

Propriété Valeur
Description Shows the percentage achieved against the target goal.
DisplayName Percentage Achieved
IsValidForForm True
IsValidForRead True
LogicalName percentage
MaxValue 100000000000
MinValue -100000000000
Precision 0
RequiredLevel None
Type Decimal

RollupErrorCode

Propriété Valeur
Description Error code associated with rollup.
DisplayName Rollup Error Code
Format None
IsValidForCreate False
IsValidForForm False
IsValidForRead True
LogicalName rolluperrorcode
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

RollupOnlyFromChildGoals

Propriété Valeur
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

Choix/Options RollupOnlyFromChildGoals

Valeur Étiquette Description
1 Yes
0 No

Valeur par défaut : 0

RollUpQueryActualDecimalId

Propriété Valeur
Description Choose the query that will be used to calculate the actual data for the goal (decimal).
DisplayName Rollup Query - Actual(Decimal)
IsValidForForm True
IsValidForRead True
LogicalName rollupqueryactualdecimalid
RequiredLevel None
Targets goalrollupquery
Type Lookup

RollupQueryActualIntegerId

Propriété Valeur
Description Choose the query that will be used to calculate the actual data for the goal (integer).
DisplayName Rollup Query - Actual(Integer)
IsValidForForm True
IsValidForRead True
LogicalName rollupqueryactualintegerid
RequiredLevel None
Targets goalrollupquery
Type Lookup

RollUpQueryActualMoneyId

Propriété Valeur
Description Choose the query that will be used to calculate the actual data for the goal (money).
DisplayName Rollup Query - Actual(Money)
IsValidForForm True
IsValidForRead True
LogicalName rollupqueryactualmoneyid
RequiredLevel None
Targets goalrollupquery
Type Lookup

RollUpQueryCustomDecimalId

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

RollUpQueryCustomIntegerId

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

RollUpQueryCustomMoneyId

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

RollUpQueryInprogressDecimalId

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

RollUpQueryInprogressIntegerId

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

RollUpQueryInprogressMoneyId

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

StateCode

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

Choix/Options StateCode

Valeur Étiquette Statut par défaut Nom invariant
0 Active 0 Active
1 Inactive 1 Inactive

StatusCode

Propriété Valeur
Description Select the goal's status.
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel None
Type Status

Choix/Options StatusCode

Valeur Étiquette État
0 Open 0
1 Closed 1
2 Discarded 1

StretchTargetDecimal

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

StretchTargetInteger

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

StretchTargetMoney

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

TargetDecimal

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

TargetInteger

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

TargetMoney

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

TimeZoneRuleVersionNumber

Propriété Valeur
Description For internal use only.
DisplayName Time Zone Rule Version Number
Format None
IsValidForForm False
IsValidForRead True
LogicalName timezoneruleversionnumber
MaxValue 2147483647
MinValue -1
RequiredLevel None
Type Integer

Title

Propriété Valeur
Description Type a title or name that describes the goal.
DisplayName Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName title
MaxLength 100
RequiredLevel ApplicationRequired
Type String

UTCConversionTimeZoneCode

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

Colonnes/Attributs en lecture seule

Ces colonnes/attributs renvoient la valeur false pour IsValidForCreate ou IsValidForUpdate. Répertorié par SchemaName.

ActualMoney_Base

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

ActualString

Propriété Valeur
Description Actual Value of the goal.
DisplayName Actual
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName actualstring
MaxLength 100
RequiredLevel None
Type String

ComputedTargetAsOfTodayDecimal

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

ComputedTargetAsOfTodayInteger

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

ComputedTargetAsOfTodayMoney

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

ComputedTargetAsOfTodayMoney_Base

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

ComputedTargetAsOfTodayPercentageAchieved

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

CreatedBy

Propriété Valeur
Description Shows who created the record.
DisplayName Created By
IsValidForForm True
IsValidForRead True
LogicalName createdby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedByName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOn

Propriété Valeur
DateTimeBehavior UserLocal
Description Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName Created On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime

CreatedOnBehalfBy

Propriété Valeur
Description Shows who created the record on behalf of another user.
DisplayName Created By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedOnBehalfByName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOnBehalfByYomiName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

CustomRollupFieldMoney_Base

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

CustomRollupFieldString

Propriété Valeur
Description Placeholder rollup field for the goal.
DisplayName Custom Rollup Field
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName customrollupfieldstring
MaxLength 100
RequiredLevel None
Type String

Depth

Propriété Valeur
Description Depth of the goal in the tree.
DisplayName Depth
Format None
IsValidForForm False
IsValidForRead True
LogicalName depth
MaxValue 2147483647
MinValue 0
RequiredLevel None
Type Integer

EntityImage_Timestamp

Propriété Valeur
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName entityimage_timestamp
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

EntityImage_URL

Propriété Valeur
Description
DisplayName
FormatName Url
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName entityimage_url
MaxLength 200
RequiredLevel None
Type String

EntityImageId

Propriété Valeur
Description For internal use only.
DisplayName Entity Image Id
IsValidForForm False
IsValidForRead True
LogicalName entityimageid
RequiredLevel None
Type Uniqueidentifier

ExchangeRate

Propriété Valeur
Description Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
DisplayName Exchange Rate
IsValidForForm True
IsValidForRead True
LogicalName exchangerate
MaxValue 100000000000
MinValue 0.000000000001
Precision 12
RequiredLevel None
Type Decimal

GoalOwnerIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName goalowneridname
MaxLength 160
RequiredLevel ApplicationRequired
Type String

GoalOwnerIdYomiName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName goalowneridyominame
MaxLength 160
RequiredLevel ApplicationRequired
Type String

GoalWithErrorIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName goalwitherroridname
MaxLength 100
RequiredLevel None
Type String

InProgressMoney_Base

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

InProgressString

Propriété Valeur
Description In-progress value of the goal.
DisplayName In-Progress
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName inprogressstring
MaxLength 100
RequiredLevel None
Type String

MetricIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName metricidname
MaxLength 100
RequiredLevel None
Type String

ModifiedBy

Propriété Valeur
Description Shows who last updated the record.
DisplayName Modified By
IsValidForForm True
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedByName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOn

Propriété Valeur
DateTimeBehavior UserLocal
Description Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName Modified On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime

ModifiedOnBehalfBy

Propriété Valeur
Description Shows who last updated the record on behalf of another user.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedOnBehalfByName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOnBehalfByYomiName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

OwnerIdName

Propriété Valeur
Description Name of the manager
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owneridname
MaxLength 100
RequiredLevel SystemRequired
Type String

OwnerIdYomiName

Propriété Valeur
Description Yomi name of the owner
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owneridyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

OwningBusinessUnit

Propriété Valeur
Description Unique identifier for the business unit that owns the record.
DisplayName Owning Business Unit
IsValidForForm True
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel None
Targets businessunit
Type Lookup

OwningBusinessUnitName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owningbusinessunitname
MaxLength 160
RequiredLevel None
Type String

OwningTeam

Propriété Valeur
Description Unique identifier of the team who owns the goal.
DisplayName Owning Team
IsValidForForm False
IsValidForRead True
LogicalName owningteam
RequiredLevel None
Targets team
Type Lookup

OwningUser

Propriété Valeur
Description Unique identifier for the user who owns the record.
DisplayName Owning User
IsValidForForm False
IsValidForRead True
LogicalName owninguser
RequiredLevel None
Targets systemuser
Type Lookup

ParentGoalIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName parentgoalidname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryActualDecimalIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupqueryactualdecimalidname
MaxLength 100
RequiredLevel None
Type String

RollupQueryActualIntegerIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupqueryactualintegeridname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryActualMoneyIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupqueryactualmoneyidname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryCustomDecimalIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupquerycustomdecimalidname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryCustomIntegerIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupquerycustomintegeridname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryCustomMoneyIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupquerycustommoneyidname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryInprogressDecimalIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupqueryinprogressdecimalidname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryInprogressIntegerIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupqueryinprogressintegeridname
MaxLength 100
RequiredLevel None
Type String

RollUpQueryInprogressMoneyIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName rollupqueryinprogressmoneyidname
MaxLength 100
RequiredLevel None
Type String

StretchTargetMoney_Base

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

StretchTargetString

Propriété Valeur
Description Stretch target value for all data types.
DisplayName Stretched Target
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName stretchtargetstring
MaxLength 100
RequiredLevel None
Type String

TargetMoney_Base

Propriété Valeur
Description Shows the goal target of the money type in base currency.
DisplayName Target (Money) (Base)
IsValidForForm True
IsValidForRead True
LogicalName targetmoney_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

TargetString

Propriété Valeur
Description Target value of the goal.
DisplayName Target
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName targetstring
MaxLength 100
RequiredLevel None
Type String

TransactionCurrencyId

Propriété Valeur
Description Choose the local currency for the record to make sure budgets are reported in the correct currency.
DisplayName Currency
IsValidForForm True
IsValidForRead True
LogicalName transactioncurrencyid
RequiredLevel None
Targets transactioncurrency
Type Lookup

TransactionCurrencyIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName transactioncurrencyidname
MaxLength 100
RequiredLevel None
Type String

TreeId

Propriété Valeur
Description Unique identifier of the goal tree.
DisplayName Tree ID
IsValidForForm False
IsValidForRead True
LogicalName treeid
RequiredLevel None
Type Uniqueidentifier

VersionNumber

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

Relations un-à-plusieurs

Répertorié par SchemaName.

goal_parent_goal

Identique à la relation plusieurs à un goal_parent_goal pour la table/entité goal.

Propriété Valeur
ReferencingEntity goal
ReferencingAttribute parentgoalid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName goal_parent_goal
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 140
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Goal_DuplicateBaseRecord

Identique à la relation plusieurs à un Goal_DuplicateBaseRecord pour la table/entité duplicaterecord.

Propriété Valeur
ReferencingEntity duplicaterecord
ReferencingAttribute baserecordid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Goal_DuplicateBaseRecord
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Goal_RollupError_Goal

Identique à la relation plusieurs à un Goal_RollupError_Goal pour la table/entité goal.

Propriété Valeur
ReferencingEntity goal
ReferencingAttribute goalwitherrorid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Goal_RollupError_Goal
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Goal_SyncErrors

Identique à la relation plusieurs à un Goal_SyncErrors pour la table/entité syncerror.

Propriété Valeur
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Goal_SyncErrors
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

Goal_Annotation

Identique à la relation plusieurs à un Goal_Annotation pour la table/entité annotation.

Propriété Valeur
ReferencingEntity annotation
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Goal_Annotation
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

Goal_AsyncOperations

Identique à la relation plusieurs à un Goal_AsyncOperations pour la table/entité asyncoperation.

Propriété Valeur
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Goal_AsyncOperations
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Goal_ProcessSessions

Identique à la relation plusieurs à un Goal_ProcessSessions pour la table/entité processsession.

Propriété Valeur
ReferencingEntity processsession
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Goal_ProcessSessions
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 110
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

goal_connections1

Identique à la relation plusieurs à un goal_connections1 pour la table/entité connection.

Propriété Valeur
ReferencingEntity connection
ReferencingAttribute record1id
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName goal_connections1
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 100
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

goal_connections2

Identique à la relation plusieurs à un goal_connections2 pour la table/entité connection.

Propriété Valeur
ReferencingEntity connection
ReferencingAttribute record2id
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName goal_connections2
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order: 100
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Goal_DuplicateMatchingRecord

Identique à la relation plusieurs à un Goal_DuplicateMatchingRecord pour la table/entité duplicaterecord.

Propriété Valeur
ReferencingEntity duplicaterecord
ReferencingAttribute duplicaterecordid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Goal_DuplicateMatchingRecord
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

goal_principalobjectattributeaccess

Identique à la relation plusieurs à un goal_principalobjectattributeaccess pour la table/entité principalobjectattributeaccess.

Propriété Valeur
ReferencingEntity principalobjectattributeaccess
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName goal_principalobjectattributeaccess
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Relations plusieurs-à-un

Chaque relation plusieurs-à-un est définie par une relation un-à-plusieurs correspondante avec la table associée. Répertorié par SchemaName.

team_goal

Voir la relation un à plusieurs team_goal pour la table/entité team.

goalrollupquery_actualint

Voir la relation un à plusieurs goalrollupquery_actualint pour la table/entité goalrollupquery.

goal_rollupquery_actualmoney

Voir la relation un à plusieurs goal_rollupquery_actualmoney pour la table/entité goalrollupquery.

goal_rollupquery_actualdecimal

Voir la relation un à plusieurs goal_rollupquery_actualdecimal pour la table/entité goalrollupquery.

goal_rollupquery_customint

Voir la relation un à plusieurs goal_rollupquery_customint pour la table/entité goalrollupquery.

goal_rollupquery_custommoney

Voir la relation un à plusieurs goal_rollupquery_custommoney pour la table/entité goalrollupquery.

goal_rollupquery_customdecimal

Voir la relation un à plusieurs goal_rollupquery_customdecimal pour la table/entité goalrollupquery.

goal_rollupquery_inprogressint

Voir la relation un à plusieurs goal_rollupquery_inprogressint pour la table/entité goalrollupquery.

goal_rollupquery_inprogressmoney

Voir la relation un à plusieurs goal_rollupquery_inprogressmoney pour la table/entité goalrollupquery.

goal_rollupquery_inprogressdecimal

Voir la relation un à plusieurs goal_rollupquery_inprogressdecimal pour la table/entité goalrollupquery.

lk_goal_createdby

Voir la relation un à plusieurs lk_goal_createdby pour la table/entité systemuser.

lk_goal_createdonbehalfby

Voir la relation un à plusieurs lk_goal_createdonbehalfby pour la table/entité systemuser.

lk_goal_modifiedby

Voir la relation un à plusieurs lk_goal_modifiedby pour la table/entité systemuser.

lk_goal_modifiedonbehalfby

Voir la relation un à plusieurs lk_goal_modifiedonbehalfby pour la table/entité systemuser.

user_goal

Voir la relation un à plusieurs user_goal pour la table/entité systemuser.

business_unit_goal

Voir la relation un à plusieurs business_unit_goal pour la table/entité businessunit.

user_goal_goalowner

Voir la relation un à plusieurs user_goal_goalowner pour la table/entité systemuser.

goal_parent_goal

Voir la relation un à plusieurs goal_parent_goal pour la table/entité goal.

TransactionCurrency_Goal

Voir la relation un à plusieurs TransactionCurrency_Goal pour la table/entité transactioncurrency.

metric_goal

Voir la relation un à plusieurs metric_goal pour la table/entité metric.

Goal_RollupError_Goal

Voir la relation un à plusieurs Goal_RollupError_Goal pour la table/entité goal.

team_goal_goalowner

Voir la relation un à plusieurs team_goal_goalowner pour la table/entité team.

Voir aussi

Référence d’entité/de table Dataverse Référence d’API web goal EntityType