Fixed Monthly Fiscal Calendar (FixedMonthlyFiscalCalendar) table/entity reference

Fixed 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 Fixed Monthly Fiscal Calendar (FixedMonthlyFiscalCalendar) 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
Create Event: False	POST /fixedmonthlyfiscalcalendars See Create	Create records
Delete Event: False	DELETE /fixedmonthlyfiscalcalendars(userfiscalcalendarid) See Delete	Delete records
Retrieve Event: False	GET /fixedmonthlyfiscalcalendars(userfiscalcalendarid) See Retrieve	Retrieve records
RetrieveMultiple Event: False	GET /fixedmonthlyfiscalcalendars See Query data	Query data
Update Event: False	PATCH /fixedmonthlyfiscalcalendars(userfiscalcalendarid) See Update	Update records
Upsert Event: False	PATCH /fixedmonthlyfiscalcalendars(userfiscalcalendarid) See Upsert a table row	UpsertRequest

Properties

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

Property	Value
DisplayName	Fixed Monthly Fiscal Calendar
DisplayCollectionName	Fixed Monthly Fiscal Calendars
SchemaName	FixedMonthlyFiscalCalendar
CollectionSchemaName	FixedMonthlyFiscalCalendars
EntitySetName	fixedmonthlyfiscalcalendars
LogicalName	fixedmonthlyfiscalcalendar
LogicalCollectionName	fixedmonthlyfiscalcalendars
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
• Period13
• Period2
• Period3
• Period4
• Period5
• Period6
• Period7
• Period8
• Period9
• SalesPersonId
• TimeZoneRuleVersionNumber
• TransactionCurrencyId
• UserFiscalCalendarId
• UTCConversionTimeZoneCode

EffectiveOn

Property	Value
Description	Date and time when the fixed 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 period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period1
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 period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period10
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 period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period11
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 period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period12
RequiredLevel	SystemRequired
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	100000000000
MinValue	0
Precision	2
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period13

Property	Value
Description	Sales quota for the thirteenth period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period13
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 period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period2
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 period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period3
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 period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period4
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 period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period5
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 period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period6
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 period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period7
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 period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period8
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 period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period9
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 fixed 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 user of the 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
• Period13_Base
• Period2_Base
• Period3_Base
• Period4_Base
• Period5_Base
• Period6_Base
• Period7_Base
• Period8_Base
• Period9_Base

BusinessUnitId

Property	Value
Description	Business unit responsible for the quota associated with this calendar.
DisplayName	Business Unit
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 fixed monthly fiscal calendar was created.
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 fixedmonthlyfiscalcalendar.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Type	Lookup
Targets	systemuser

ExchangeRate

Property	Value
Description	Exchange rate for the currency associated with the fixed 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 fixed monthly fiscal calendar 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 fixed 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 fixed 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 fixedmonthlyfiscalcalendar.
DisplayName
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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period1_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period10_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period11_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period12_base
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

Period13_Base

Property	Value
Description	Base currency equivalent of the sales quota for the thirteenth period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period13_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period2_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period3_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period4_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period5_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period6_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period7_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period8_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period9_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_fixedmonthlyfiscalcalendar_createdby
• lk_fixedmonthlyfiscalcalendar_createdonbehalfby
• lk_fixedmonthlyfiscalcalendar_modifiedby
• lk_fixedmonthlyfiscalcalendar_modifiedonbehalfby
• lk_fixedmonthlyfiscalcalendar_salespersonid
• transactioncurrency_fixedmonthlyfiscalcalendar

lk_fixedmonthlyfiscalcalendar_createdby

One-To-Many Relationship: systemuser lk_fixedmonthlyfiscalcalendar_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_fixedmonthlyfiscalcalendar_createdonbehalfby

One-To-Many Relationship: systemuser lk_fixedmonthlyfiscalcalendar_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_fixedmonthlyfiscalcalendar_modifiedby

One-To-Many Relationship: systemuser lk_fixedmonthlyfiscalcalendar_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_fixedmonthlyfiscalcalendar_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_fixedmonthlyfiscalcalendar_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_fixedmonthlyfiscalcalendar_salespersonid

One-To-Many Relationship: systemuser lk_fixedmonthlyfiscalcalendar_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_fixedmonthlyfiscalcalendar

One-To-Many Relationship: transactioncurrency transactioncurrency_fixedmonthlyfiscalcalendar

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.

• FixedMonthlyFiscalCalendar_AsyncOperations
• FixedMonthlyFiscalCalendar_BulkDeleteFailures

FixedMonthlyFiscalCalendar_AsyncOperations

Many-To-One Relationship: asyncoperation FixedMonthlyFiscalCalendar_AsyncOperations

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

FixedMonthlyFiscalCalendar_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure FixedMonthlyFiscalCalendar_BulkDeleteFailures

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

See also

Dataverse table/entity reference
Dataverse Web API Reference
fixedmonthlyfiscalcalendar