goal EntityType

 

Applies To: Dynamics 365 (online), Dynamics 365 (on-premises), Dynamics CRM 2016, Dynamics CRM Online

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

Entity Set path:[organization URI]/api/data/v8.2/goals

Base Type: crmbaseentity EntityType

Display Name: Goal

Primary Key: goalid

Primary Name Attribute: title

Properties

Lookup Properties

Single-valued navigation properties

Collection-valued navigation properties

Operations bound to goal

Operations using the goal entity type.

Properties

Properties represent fields of data stored in the entity. Some properties are read-only.

Name

Type

Details

actualdecimal

Edm.Decimal

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.

Display Name: Actual (Decimal)

actualinteger

Edm.Int32

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.

Display Name: Actual (Integer)

actualmoney

Edm.Decimal

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.

Display Name: Actual (Money)

actualmoney_base

Edm.Decimal

Description: Shows the actual value (money type) in base currency to track goal results against the target.

Display Name: Actual (Money) (Base)

Read-only property

actualstring

Edm.String

Description: Actual Value of the goal.

Display Name: Actual

Read-only property

amountdatatype

Edm.Int32

Description: Data type of the amount.

Default Options:

0 : Money
1 : Decimal
2 : Integer

Display Name: Amount Data Type

computedtargetasoftodaydecimal

Edm.Decimal

Description: Shows the expected amount for actual value (decimal type) against the target goal.

Display Name: Today's Target (Decimal)

Read-only property

computedtargetasoftodayinteger

Edm.Int32

Description: Shows the expected amount for actual value (integer type) against the target goal as of the current date.

Display Name: Today's Target (Integer)

Read-only property

computedtargetasoftodaymoney

Edm.Decimal

Description: Shows the expected amount for actual value (money type) against the target goal as of the current date.

Display Name: Today's Target (Money)

Read-only property

computedtargetasoftodaymoney_base

Edm.Decimal

Description: Shows the expected amount in base currency for actual value (money type) against the target goal as of the current date.

Display Name: Today's Target (Money) (Base)

Read-only property

computedtargetasoftodaypercentageachieved

Edm.Decimal

Description: Shows the expected value for percentage achieved against the target goal as of the current date.

Display Name: Today's Target (Percentage Achieved)

Read-only property

consideronlygoalownersrecords

Edm.Boolean

Description: Select whether only the goal owner's records, or all records, should be rolled up for goal results.

Default Options:

1 : Owned by goal owner
0 : All

Display Name: Record Set for Rollup

createdon

Edm.DateTimeOffset

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.

Display Name: Created On

Read-only property

customrollupfielddecimal

Edm.Decimal

Description: Indicates a placeholder rollup field for a decimal value to track a third category of results other than actuals and in-progress results.

Display Name: Custom Rollup Field (Decimal)

customrollupfieldinteger

Edm.Int32

Description: Indicates a placeholder rollup field for an integer value to track a third category of results other than actuals and in-progress results.

Display Name: Custom Rollup Field (Integer)

customrollupfieldmoney

Edm.Decimal

Description: Indicates a placeholder rollup field for a money value to track a third category of results other than actuals and in-progress results.

Display Name: Custom Rollup Field (Money)

customrollupfieldmoney_base

Edm.Decimal

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.

Display Name: Custom Rollup Field (Money) (Base)

Read-only property

customrollupfieldstring

Edm.String

Description: Placeholder rollup field for the goal.

Display Name: Custom Rollup Field

Read-only property

depth

Edm.Int32

Description: Depth of the goal in the tree.

Display Name: Depth

Read-only property

entityimage

Edm.Binary

Description: The default image for the entity.

Display Name: Entity Image

entityimage_timestamp

Edm.Int64

Description:

Read-only property

entityimage_url

Edm.String

Description:

Read-only property

entityimageid

Edm.Guid

Description: For internal use only.

Display Name: Entity Image Id

Read-only property

exchangerate

Edm.Decimal

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.

Display Name: Exchange Rate

Read-only property

fiscalperiod

Edm.Int32

Description: Select the fiscal period for the goal.

Default Options:

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

Display Name: Fiscal Period

fiscalyear

Edm.Int32

Description: Select the fiscal year for the goal that's being tracked.

Default Options:

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

Display Name: Fiscal Year

goalenddate

Edm.DateTimeOffset

Description: Enter the date when the goal ends.

Display Name: To

goalid

Edm.Guid

Description: Unique identifier of the goal.

Display Name: Goal

goalstartdate

Edm.DateTimeOffset

Description: Enter the date and time when the period for tracking the goal begins.

Display Name: From

importsequencenumber

Edm.Int32

Description: Sequence number of the import that created this record.

Display Name: Import Sequence Number

inprogressdecimal

Edm.Decimal

Description: Shows the in-progress value (decimal) against the target. This value could contribute to a goal, but is not counted yet as actual.

Display Name: In-progress (Decimal)

inprogressinteger

Edm.Int32

Description: Shows the in-progress value (integer) against the target. This value could contribute to a goal, but is not counted yet as actual.

Display Name: In-progress (Integer)

inprogressmoney

Edm.Decimal

Description: Shows the in-progress value (money) against the target. This value could contribute to a goal, but is not counted yet as actual.

Display Name: In-progress (Money)

inprogressmoney_base

Edm.Decimal

Description: Shows the in-progress value (money) in base currency to track goal results against the target.

Display Name: In-progress (Money) (Base)

Read-only property

inprogressstring

Edm.String

Description: In-progress value of the goal.

Display Name: In-Progress

Read-only property

isamount

Edm.Boolean

Description: Indicates whether the metric type is Count or Amount.

Default Options:

1 : Amount
0 : Count

Display Name: Metric Type

isfiscalperiodgoal

Edm.Boolean

Description: Select whether the goal period is a fiscal period or custom period.

Default Options:

1 : Fiscal Period
0 : Custom Period

Display Name: Goal Period Type

isoverridden

Edm.Boolean

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.

Default Options:

1 : Yes
0 : No

Display Name: Overridden

isoverride

Edm.Boolean

Description: Indicates whether the values of system rollup fields can be updated.

Default Options:

1 : Yes
0 : No

Display Name: Override

lastrolledupdate

Edm.DateTimeOffset

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.

Display Name: Last Rolled Up Date

modifiedon

Edm.DateTimeOffset

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.

Display Name: Modified On

Read-only property

overriddencreatedon

Edm.DateTimeOffset

Description: Date and time that the record was migrated.

Display Name: Record Created On

percentage

Edm.Decimal

Description: Shows the percentage achieved against the target goal.

Display Name: Percentage Achieved

rolluperrorcode

Edm.Int32

Description: Error code associated with rollup.

Display Name: Rollup Error Code

rolluponlyfromchildgoals

Edm.Boolean

Description: Select whether the data should be rolled up only from the child goals.

Default Options:

1 : Yes
0 : No

Display Name: Roll Up Only from Child Goals

statecode

Edm.Int32

Description: Shows whether the goal is open, completed, or canceled. Completed and canceled goals are read-only and can't be edited.

Default Options:

0 : Active
1 : Inactive

Display Name: Status

statuscode

Edm.Int32

Description: Select the goal's status.

Default Options:

0 : Open
1 : Closed
2 : Discarded

Display Name: Status Reason

stretchtargetdecimal

Edm.Decimal

Description: Select a stretch target (decimal) of the goal to define a higher or difficult level of goal than the usual ones.

Display Name: Stretch Target (Decimal)

stretchtargetinteger

Edm.Int32

Description: Select the stretch target (integer) of the goal to define a higher or difficult level of goal than the usual ones.

Display Name: Stretch Target (Integer)

stretchtargetmoney

Edm.Decimal

Description: Select stretch target (money) of the goal to define a higher or difficult level of goal than the usual ones.

Display Name: Stretch Target (Money)

stretchtargetmoney_base

Edm.Decimal

Description: Shows the stretch target (money) in base currency to indicate a higher or difficult level of goal than the usual ones.

Display Name: Stretch Target (Money) (Base)

Read-only property

stretchtargetstring

Edm.String

Description: Stretch target value for all data types.

Display Name: Stretched Target

Read-only property

targetdecimal

Edm.Decimal

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.

Display Name: Target (Decimal)

targetinteger

Edm.Int32

Description: Select a goal target of the integer type to use for tracking anything countable in whole numbers, such as units sold.

Display Name: Target (Integer)

targetmoney

Edm.Decimal

Description: Select a goal target (money) to track a monetary amount such as revenue from a product.

Display Name: Target (Money)

targetmoney_base

Edm.Decimal

Description: Shows the goal target of the money type in base currency.

Display Name: Target (Money) (Base)

Read-only property

targetstring

Edm.String

Description: Target value of the goal.

Display Name: Target

Read-only property

timezoneruleversionnumber

Edm.Int32

Description: For internal use only.

Display Name: Time Zone Rule Version Number

title

Edm.String

Description: Type a title or name that describes the goal.

Display Name: Name

treeid

Edm.Guid

Description: Unique identifier of the goal tree.

Display Name: Tree ID

Read-only property

utcconversiontimezonecode

Edm.Int32

Description: Time zone code that was in use when the record was created.

Display Name: UTC Conversion Time Zone Code

versionnumber

Edm.Int64

Description: Version number of the goal.

Display Name: Version Number

Read-only property

Lookup Properties

Lookup properties are read-only, computed properties which contain entity primary key Edm.Guid data for one or more corresponding single-valued navigation properties. More information: Lookup properties and Retrieve data about lookup properties

Name

Single-valued navigation property

Description

_createdby_value

createdby

Shows who created the record.

_createdonbehalfby_value

createdonbehalfby

Shows who created the record on behalf of another user.

_goalownerid_value

goalownerid_systemuser

goalownerid_team

Choose the user or team responsible for meeting the goal.

_goalwitherrorid_value

goalwitherrorid

Unique identifier of the goal that caused an error in the rollup of the goal hierarchy.

_metricid_value

metricid

Choose the metric for the goal. This metric determines how the goal is tracked.

_modifiedby_value

modifiedby

Shows who last updated the record.

_modifiedonbehalfby_value

modifiedonbehalfby

Shows who last updated the record on behalf of another user.

_ownerid_value

ownerid

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.

_owningbusinessunit_value

owningbusinessunit

Unique identifier for the business unit that owns the record.

_owningteam_value

owningteam

Unique identifier of the team who owns the goal.

_owninguser_value

owninguser

Unique identifier for the user who owns the record.

_parentgoalid_value

parentgoalid

Choose a parent goal if the current goal is a child goal. This sets up a parent-child relationship for reporting and analytics.

_rollupqueryactualdecimalid_value

rollupqueryactualdecimalid

Choose the query that will be used to calculate the actual data for the goal (decimal).

_rollupqueryactualintegerid_value

rollupqueryactualintegerid

Choose the query that will be used to calculate the actual data for the goal (integer).

_rollupqueryactualmoneyid_value

rollupqueryactualmoneyid

Choose the query that will be used to calculate the actual data for the goal (money).

_rollupquerycustomdecimalid_value

rollupquerycustomdecimalid

Choose the query that will be used to calculate data for the custom rollup field (decimal).

_rollupquerycustomintegerid_value

rollupquerycustomintegerid

Choose the query that will be used to calculate data for the custom rollup field (integer).

_rollupquerycustommoneyid_value

rollupquerycustommoneyid

Choose the query that will be used to calculate data for the custom rollup field (money).

_rollupqueryinprogressdecimalid_value

rollupqueryinprogressdecimalid

Choose the query that will be used to calculate data for the in-progress rollup field (decimal).

_rollupqueryinprogressintegerid_value

rollupqueryinprogressintegerid

Choose the query that will be used to calculate data for the in-progress rollup field (integer).

_rollupqueryinprogressmoneyid_value

rollupqueryinprogressmoneyid

Choose the query that will be used to calculate data for the in-progress rollup field (money).

_transactioncurrencyid_value

transactioncurrencyid

Choose the local currency for the record to make sure budgets are reported in the correct currency.

Single-valued navigation properties

Single-valued navigation properties represent lookup fields where a single entity can be referenced. Each single-valued navigation property has a corresponding partner collection-valued navigation property on the related entity.

Name

Type

Partner

createdby

systemuser EntityType

lk_goal_createdby

createdonbehalfby

systemuser EntityType

lk_goal_createdonbehalfby

goalownerid_systemuser

systemuser EntityType

user_goal_goalowner

goalownerid_team

team EntityType

team_goal_goalowner

goalwitherrorid

goal EntityType

Goal_RollupError_Goal

metricid

metric EntityType

metric_goal

modifiedby

systemuser EntityType

lk_goal_modifiedby

modifiedonbehalfby

systemuser EntityType

lk_goal_modifiedonbehalfby

ownerid

principal EntityType

owner_goal

owningbusinessunit

businessunit EntityType

business_unit_goal

owningteam

team EntityType

team_goal

owninguser

systemuser EntityType

user_goal

parentgoalid

goal EntityType

goal_parent_goal

rollupqueryactualdecimalid

goalrollupquery EntityType

goal_rollupquery_actualdecimal

rollupqueryactualintegerid

goalrollupquery EntityType

goalrollupquery_actualint

rollupqueryactualmoneyid

goalrollupquery EntityType

goal_rollupquery_actualmoney

rollupquerycustomdecimalid

goalrollupquery EntityType

goal_rollupquery_customdecimal

rollupquerycustomintegerid

goalrollupquery EntityType

goal_rollupquery_customint

rollupquerycustommoneyid

goalrollupquery EntityType

goal_rollupquery_custommoney

rollupqueryinprogressdecimalid

goalrollupquery EntityType

goal_rollupquery_inprogressdecimal

rollupqueryinprogressintegerid

goalrollupquery EntityType

goal_rollupquery_inprogressint

rollupqueryinprogressmoneyid

goalrollupquery EntityType

goal_rollupquery_inprogressmoney

transactioncurrencyid

transactioncurrency EntityType

TransactionCurrency_Goal

Collection-valued navigation properties

Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.

Name

Type

Partner

Goal_Annotation

annotation EntityType

objectid_goal

Goal_AsyncOperations

asyncoperation EntityType

regardingobjectid_goal

goal_connections1

connection EntityType

record1id_goal

goal_connections2

connection EntityType

record2id_goal

Goal_DuplicateBaseRecord

duplicaterecord EntityType

baserecordid_goal

Goal_DuplicateMatchingRecord

duplicaterecord EntityType

duplicaterecordid_goal

goal_parent_goal

goal EntityType

parentgoalid

Goal_RollupError_Goal

goal EntityType

goalwitherrorid

Goal_SyncErrors

syncerror EntityType

regardingobjectid_goal_syncerror

Operations bound to goal

The following operations are bound to the goal entity type.

Name

Bound to

Recalculate Action

Entity

Operations using the goal entity type.

The following operations use the goal entity type in a parameter or return type.

Name

How used

Description

Recalculate Action

entity Parameter

Recalculate system-computed values for rollup fields in the goal hierarchy.

See Also

Use the Microsoft Dynamics 365 Web API
Web API Action Reference
Web API Function Reference
Web API Query Function Reference
Web API EnumType Reference
Web API ComplexType Reference
Web API Metadata EntityType Reference

Microsoft Dynamics 365

© 2016 Microsoft. All rights reserved. Copyright