Goal テーブル/エンティティの参照
注意
テーブルとエンティティの違いについて不明な点がありますか? 開発者: Microsoft Dataverse の用語を理解するを参照してください。
Target objective for a user or a team for a specified time period.
メッセージ
| メッセージ | Web API 操作 | SDK クラスまたはメソッド |
|---|---|---|
| Assign | PATCH [org URI]/api/data/v9.0/goals(goalid)owneridのプロパティを更新する。 |
AssignRequest |
| Create | POST [org URI]/api/data/v9.0/goals 作成を参照 |
CreateRequest または Create |
| Delete | DELETE [org URI]/api/data/v9.0/goals(goalid) 削除を参照 |
DeleteRequest または Delete |
| GrantAccess | GrantAccess Action | GrantAccessRequest |
| ModifyAccess | ModifyAccess Action | ModifyAccessRequest |
| Recalculate | Recalculate Action | RecalculateRequest |
| Retrieve | GET [org URI]/api/data/v9.0/goals(goalid) 取得を参照 |
RetrieveRequest または Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/goals データのクエリを参照 |
RetrieveMultipleRequest または RetrieveMultiple |
| RetrievePrincipalAccess | RetrievePrincipalAccess Function | RetrievePrincipalAccessRequest |
| RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess Function | RetrieveSharedPrincipalsAndAccessRequest |
| RevokeAccess | RevokeAccess Action | RevokeAccessRequest |
| SetState | PATCH [org URI]/api/data/v9.0/goals(goalid)statecode と statuscode のプロパティを更新する。 |
SetStateRequest |
| Update | PATCH [org URI]/api/data/v9.0/goals(goalid) 更新を参照 |
UpdateRequest または Update |
プロパティ
| プロパティ | 値 |
|---|---|
| CollectionSchemaName | Goals |
| DisplayCollectionName | Goals |
| DisplayName | Goal |
| EntitySetName | goals |
| IsBPFEntity | False |
| LogicalCollectionName | goals |
| LogicalName | goal |
| OwnershipType | UserOwned |
| PrimaryIdAttribute | goalid |
| PrimaryNameAttribute | title |
| SchemaName | Goal |
書き込み可能な列/属性
これらの列/属性は IsValidForCreate または IsValidForUpdate のいずれかについて true を返します (通常は両方)。 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | Data type of the amount. |
| DisplayName | Amount Data Type |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | amountdatatype |
| RequiredLevel | None |
| Type | Picklist |
AmountDataType の選択肢/オプション
| 値 | ラベル | 内容 |
|---|---|---|
| 0 | Money | |
| 1 | Decimal | |
| 2 | Integer |
ConsiderOnlyGoalOwnersRecords
| プロパティ | 値 |
|---|---|
| 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 の選択肢/オプション
| 値 | ラベル | 内容 |
|---|---|---|
| 1 | Owned by goal owner | |
| 0 | All |
既定値 : 1
CustomRollupFieldDecimal
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | Select the fiscal period for the goal. |
| DisplayName | Fiscal Period |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | fiscalperiod |
| RequiredLevel | None |
| Type | Picklist |
FiscalPeriod の選択肢/オプション
| 値 | ラベル | 内容 |
|---|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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 の選択肢/オプション
| 値 | ラベル | 内容 |
|---|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | Unique identifier of the goal. |
| DisplayName | Goal |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | goalid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
GoalOwnerId
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | Goal Owner Type |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | goalowneridtype |
| RequiredLevel | ApplicationRequired |
| Type | EntityName |
GoalStartDate
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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 の選択肢/オプション
| 値 | ラベル | 内容 |
|---|---|---|
| 1 | Amount | |
| 0 | Count |
既定値 : 1
IsFiscalPeriodGoal
| プロパティ | 値 |
|---|---|
| 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 の選択肢/オプション
| 値 | ラベル | 内容 |
|---|---|---|
| 1 | Fiscal Period | |
| 0 | Custom Period |
既定値 : 1
IsOverridden
| プロパティ | 値 |
|---|---|
| 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 の選択肢/オプション
| 値 | ラベル | 内容 |
|---|---|---|
| 1 | Yes | |
| 0 | No |
既定値 : 0
IsOverride
| プロパティ | 値 |
|---|---|
| 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 の選択肢/オプション
| 値 | ラベル | 内容 |
|---|---|---|
| 1 | Yes | |
| 0 | No |
既定値 : 0
LastRolledupDate
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | Owner Id Type |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
ParentGoalId
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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 の選択肢/オプション
| 値 | ラベル | 内容 |
|---|---|---|
| 1 | Yes | |
| 0 | No |
既定値 : 0
RollUpQueryActualDecimalId
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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 の選択肢/オプション
| 値 | ラベル | 既定の状態 | 不変名 |
|---|---|---|---|
| 0 | Active | 0 | Active |
| 1 | Inactive | 1 | Inactive |
StatusCode
| プロパティ | 値 |
|---|---|
| Description | Select the goal's status. |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
StatusCode の選択肢/オプション
| 値 | ラベル | 状態 |
|---|---|---|
| 0 | Open | 0 |
| 1 | Closed | 1 |
| 2 | Discarded | 1 |
StretchTargetDecimal
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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 |
読み取り専用列/属性
これらの列/属性は IsValidForCreate または IsValidForUpdate の両方について false を返します。 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CustomRollupFieldMoney_Base
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimage_timestamp |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
EntityImage_URL
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Url |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimage_url |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
EntityImageId
| プロパティ | 値 |
|---|---|
| Description | For internal use only. |
| DisplayName | Entity Image Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimageid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
ExchangeRate
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | goalowneridname |
| MaxLength | 160 |
| RequiredLevel | ApplicationRequired |
| Type | String |
GoalOwnerIdYomiName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | goalowneridyominame |
| MaxLength | 160 |
| RequiredLevel | ApplicationRequired |
| Type | String |
GoalWithErrorIdName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | goalwitherroridname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
InProgressMoney_Base
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | metricidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedBy
| プロパティ | 値 |
|---|---|
| Description | Shows who last updated the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OwnerIdName
| プロパティ | 値 |
|---|---|
| Description | Name of the manager |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwnerIdYomiName
| プロパティ | 値 |
|---|---|
| Description | Yomi name of the owner |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwningBusinessUnit
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunitname |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
OwningTeam
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | parentgoalidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
RollUpQueryActualDecimalIdName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | rollupqueryactualdecimalidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
RollupQueryActualIntegerIdName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | rollupqueryactualintegeridname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
RollUpQueryActualMoneyIdName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | rollupqueryactualmoneyidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
RollUpQueryCustomDecimalIdName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | rollupquerycustomdecimalidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
RollUpQueryCustomIntegerIdName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | rollupquerycustomintegeridname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
RollUpQueryCustomMoneyIdName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | rollupquerycustommoneyidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
RollUpQueryInprogressDecimalIdName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | rollupqueryinprogressdecimalidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
RollUpQueryInprogressIntegerIdName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | rollupqueryinprogressintegeridname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
RollUpQueryInprogressMoneyIdName
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | rollupqueryinprogressmoneyidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
StretchTargetMoney_Base
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| 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
| プロパティ | 値 |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | transactioncurrencyidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
TreeId
| プロパティ | 値 |
|---|---|
| Description | Unique identifier of the goal tree. |
| DisplayName | Tree ID |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | treeid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
VersionNumber
| プロパティ | 値 |
|---|---|
| Description | Version number of the goal. |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
一対多関連付け
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
goal テーブル/エンティティの多対一のリレーションシップ goal_parent_goal と同じです。
| プロパティ | 値 |
|---|---|
| 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
duplicaterecord テーブル/エンティティの多対一のリレーションシップ Goal_DuplicateBaseRecord と同じです。
| プロパティ | 値 |
|---|---|
| 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
goal テーブル/エンティティの多対一のリレーションシップ Goal_RollupError_Goal と同じです。
| プロパティ | 値 |
|---|---|
| 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
syncerror テーブル/エンティティの多対一のリレーションシップ Goal_SyncErrors と同じです。
| プロパティ | 値 |
|---|---|
| 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
annotation テーブル/エンティティの多対一のリレーションシップ Goal_Annotation と同じです。
| プロパティ | 値 |
|---|---|
| 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
asyncoperation テーブル/エンティティの多対一のリレーションシップ Goal_AsyncOperations と同じです。
| プロパティ | 値 |
|---|---|
| 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
processsession テーブル/エンティティの多対一のリレーションシップ Goal_ProcessSessions と同じです。
| プロパティ | 値 |
|---|---|
| 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
connection テーブル/エンティティの多対一のリレーションシップ goal_connections1 と同じです。
| プロパティ | 値 |
|---|---|
| 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
connection テーブル/エンティティの多対一のリレーションシップ goal_connections2 と同じです。
| プロパティ | 値 |
|---|---|
| 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
duplicaterecord テーブル/エンティティの多対一のリレーションシップ Goal_DuplicateMatchingRecord と同じです。
| プロパティ | 値 |
|---|---|
| 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
principalobjectattributeaccess テーブル/エンティティの多対一のリレーションシップ goal_principalobjectattributeaccess と同じです。
| プロパティ | 値 |
|---|---|
| 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 |
多対一関連付け
各多対一の関係付けは、関連するテーブルとの対応する一対多の関係付けによって定義されます。 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
team テーブル/エンティティの一対多のリレーションシップ team_goal を参照してください。
goalrollupquery_actualint
goalrollupquery テーブル/エンティティの一対多のリレーションシップ goalrollupquery_actualint を参照してください。
goal_rollupquery_actualmoney
goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_actualmoney を参照してください。
goal_rollupquery_actualdecimal
goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_actualdecimal を参照してください。
goal_rollupquery_customint
goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_customint を参照してください。
goal_rollupquery_custommoney
goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_custommoney を参照してください。
goal_rollupquery_customdecimal
goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_customdecimal を参照してください。
goal_rollupquery_inprogressint
goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_inprogressint を参照してください。
goal_rollupquery_inprogressmoney
goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_inprogressmoney を参照してください。
goal_rollupquery_inprogressdecimal
goalrollupquery テーブル/エンティティの一対多のリレーションシップ goal_rollupquery_inprogressdecimal を参照してください。
lk_goal_createdby
systemuser テーブル/エンティティの一対多のリレーションシップ lk_goal_createdby を参照してください。
lk_goal_createdonbehalfby
systemuser テーブル/エンティティの一対多のリレーションシップ lk_goal_createdonbehalfby を参照してください。
lk_goal_modifiedby
systemuser テーブル/エンティティの一対多のリレーションシップ lk_goal_modifiedby を参照してください。
lk_goal_modifiedonbehalfby
systemuser テーブル/エンティティの一対多のリレーションシップ lk_goal_modifiedonbehalfby を参照してください。
user_goal
systemuser テーブル/エンティティの一対多のリレーションシップ user_goal を参照してください。
business_unit_goal
businessunit テーブル/エンティティの一対多のリレーションシップ business_unit_goal を参照してください。
user_goal_goalowner
systemuser テーブル/エンティティの一対多のリレーションシップ user_goal_goalowner を参照してください。
goal_parent_goal
goal テーブル/エンティティの一対多のリレーションシップ goal_parent_goal を参照してください。
TransactionCurrency_Goal
transactioncurrency テーブル/エンティティの一対多のリレーションシップ TransactionCurrency_Goal を参照してください。
metric_goal
metric テーブル/エンティティの一対多のリレーションシップ metric_goal を参照してください。
Goal_RollupError_Goal
goal テーブル/エンティティの一対多のリレーションシップ Goal_RollupError_Goal を参照してください。
team_goal_goalowner
team テーブル/エンティティの一対多のリレーションシップ team_goal_goalowner を参照してください。