Goal table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Target objective for a user or a team for a specified time period.
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
Assign | PATCH /goals(goalid) Update ownerid property. |
AssignRequest |
Create | POST /goals See Create |
CreateRequest or Create |
Delete | DELETE /goals(goalid) See Delete |
DeleteRequest or Delete |
GrantAccess | GrantAccess | GrantAccessRequest |
ModifyAccess | ModifyAccess | ModifyAccessRequest |
Recalculate | Recalculate | RecalculateRequest |
Retrieve | GET /goals(goalid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /goals See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
RetrievePrincipalAccess | RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess | RevokeAccess | RevokeAccessRequest |
SetState | PATCH /goals(goalid) Update statecode and statuscode properties. |
SetStateRequest |
Update | PATCH /goals(goalid) See Update |
UpdateRequest or Update |
Properties
Property | Value |
---|---|
CollectionSchemaName | Goals |
DisplayCollectionName | Goals |
DisplayName | Goal |
EntitySetName | goals |
IsBPFEntity | False |
LogicalCollectionName | goals |
LogicalName | goal |
OwnershipType | UserOwned |
PrimaryIdAttribute | goalid |
PrimaryNameAttribute | title |
SchemaName | Goal |
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 |
MaxValue | 100000000000 |
MinValue | -100000000000 |
Precision | 10 |
RequiredLevel | None |
Type | Decimal |
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) |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | actualinteger |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
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 |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
AmountDataType
Property | Value |
---|---|
Description | Data type of the amount. |
DisplayName | Amount Data Type |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | amountdatatype |
RequiredLevel | None |
Type | Picklist |
AmountDataType Choices/Options
Value | Label | Description |
---|---|---|
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 |
ConsiderOnlyGoalOwnersRecords Choices/Options
Value | Label | Description |
---|---|---|
1 | Owned by goal owner | |
0 | All |
DefaultValue: 1
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 |
MaxValue | 100000000000 |
MinValue | -100000000000 |
Precision | 10 |
RequiredLevel | None |
Type | Decimal |
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) |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | customrollupfieldinteger |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
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 |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
EntityImage
Property | Value |
---|---|
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
Property | Value |
---|---|
Description | Select the fiscal period for the goal. |
DisplayName | Fiscal Period |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | fiscalperiod |
RequiredLevel | None |
Type | Picklist |
FiscalPeriod Choices/Options
Value | Label | 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
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 |
FiscalYear Choices/Options
Value | Label | 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
Property | Value |
---|---|
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
Property | Value |
---|---|
Description | Unique identifier of the goal. |
DisplayName | Goal |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
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 |
Targets | systemuser,team |
Type | Lookup |
GoalOwnerIdType
Property | Value |
---|---|
Description | |
DisplayName | Goal Owner Type |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | goalowneridtype |
RequiredLevel | ApplicationRequired |
Type | EntityName |
GoalStartDate
Property | Value |
---|---|
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
Property | Value |
---|---|
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
Property | Value |
---|---|
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
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 |
MaxValue | 100000000000 |
MinValue | -100000000000 |
Precision | 10 |
RequiredLevel | None |
Type | Decimal |
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) |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | inprogressinteger |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
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 |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
IsAmount
Property | Value |
---|---|
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 |
IsAmount Choices/Options
Value | Label | Description |
---|---|---|
1 | Amount | |
0 | Count |
DefaultValue: 1
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 |
IsFiscalPeriodGoal Choices/Options
Value | Label | Description |
---|---|---|
1 | Fiscal Period | |
0 | Custom Period |
DefaultValue: 1
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 |
IsOverridden Choices/Options
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
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 |
IsOverride Choices/Options
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
LastRolledupDate
Property | Value |
---|---|
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
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 |
Targets | metric |
Type | Lookup |
OverriddenCreatedOn
Property | Value |
---|---|
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
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 |
Targets | systemuser |
Type | Owner |
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 |
Targets | goal |
Type | Lookup |
Percentage
Property | Value |
---|---|
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
Property | Value |
---|---|
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
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 |
RollupOnlyFromChildGoals Choices/Options
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
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 |
Targets | goalrollupquery |
Type | Lookup |
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 |
Targets | goalrollupquery |
Type | Lookup |
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 |
Targets | goalrollupquery |
Type | Lookup |
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 |
Targets | goalrollupquery |
Type | Lookup |
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 |
Targets | goalrollupquery |
Type | Lookup |
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 |
Targets | goalrollupquery |
Type | Lookup |
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 |
Targets | goalrollupquery |
Type | Lookup |
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 |
Targets | goalrollupquery |
Type | Lookup |
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 |
Targets | goalrollupquery |
Type | Lookup |
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 |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
StateCode Choices/Options
Value | Label | DefaultStatus | InvariantName |
---|---|---|---|
0 | Active | 0 | Active |
1 | Inactive | 1 | Inactive |
StatusCode
Property | Value |
---|---|
Description | Select the goal's status. |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
StatusCode Choices/Options
Value | Label | State |
---|---|---|
0 | Open | 0 |
1 | Closed | 1 |
2 | Discarded | 1 |
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 |
MaxValue | 100000000000 |
MinValue | 0 |
Precision | 2 |
RequiredLevel | None |
Type | Decimal |
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) |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | stretchtargetinteger |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
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 |
MaxValue | 922337203685477 |
MinValue | 0 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
MaxValue | 100000000000 |
MinValue | 0 |
Precision | 2 |
RequiredLevel | None |
Type | Decimal |
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) |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | targetinteger |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
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 |
MaxValue | 922337203685477 |
MinValue | 0 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TimeZoneRuleVersionNumber
Property | Value |
---|---|
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
Property | Value |
---|---|
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
Property | Value |
---|---|
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 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- ActualMoney_Base
- ActualString
- ComputedTargetAsOfTodayDecimal
- ComputedTargetAsOfTodayInteger
- ComputedTargetAsOfTodayMoney
- ComputedTargetAsOfTodayMoney_Base
- ComputedTargetAsOfTodayPercentageAchieved
- CreatedBy
- CreatedByName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- CustomRollupFieldMoney_Base
- CustomRollupFieldString
- Depth
- EntityImage_Timestamp
- EntityImage_URL
- EntityImageId
- ExchangeRate
- GoalOwnerIdName
- GoalOwnerIdYomiName
- GoalWithErrorIdName
- InProgressMoney_Base
- InProgressString
- MetricIdName
- ModifiedBy
- ModifiedByName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- ParentGoalIdName
- RollUpQueryActualDecimalIdName
- RollupQueryActualIntegerIdName
- RollUpQueryActualMoneyIdName
- RollUpQueryCustomDecimalIdName
- RollUpQueryCustomIntegerIdName
- RollUpQueryCustomMoneyIdName
- RollUpQueryInprogressDecimalIdName
- RollUpQueryInprogressIntegerIdName
- RollUpQueryInprogressMoneyIdName
- StretchTargetMoney_Base
- StretchTargetString
- TargetMoney_Base
- TargetString
- TransactionCurrencyId
- TransactionCurrencyIdName
- 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 |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
ActualString
Property | Value |
---|---|
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
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 |
MaxValue | 100000000000 |
MinValue | 0 |
Precision | 2 |
RequiredLevel | None |
Type | Decimal |
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) |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | computedtargetasoftodayinteger |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
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 |
MaxValue | 922337203685477 |
MinValue | 0 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
MaxValue | 100000000000 |
MinValue | 0 |
Precision | 0 |
RequiredLevel | None |
Type | Decimal |
CreatedBy
Property | Value |
---|---|
Description | Shows who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
CreatedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOn
Property | Value |
---|---|
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
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 |
Targets | systemuser |
Type | Lookup |
CreatedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
CustomRollupFieldString
Property | Value |
---|---|
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
Property | Value |
---|---|
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
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage_timestamp |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
EntityImage_URL
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Url |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage_url |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
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 |
MaxValue | 100000000000 |
MinValue | 0.000000000001 |
Precision | 12 |
RequiredLevel | None |
Type | Decimal |
GoalOwnerIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | goalowneridname |
MaxLength | 160 |
RequiredLevel | ApplicationRequired |
Type | String |
GoalOwnerIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | goalowneridyominame |
MaxLength | 160 |
RequiredLevel | ApplicationRequired |
Type | String |
GoalWithErrorIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | goalwitherroridname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
InProgressString
Property | Value |
---|---|
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
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | metricidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedBy
Property | Value |
---|---|
Description | Shows who last updated the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
ModifiedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOn
Property | Value |
---|---|
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
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 |
Targets | systemuser |
Type | Lookup |
ModifiedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
OwnerIdName
Property | Value |
---|---|
Description | Name of the manager |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwnerIdYomiName
Property | Value |
---|---|
Description | Yomi name of the owner |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
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 |
Targets | businessunit |
Type | Lookup |
OwningBusinessUnitName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunitname |
MaxLength | 160 |
RequiredLevel | None |
Type | String |
OwningTeam
Property | Value |
---|---|
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
Property | Value |
---|---|
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
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | parentgoalidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
RollUpQueryActualDecimalIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | rollupqueryactualdecimalidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
RollupQueryActualIntegerIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | rollupqueryactualintegeridname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
RollUpQueryActualMoneyIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | rollupqueryactualmoneyidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
RollUpQueryCustomDecimalIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | rollupquerycustomdecimalidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
RollUpQueryCustomIntegerIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | rollupquerycustomintegeridname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
RollUpQueryCustomMoneyIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | rollupquerycustommoneyidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
RollUpQueryInprogressDecimalIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | rollupqueryinprogressdecimalidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
RollUpQueryInprogressIntegerIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | rollupqueryinprogressintegeridname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
RollUpQueryInprogressMoneyIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | rollupqueryinprogressmoneyidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
StretchTargetString
Property | Value |
---|---|
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
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 |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TargetString
Property | Value |
---|---|
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
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 |
Targets | transactioncurrency |
Type | Lookup |
TransactionCurrencyIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | transactioncurrencyidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
- goal_parent_goal
- Goal_DuplicateBaseRecord
- Goal_RollupError_Goal
- Goal_SyncErrors
- Goal_Annotation
- Goal_AsyncOperations
- Goal_ProcessSessions
- goal_connections1
- goal_connections2
- Goal_DuplicateMatchingRecord
- goal_principalobjectattributeaccess
goal_parent_goal
Same as the goal_parent_goal many-to-one relationship for the goal table/entity.
Property | Value |
---|---|
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
Same as the Goal_DuplicateBaseRecord many-to-one relationship for the duplicaterecord table/entity.
Property | Value |
---|---|
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
Same as the Goal_RollupError_Goal many-to-one relationship for the goal table/entity.
Property | Value |
---|---|
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
Same as the Goal_SyncErrors many-to-one relationship for the syncerror table/entity.
Property | Value |
---|---|
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
Same as the Goal_Annotation many-to-one relationship for the annotation table/entity.
Property | Value |
---|---|
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
Same as the Goal_AsyncOperations many-to-one relationship for the asyncoperation table/entity.
Property | Value |
---|---|
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
Same as the Goal_ProcessSessions many-to-one relationship for the processsession table/entity.
Property | Value |
---|---|
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
Same as the goal_connections1 many-to-one relationship for the connection table/entity.
Property | Value |
---|---|
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
Same as the goal_connections2 many-to-one relationship for the connection table/entity.
Property | Value |
---|---|
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
Same as the Goal_DuplicateMatchingRecord many-to-one relationship for the duplicaterecord table/entity.
Property | Value |
---|---|
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
Same as the goal_principalobjectattributeaccess many-to-one relationship for the principalobjectattributeaccess table/entity.
Property | Value |
---|---|
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 |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- team_goal
- goalrollupquery_actualint
- goal_rollupquery_actualmoney
- goal_rollupquery_actualdecimal
- goal_rollupquery_customint
- goal_rollupquery_custommoney
- goal_rollupquery_customdecimal
- goal_rollupquery_inprogressint
- goal_rollupquery_inprogressmoney
- goal_rollupquery_inprogressdecimal
- lk_goal_createdby
- lk_goal_createdonbehalfby
- lk_goal_modifiedby
- lk_goal_modifiedonbehalfby
- user_goal
- business_unit_goal
- user_goal_goalowner
- goal_parent_goal
- TransactionCurrency_Goal
- metric_goal
- Goal_RollupError_Goal
- team_goal_goalowner
team_goal
See the team_goal one-to-many relationship for the team table/entity.
goalrollupquery_actualint
See the goalrollupquery_actualint one-to-many relationship for the goalrollupquery table/entity.
goal_rollupquery_actualmoney
See the goal_rollupquery_actualmoney one-to-many relationship for the goalrollupquery table/entity.
goal_rollupquery_actualdecimal
See the goal_rollupquery_actualdecimal one-to-many relationship for the goalrollupquery table/entity.
goal_rollupquery_customint
See the goal_rollupquery_customint one-to-many relationship for the goalrollupquery table/entity.
goal_rollupquery_custommoney
See the goal_rollupquery_custommoney one-to-many relationship for the goalrollupquery table/entity.
goal_rollupquery_customdecimal
See the goal_rollupquery_customdecimal one-to-many relationship for the goalrollupquery table/entity.
goal_rollupquery_inprogressint
See the goal_rollupquery_inprogressint one-to-many relationship for the goalrollupquery table/entity.
goal_rollupquery_inprogressmoney
See the goal_rollupquery_inprogressmoney one-to-many relationship for the goalrollupquery table/entity.
goal_rollupquery_inprogressdecimal
See the goal_rollupquery_inprogressdecimal one-to-many relationship for the goalrollupquery table/entity.
lk_goal_createdby
See the lk_goal_createdby one-to-many relationship for the systemuser table/entity.
lk_goal_createdonbehalfby
See the lk_goal_createdonbehalfby one-to-many relationship for the systemuser table/entity.
lk_goal_modifiedby
See the lk_goal_modifiedby one-to-many relationship for the systemuser table/entity.
lk_goal_modifiedonbehalfby
See the lk_goal_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
user_goal
See the user_goal one-to-many relationship for the systemuser table/entity.
business_unit_goal
See the business_unit_goal one-to-many relationship for the businessunit table/entity.
user_goal_goalowner
See the user_goal_goalowner one-to-many relationship for the systemuser table/entity.
goal_parent_goal
See the goal_parent_goal one-to-many relationship for the goal table/entity.
TransactionCurrency_Goal
See the TransactionCurrency_Goal one-to-many relationship for the transactioncurrency table/entity.
metric_goal
See the metric_goal one-to-many relationship for the metric table/entity.
Goal_RollupError_Goal
See the Goal_RollupError_Goal one-to-many relationship for the goal table/entity.
team_goal_goalowner
See the team_goal_goalowner one-to-many relationship for the team table/entity.
See also
Dataverse table/entity reference
Web API Reference
goal EntityType