Monthly Fiscal Calendar (MonthlyFiscalCalendar) table/entity reference (Microsoft Dataverse)

2025-08-28

Monthly fiscal calendar of an organization. A span of time during which the financial activities of an organization are calculated.

Messages

The following table lists the messages for the Monthly Fiscal Calendar (MonthlyFiscalCalendar) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
`Associate` Event: True	Associate records	Associate records
`Create` Event: False	`POST` /monthlyfiscalcalendars See Create	Create records
`Delete` Event: False	`DELETE` /monthlyfiscalcalendars(userfiscalcalendarid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`Retrieve` Event: False	`GET` /monthlyfiscalcalendars(userfiscalcalendarid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: False	`GET` /monthlyfiscalcalendars See Query data	Query data
`Update` Event: False	`PATCH` /monthlyfiscalcalendars(userfiscalcalendarid) See Update	Update records
`Upsert` Event: False	`PATCH` /monthlyfiscalcalendars(userfiscalcalendarid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Monthly Fiscal Calendar (MonthlyFiscalCalendar) table.

Property	Value
DisplayName	Monthly Fiscal Calendar
DisplayCollectionName	Monthly Fiscal Calendars
SchemaName	`MonthlyFiscalCalendar`
CollectionSchemaName	`MonthlyFiscalCalendars`
EntitySetName	`monthlyfiscalcalendars`
LogicalName	`monthlyfiscalcalendar`
LogicalCollectionName	`monthlyfiscalcalendars`
PrimaryIdAttribute	`userfiscalcalendarid`
TableType	`Standard`
OwnershipType	`None`

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

EffectiveOn
Period1
Period10
Period11
Period12
Period2
Period3
Period4
Period5
Period6
Period7
Period8
Period9
SalesPersonId
TimeZoneRuleVersionNumber
TransactionCurrencyId
UserFiscalCalendarId
UTCConversionTimeZoneCode

EffectiveOn

Property	Value
Description	Date and time when the monthly fiscal calendar sales quota takes effect.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`effectiveon`
RequiredLevel	SystemRequired
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

Period1

Property	Value
Description	Sales quota for the first month in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`month1`
RequiredLevel	SystemRequired
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	100000000000
MinValue	0
Precision	2
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period10

Property	Value
Description	Sales quota for the tenth month in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`month10`
RequiredLevel	SystemRequired
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	100000000000
MinValue	0
Precision	2
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period11

Property	Value
Description	Sales quota for the eleventh month in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`month11`
RequiredLevel	SystemRequired
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	100000000000
MinValue	0
Precision	2
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period12

Property	Value
Description	Sales quota for the twelfth month in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`month12`
RequiredLevel	SystemRequired
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	100000000000
MinValue	0
Precision	2
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period2

Property	Value
Description	Sales quota for the second month in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`month2`
RequiredLevel	SystemRequired
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	100000000000
MinValue	0
Precision	2
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period3

Property	Value
Description	Sales quota for the third month in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`month3`
RequiredLevel	SystemRequired
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	100000000000
MinValue	0
Precision	2
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period4

Property	Value
Description	Sales quota for the fourth month in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`month4`
RequiredLevel	SystemRequired
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	100000000000
MinValue	0
Precision	2
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period5

Property	Value
Description	Sales quota for the fifth month in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`month5`
RequiredLevel	SystemRequired
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	100000000000
MinValue	0
Precision	2
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period6

Property	Value
Description	Sales quota for the sixth month in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`month6`
RequiredLevel	SystemRequired
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	100000000000
MinValue	0
Precision	2
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period7

Property	Value
Description	Sales quota for the seventh month in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`month7`
RequiredLevel	SystemRequired
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	100000000000
MinValue	0
Precision	2
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period8

Property	Value
Description	Sales quota for the eighth month in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`month8`
RequiredLevel	SystemRequired
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	100000000000
MinValue	0
Precision	2
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period9

Property	Value
Description	Sales quota for the ninth month in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`month9`
RequiredLevel	SystemRequired
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	100000000000
MinValue	0
Precision	2
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

SalesPersonId

Property	Value
Description	Unique identifier of the associated salesperson.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`salespersonid`
RequiredLevel	SystemRequired
Type	Lookup
Targets	systemuser

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`timezoneruleversionnumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

TransactionCurrencyId

Property	Value
Description	Unique identifier of the currency associated with the monthly fiscal calendar.
DisplayName	Currency
IsValidForForm	True
IsValidForRead	True
LogicalName	`transactioncurrencyid`
RequiredLevel	ApplicationRequired
Type	Lookup
Targets	transactioncurrency

UserFiscalCalendarId

Property	Value
Description	Unique identifier of the monthly fiscal calendar.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`userfiscalcalendarid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`utcconversiontimezonecode`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

BusinessUnitId
CreatedBy
CreatedOn
CreatedOnBehalfBy
ExchangeRate
FiscalPeriodType
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
Period1_Base
Period10_Base
Period11_Base
Period12_Base
Period2_Base
Period3_Base
Period4_Base
Period5_Base
Period6_Base
Period7_Base
Period8_Base
Period9_Base

BusinessUnitId

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`businessunitid`
RequiredLevel	ApplicationRequired
Type	Lookup
Targets	businessunit

CreatedBy

Property	Value
Description	Unique identifier of the user who created the fiscal calendar.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Date and time when the quota for the monthly fiscal calendar was modified.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdon`
RequiredLevel	SystemRequired
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who created the monthlyfiscalcalendar.
DisplayName	Created By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ExchangeRate

Property	Value
Description	Exchange rate for the currency associated with the monthly fiscal calendar with respect to the base currency.
DisplayName	Exchange Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	`exchangerate`
RequiredLevel	None
Type	Decimal
ImeMode	Disabled
MaxValue	100000000000
MinValue	1E-12
Precision	12
SourceTypeMask	0

FiscalPeriodType

Property	Value
Description	Type of fiscal period used in the sales quota.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`fiscalperiodtype`
RequiredLevel	SystemRequired
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

ModifiedBy

Property	Value
Description	Unique identifier of the user who last modified the quota for the monthly fiscal calendar.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Date and time when the quota for the monthly fiscal calendar was last modified.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who last modified the monthlyfiscalcalendar.
DisplayName	Modified By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

Period1_Base

Property	Value
Description	Base currency equivalent of the sales quota for the first month in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`month1_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period10_Base

Property	Value
Description	Base currency equivalent of the sales quota for the tenth month in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`month10_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period11_Base

Property	Value
Description	Base currency equivalent of the sales quota for the eleventh month in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`month11_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period12_Base

Property	Value
Description	Base currency equivalent of the sales quota for the twelfth month in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`month12_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period2_Base

Property	Value
Description	Base currency equivalent of the sales quota for the second month in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`month2_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period3_Base

Property	Value
Description	Base currency equivalent of the sales quota for the third month in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`month3_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period4_Base

Property	Value
Description	Base currency equivalent of the sales quota for the fourth month in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`month4_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period5_Base

Property	Value
Description	Base currency equivalent of the sales quota for the fifth month in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`month5_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period6_Base

Property	Value
Description	Base currency equivalent of the sales quota for the sixth month in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`month6_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period7_Base

Property	Value
Description	Base currency equivalent of the sales quota for the seventh month in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`month7_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period8_Base

Property	Value
Description	Base currency equivalent of the sales quota for the eighth month in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`month8_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period9_Base

Property	Value
Description	Base currency equivalent of the sales quota for the ninth month in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`month9_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

lk_monthlyfiscalcalendar_createdby
lk_monthlyfiscalcalendar_createdonbehalfby
lk_monthlyfiscalcalendar_modifiedby
lk_monthlyfiscalcalendar_modifiedonbehalfby
lk_monthlyfiscalcalendar_salespersonid
transactioncurrency_monthlyfiscalcalendar

lk_monthlyfiscalcalendar_createdby

One-To-Many Relationship: systemuser lk_monthlyfiscalcalendar_createdby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdby`
ReferencingEntityNavigationPropertyName	`createdby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_monthlyfiscalcalendar_createdonbehalfby

One-To-Many Relationship: systemuser lk_monthlyfiscalcalendar_createdonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdonbehalfby`
ReferencingEntityNavigationPropertyName	`createdonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_monthlyfiscalcalendar_modifiedby

One-To-Many Relationship: systemuser lk_monthlyfiscalcalendar_modifiedby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedby`
ReferencingEntityNavigationPropertyName	`modifiedby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_monthlyfiscalcalendar_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_monthlyfiscalcalendar_modifiedonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedonbehalfby`
ReferencingEntityNavigationPropertyName	`modifiedonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_monthlyfiscalcalendar_salespersonid

One-To-Many Relationship: systemuser lk_monthlyfiscalcalendar_salespersonid

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`salespersonid`
ReferencingEntityNavigationPropertyName	`salespersonid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

transactioncurrency_monthlyfiscalcalendar

One-To-Many Relationship: transactioncurrency transactioncurrency_monthlyfiscalcalendar

Property	Value
ReferencedEntity	`transactioncurrency`
ReferencedAttribute	`transactioncurrencyid`
ReferencingAttribute	`transactioncurrencyid`
ReferencingEntityNavigationPropertyName	`transactioncurrencyid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

MonthlyFiscalCalendar_AsyncOperations
MonthlyFiscalCalendar_BulkDeleteFailures

MonthlyFiscalCalendar_AsyncOperations

Many-To-One Relationship: asyncoperation MonthlyFiscalCalendar_AsyncOperations

Property	Value
ReferencingEntity	`asyncoperation`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`MonthlyFiscalCalendar_AsyncOperations`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

MonthlyFiscalCalendar_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure MonthlyFiscalCalendar_BulkDeleteFailures

Property	Value
ReferencingEntity	`bulkdeletefailure`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`MonthlyFiscalCalendar_BulkDeleteFailures`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Feedback

Was this page helpful?