msdyn_forecastrecurrence table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Stores recalculation information for each recurrence of the forecast hierarchy. For internal use.
Added by: Forecasting Solution
Messages
| Message | Web API Operation | SDK class or method |
|---|---|---|
| Assign | PATCH /msdyn_forecastrecurrences(msdyn_forecastrecurrenceid) Update ownerid property. |
AssignRequest |
| BulkRetain | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
| Create | POST /msdyn_forecastrecurrences See Create |
CreateRequest or Create |
| CreateMultiple | CreateMultiple | CreateMultipleRequest |
| Delete | DELETE /msdyn_forecastrecurrences(msdyn_forecastrecurrenceid) See Delete |
DeleteRequest or Delete |
| GrantAccess | GrantAccess | GrantAccessRequest |
| IsValidStateTransition | IsValidStateTransition | IsValidStateTransitionRequest |
| ModifyAccess | ModifyAccess | ModifyAccessRequest |
| PurgeRetainedContent | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
| Retain | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
| Retrieve | GET /msdyn_forecastrecurrences(msdyn_forecastrecurrenceid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET /msdyn_forecastrecurrences See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| RetrievePrincipalAccess | RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
| RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
| RevokeAccess | RevokeAccess | RevokeAccessRequest |
| RollbackRetain | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
| SetState | PATCH /msdyn_forecastrecurrences(msdyn_forecastrecurrenceid) Update statecode and statuscode properties. |
SetStateRequest |
| Update | PATCH /msdyn_forecastrecurrences(msdyn_forecastrecurrenceid) See Update |
UpdateRequest or Update |
| UpdateMultiple | UpdateMultiple | UpdateMultipleRequest |
| ValidateRetentionConfig | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | msdyn_forecastrecurrences |
| DisplayCollectionName | Forecast recurrences |
| DisplayName | Forecast recurrence |
| EntitySetName | msdyn_forecastrecurrences |
| IsBPFEntity | False |
| LogicalCollectionName | msdyn_forecastrecurrences |
| LogicalName | msdyn_forecastrecurrence |
| OwnershipType | UserOwned |
| PrimaryIdAttribute | msdyn_forecastrecurrenceid |
| PrimaryNameAttribute | msdyn_name |
| SchemaName | msdyn_forecastrecurrence |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ImportSequenceNumber
- msdyn_actualparticipatingrecordsfetchxml
- msdyn_failureinfo
- msdyn_forecastdefinitionid
- msdyn_forecastrecurrenceId
- msdyn_inprogressparticipatingrecordsfetchxml
- msdyn_ishierarchylocked
- msdyn_lastrecalculatedon
- msdyn_name
- msdyn_recalculatestatuschangedon
- msdyn_recalculationstarttime
- msdyn_recalculationstatus
- msdyn_recalculationstatusdescription
- msdyn_recurrenceindex
- msdyn_validfrom
- msdyn_validto
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- statecode
- statuscode
- TimeZoneRuleVersionNumber
- UTCConversionTimeZoneCode
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 |
msdyn_actualparticipatingrecordsfetchxml
| Property | Value |
|---|---|
| Description | Stores the FetchXML for participating records for closed opportunities. For internal use. |
| DisplayName | Closed participating opportunities FetchXML |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | msdyn_actualparticipatingrecordsfetchxml |
| MaxLength | 1073741823 |
| RequiredLevel | None |
| Type | String |
msdyn_failureinfo
| Property | Value |
|---|---|
| Description | Stores information about why the recalculation of forecast hierarchy failed. |
| DisplayName | Failure info |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_failureinfo |
| MaxLength | 2000 |
| RequiredLevel | None |
| Type | Memo |
msdyn_forecastdefinitionid
| Property | Value |
|---|---|
| Description | Unique identifier for the forecast definition that is associated with the forecast recurrence. |
| DisplayName | Forecast definition |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_forecastdefinitionid |
| RequiredLevel | ApplicationRequired |
| Targets | msdyn_forecastdefinition |
| Type | Lookup |
msdyn_forecastrecurrenceId
| Property | Value |
|---|---|
| Description | Unique identifier for the forecast recurrence. |
| DisplayName | Forecast recurrence |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | msdyn_forecastrecurrenceid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
msdyn_inprogressparticipatingrecordsfetchxml
| Property | Value |
|---|---|
| Description | Stores the FetchXML for participating records for inprogress opportunities. For internal use. |
| DisplayName | Inprogress participating opportunities FetchXML |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | msdyn_inprogressparticipatingrecordsfetchxml |
| MaxLength | 1073741823 |
| RequiredLevel | None |
| Type | String |
msdyn_ishierarchylocked
| Property | Value |
|---|---|
| Description | For internal use only |
| DisplayName | IsHierarchyLocked |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_ishierarchylocked |
| RequiredLevel | None |
| Type | Boolean |
msdyn_ishierarchylocked Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
msdyn_lastrecalculatedon
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | The date and time when the forecast hierarchy was successfully recalculated. |
| DisplayName | Last recalculated on |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_lastrecalculatedon |
| RequiredLevel | None |
| Type | DateTime |
msdyn_name
| Property | Value |
|---|---|
| Description | Shows the name of the forecast recurrence. |
| DisplayName | Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_name |
| MaxLength | 100 |
| RequiredLevel | ApplicationRequired |
| Type | String |
msdyn_recalculatestatuschangedon
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | For internal use only. |
| DisplayName | RecalculateStatusChangedOn |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_recalculatestatuschangedon |
| RequiredLevel | None |
| Type | DateTime |
msdyn_recalculationstarttime
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | For internal use only. |
| DisplayName | HierarchyLastLockedOn |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_recalculationstarttime |
| RequiredLevel | None |
| Type | DateTime |
msdyn_recalculationstatus
| Property | Value |
|---|---|
| Description | Shows the recalculation status for the forecast recurrence hierarchy. |
| DisplayName | Recalculation status |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_recalculationstatus |
| MaxValue | 100 |
| MinValue | 1 |
| RequiredLevel | None |
| Type | Integer |
msdyn_recalculationstatusdescription
| Property | Value |
|---|---|
| Description | Stores the description for the recalculation status of forecast hierarchy. |
| DisplayName | Recalculation status description |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_recalculationstatusdescription |
| MaxLength | 2000 |
| RequiredLevel | None |
| Type | Memo |
msdyn_recurrenceindex
| Property | Value |
|---|---|
| Description | Stores the recurrence index that is associated with the forecast recurrence hierarchy. |
| DisplayName | Recurrence index |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_recurrenceindex |
| MaxValue | 99 |
| MinValue | 1 |
| RequiredLevel | ApplicationRequired |
| Type | Integer |
msdyn_validfrom
| Property | Value |
|---|---|
| DateTimeBehavior | DateOnly |
| Description | Shows the date from which the forecast is applicable. The date and time are displayed in the time zone selected in Dynamics 365 Customer Engagement apps options. |
| DisplayName | Valid from |
| Format | DateOnly |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_validfrom |
| RequiredLevel | ApplicationRequired |
| Type | DateTime |
msdyn_validto
| Property | Value |
|---|---|
| DateTimeBehavior | DateOnly |
| Description | Shows the date till which the forecast is applicable. The date and time are displayed in the time zone selected in Dynamics 365 Customer Engagement apps options. |
| DisplayName | Valid to |
| Format | DateOnly |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_validto |
| RequiredLevel | ApplicationRequired |
| Type | DateTime |
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
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Owner Id |
| DisplayName | Owner |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Targets | systemuser,team |
| Type | Owner |
OwnerIdType
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Owner Id Type |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
statecode
| Property | Value |
|---|---|
| Description | Status of the Forecast Recurrence |
| DisplayName | Status |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
statecode Choices/Options
| Value | Label | DefaultStatus | InvariantName |
|---|---|---|---|
| 0 | Active | 1 | Active |
| 1 | Inactive | 2 | Inactive |
statuscode
| Property | Value |
|---|---|
| Description | Reason for the status of the Forecast Recurrence |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
statuscode Choices/Options
| Value | Label | State |
|---|---|---|
| 1 | Active | 0 |
| 2 | Inactive | 1 |
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 |
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.
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- msdyn_ForecastDefinitionIdName
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- VersionNumber
CreatedBy
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Unique identifier of the user who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
CreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the record was created. |
| DisplayName | Created On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
CreatedOnBehalfBy
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Unique identifier of the delegate user who created the record. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedOnBehalfByName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
ModifiedBy
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Unique identifier of the user who modified the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
ModifiedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the record was modified. |
| DisplayName | Modified On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
ModifiedOnBehalfBy
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Unique identifier of the delegate user who modified the record. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedOnBehalfByName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
msdyn_ForecastDefinitionIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | msdyn_forecastdefinitionidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OwnerIdName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Name of the owner |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwnerIdYomiName
Added by: Active Solution Solution
| 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
Added by: Active Solution Solution
| 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
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunitname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwningTeam
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Unique identifier for the team that owns the record. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Targets | team |
| Type | Lookup |
OwningUser
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Unique identifier for the user that owns the record. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
VersionNumber
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Version Number |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
msdyn_msdyn_forecastrecurrence_msdyn_forecastinstance
Same as the msdyn_msdyn_forecastrecurrence_msdyn_forecastinstance many-to-one relationship for the msdyn_forecastinstance table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_forecastinstance |
| ReferencingAttribute | msdyn_forecastrecurrenceid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_forecastrecurrence_msdyn_forecastinstance |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 10000 |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink 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.
msdyn_msdyn_forecastdefinition_msdyn_forecastrecurrence
See the msdyn_msdyn_forecastdefinition_msdyn_forecastrecurrence one-to-many relationship for the msdyn_forecastdefinition table/entity.
See also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for