JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

Goal

This is a table representing the Goal entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the goal.

ActualDecimal Double False

Actual value (decimal type) against the target.

ActualInteger Integer False

Actual value (integer type) against the target.

ActualMoney Double False

Actual value (money type) against the target.

ActualMoney_Base Double True

Actual value (money type) in base currency against the target.

ActualString String True

Actual Value of the goal.

AmountDataType String False

Data type of the amount.

ComputedTargetAsOfTodayDecimal Double True

A system-generated expected amount for Actual (decimal) against the target goal.

ComputedTargetAsOfTodayInteger Integer True

A system-generated expected amount for Actual (integer) against the target goal.

ComputedTargetAsOfTodayMoney Double True

A system-generated expected amount for Actual (money) against the target goal.

ComputedTargetAsOfTodayMoney_Base Double True

A system-generated expected amount in base currency for Actual (money) against the target goal.

ComputedTargetAsOfTodayPercentageAchieved Double True

A system-generated expected value for percentage achieved against the target goal.

ConsiderOnlyGoalOwnersRecords Boolean False

Indicates whether only the goal owner's records, or all records, will be rolled up.

CreatedBy_Id String True

Unique identifier of the user who created the record.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the record was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the record.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

CustomRollupFieldDecimal Double False

Placeholder rollup field for value (decimal) against the target.

CustomRollupFieldInteger Integer False

Placeholder rollup field for value (integer) against the target.

CustomRollupFieldMoney Double False

Placeholder rollup field for value (money) against the target.

CustomRollupFieldMoney_Base Double True

Placeholder rollup field for value (money) in base currency against the target.

CustomRollupFieldString String True

Placeholder rollup field for the goal.

Depth Integer True

Depth of the goal in the tree.

ExchangeRate Double True

Exchange rate between the currency associated with the entity and the base currency.

FiscalPeriod String False

Fiscal period for the goal.

FiscalYear String False

Fiscal year for the goal.

GoalEndDate Datetime False

End date for the goal period.

GoalId String False

Unique identifier of the goal.

GoalOwnerId_Id String False

Unique identifier of the user or team who needs to meet the goal.

GoalOwnerId_LogicalName String False

GoalOwnerId_Name String False

GoalStartDate Datetime False

Start date for the goal period.

GoalWithErrorId_Id String False

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

GoalWithErrorId_LogicalName String False

GoalWithErrorId_Name String False

ImportSequenceNumber Integer False

Sequence number of the import that created this record.

InProgressDecimal Double False

In-progress value (decimal) against the target.

InProgressInteger Integer False

In-progress value (integer) against the target.

InProgressMoney Double False

In-progress value (money) against the target.

InProgressMoney_Base Double True

In-progress value (money) in base currency against the goal.

InProgressString String True

In-progress value of the goal.

IsAmount Boolean False

Indicates whether the metric type is Count or Amount.

IsFiscalPeriodGoal Boolean False

Indicates whether the goal period is a fiscal period or a custom period.

IsOverridden Boolean False

Indicates whether the system rollup fields are updated. If set to Yes, system rollup will not update the values of the rollup fields.

IsOverride Boolean False

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

LastRolledupDate Datetime False

Date and time when the data for this goal was last rolled up.

MetricId_Id String False

Unique identifier of the metric associated with the goal.

MetricId_LogicalName String False

MetricId_Name String False

ModifiedBy_Id String True

Unique identifier of the user who modified the record.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the record was modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who modified the record.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

OwnerId_Id String False

Unique identifier of the manager of the goal.

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Unique identifier for the business unit that owns the record.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team who owns the goal.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier for the user who owns the record.

OwningUser_LogicalName String True

OwningUser_Name String True

ParentGoalId_Id String False

Unique identifier of the parent goal to which the goal is connected.

ParentGoalId_LogicalName String False

ParentGoalId_Name String False

Percentage Double False

Percentage achieved against the target goal.

RollupErrorCode Integer False

Error code associated with rollup.

RollupOnlyFromChildGoals Boolean False

Indicates whether the data should be rolled up only from the child goals.

RollUpQueryActualDecimalId_Id String False

Unique identifier of the rollup query for the actual (decimal) rollup field.

RollUpQueryActualDecimalId_LogicalName String False

RollUpQueryActualDecimalId_Name String False

RollupQueryActualIntegerId_Id String False

Unique identifier of the rollup query for the actual (integer) rollup field.

RollupQueryActualIntegerId_LogicalName String False

RollupQueryActualIntegerId_Name String False

RollUpQueryActualMoneyId_Id String False

Unique identifier of the rollup query for the actual (money) rollup field.

RollUpQueryActualMoneyId_LogicalName String False

RollUpQueryActualMoneyId_Name String False

RollUpQueryCustomDecimalId_Id String False

Unique identifier of the rollup query for the custom rollup field (decimal).

RollUpQueryCustomDecimalId_LogicalName String False

RollUpQueryCustomDecimalId_Name String False

RollUpQueryCustomIntegerId_Id String False

Unique identifier of the rollup query for the custom rollup field (integer).

RollUpQueryCustomIntegerId_LogicalName String False

RollUpQueryCustomIntegerId_Name String False

RollUpQueryCustomMoneyId_Id String False

Unique identifier of the rollup query for the custom rollup field (money).

RollUpQueryCustomMoneyId_LogicalName String False

RollUpQueryCustomMoneyId_Name String False

RollUpQueryInprogressDecimalId_Id String False

Unique identifier of the rollup query for the in-progress (decimal) rollup field.

RollUpQueryInprogressDecimalId_LogicalName String False

RollUpQueryInprogressDecimalId_Name String False

RollUpQueryInprogressIntegerId_Id String False

Unique identifier of the rollup query for the in-progress (integer) rollup field.

RollUpQueryInprogressIntegerId_LogicalName String False

RollUpQueryInprogressIntegerId_Name String False

RollUpQueryInprogressMoneyId_Id String False

Unique identifier of the rollup query for the in-progress (money) rollup field.

RollUpQueryInprogressMoneyId_LogicalName String False

RollUpQueryInprogressMoneyId_Name String False

StateCode String True

Status of the goal.

StatusCode String False

Reason for the status of the goal.

StretchTargetDecimal Double False

Stretch target (decimal) of the goal.

StretchTargetInteger Integer False

Stretch target (integer) of the goal.

StretchTargetMoney Double False

Stretch target (money) of the goal.

StretchTargetMoney_Base Double True

Value of the stretch target (money) in base currency.

StretchTargetString String True

Stretch target value for all data types.

TargetDecimal Double False

Goal target of the decimal type.

TargetInteger Integer False

Goal target of the integer type.

TargetMoney Double False

Goal target of the money type.

TargetMoney_Base Double True

Goal target of the money type in base currency.

TargetString String True

Target value of the goal.

TimeZoneRuleVersionNumber Integer False

For internal use only.

Title String False

Title of the goal.

TransactionCurrencyId_Id String True

Unique identifier of the currency associated with the entity.

TransactionCurrencyId_LogicalName String True

TransactionCurrencyId_Name String True

TreeId String True

Unique identifier of the goal tree.

UTCConversionTimeZoneCode Integer False

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462