Nóta
Aðgangur að þessari síðu krefst heimildar. Þú getur prófað aðskrá þig inn eða breyta skráasöfnum.
Aðgangur að þessari síðu krefst heimildar. Þú getur prófað að breyta skráasöfnum.
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 |
|---|---|---|
AssignEvent: True |
PATCH /goals(goalid)Update the ownerid property. |
AssignRequest |
AssociateEvent: True |
Associate records | Associate records |
CreateEvent: True |
POST /goalsSee Create |
Create records |
DeleteEvent: True |
DELETE /goals(goalid)See Delete |
Delete records |
DisassociateEvent: True |
Disassociate records | Disassociate records |
GrantAccessEvent: True |
GrantAccess | GrantAccessRequest |
ModifyAccessEvent: True |
ModifyAccess | ModifyAccessRequest |
RecalculateEvent: True |
Recalculate | RecalculateRequest |
RetrieveEvent: True |
GET /goals(goalid)See Retrieve |
Retrieve records |
RetrieveMultipleEvent: True |
GET /goalsSee Query data |
Query data |
RetrievePrincipalAccessEvent: True |
RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccessEvent: True |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccessEvent: True |
RevokeAccess | RevokeAccessRequest |
SetStateEvent: True |
PATCH /goals(goalid)Update the statecode and statuscode properties. |
SetStateRequest |
UpdateEvent: True |
PATCH /goals(goalid)See Update |
Update records |
UpsertEvent: 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: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
goalrollupquery_actualint
One-To-Many Relationship: goalrollupquery goalrollupquery_actualint
| Property | Value |
|---|---|
| ReferencedEntity | goalrollupquery |
| ReferencedAttribute | goalrollupqueryid |
| ReferencingAttribute | rollupqueryactualintegerid |
| ReferencingEntityNavigationPropertyName | rollupqueryactualintegerid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
metric_goal
One-To-Many Relationship: metric metric_goal
| Property | Value |
|---|---|
| ReferencedEntity | metric |
| ReferencedAttribute | metricid |
| ReferencingAttribute | metricid |
| ReferencingEntityNavigationPropertyName | metricid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
owner_goal
One-To-Many Relationship: owner owner_goal
| Property | Value |
|---|---|
| ReferencedEntity | owner |
| ReferencedAttribute | ownerid |
| ReferencingAttribute | ownerid |
| ReferencingEntityNavigationPropertyName | ownerid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
team_goal
One-To-Many Relationship: team team_goal
| Property | Value |
|---|---|
| ReferencedEntity | team |
| ReferencedAttribute | teamid |
| ReferencingAttribute | owningteam |
| ReferencingEntityNavigationPropertyName | owningteam |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
TransactionCurrency_Goal
One-To-Many Relationship: transactioncurrency TransactionCurrency_Goal
| Property | Value |
|---|---|
| ReferencedEntity | transactioncurrency |
| ReferencedAttribute | transactioncurrencyid |
| ReferencingAttribute | transactioncurrencyid |
| ReferencingEntityNavigationPropertyName | transactioncurrencyid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
user_goal
One-To-Many Relationship: systemuser user_goal
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | owninguser |
| ReferencingEntityNavigationPropertyName | owninguser |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: UseCollectionNameGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: UseCollectionNameGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: UseCollectionNameGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
See also
Dataverse table/entity reference
Dataverse Web API Reference
goal