MonthlyFiscalCalendar table/entity reference
Article 06/04/2024
5 contributors
Feedback
In this article
Monthly fiscal calendar of an organization. A span of time during which the financial activities of an organization are calculated.
Messages
Properties
Property
Value
CollectionSchemaName
MonthlyFiscalCalendars
DisplayCollectionName
Monthly Fiscal Calendars
DisplayName
Monthly Fiscal Calendar
EntitySetName
monthlyfiscalcalendars
IsBPFEntity
False
LogicalCollectionName
monthlyfiscalcalendars
LogicalName
monthlyfiscalcalendar
OwnershipType
None
PrimaryIdAttribute
userfiscalcalendarid
PrimaryNameAttribute
SchemaName
MonthlyFiscalCalendar
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName .
EffectiveOn
Property
Value
DateTimeBehavior
UserLocal
Description
Date and time when the monthly fiscal calendar sales quota takes effect.
DisplayName
Format
DateOnly
IsValidForForm
False
IsValidForRead
True
IsValidForUpdate
False
LogicalName
effectiveon
RequiredLevel
SystemRequired
Type
DateTime
Period1
Property
Value
Description
Sales quota for the first month in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
month1
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period10
Property
Value
Description
Sales quota for the tenth month in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
month10
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period11
Property
Value
Description
Sales quota for the eleventh month in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
month11
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period12
Property
Value
Description
Sales quota for the twelfth month in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
month12
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period2
Property
Value
Description
Sales quota for the second month in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
month2
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period3
Property
Value
Description
Sales quota for the third month in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
month3
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period4
Property
Value
Description
Sales quota for the fourth month in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
month4
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period5
Property
Value
Description
Sales quota for the fifth month in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
month5
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period6
Property
Value
Description
Sales quota for the sixth month in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
month6
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period7
Property
Value
Description
Sales quota for the seventh month in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
month7
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period8
Property
Value
Description
Sales quota for the eighth month in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
month8
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period9
Property
Value
Description
Sales quota for the ninth month in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
month9
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
SalesPersonId
Property
Value
Description
Unique identifier of the associated salesperson.
DisplayName
IsValidForForm
False
IsValidForRead
True
IsValidForUpdate
False
LogicalName
salespersonid
RequiredLevel
SystemRequired
Targets
systemuser
Type
Lookup
TimeZoneRuleVersionNumber
Property
Value
Description
For internal use only.
DisplayName
Format
None
IsValidForForm
False
IsValidForRead
True
LogicalName
timezoneruleversionnumber
MaxValue
2147483647
MinValue
-1
RequiredLevel
None
Type
Integer
TransactionCurrencyId
Property
Value
Description
Unique identifier of the currency associated with the monthly fiscal calendar.
DisplayName
Currency
IsValidForForm
True
IsValidForRead
True
IsValidForUpdate
False
LogicalName
transactioncurrencyid
RequiredLevel
ApplicationRequired
Targets
transactioncurrency
Type
Lookup
UserFiscalCalendarId
Property
Value
Description
Unique identifier of the monthly fiscal calendar.
DisplayName
IsValidForForm
False
IsValidForRead
True
IsValidForUpdate
False
LogicalName
userfiscalcalendarid
RequiredLevel
SystemRequired
Type
Uniqueidentifier
UTCConversionTimeZoneCode
Property
Value
Description
Time zone code that was in use when the record was created.
DisplayName
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 .
BusinessUnitId
Property
Value
Description
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
businessunitid
RequiredLevel
ApplicationRequired
Targets
businessunit
Type
Lookup
BusinessUnitIdName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
businessunitidname
MaxLength
100
RequiredLevel
None
Type
String
CreatedBy
Property
Value
Description
Unique identifier of the user who created the fiscal calendar.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
createdby
RequiredLevel
None
Targets
systemuser
Type
Lookup
CreatedByName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
createdbyname
MaxLength
100
RequiredLevel
None
Type
String
CreatedByYomiName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
createdbyyominame
MaxLength
100
RequiredLevel
None
Type
String
CreatedOn
Property
Value
DateTimeBehavior
UserLocal
Description
Date and time when the quota for the monthly fiscal calendar was modified.
DisplayName
Format
DateAndTime
IsValidForForm
False
IsValidForRead
True
LogicalName
createdon
RequiredLevel
SystemRequired
Type
DateTime
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
Targets
systemuser
Type
Lookup
CreatedOnBehalfByName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
createdonbehalfbyname
MaxLength
100
RequiredLevel
None
Type
String
CreatedOnBehalfByYomiName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
createdonbehalfbyyominame
MaxLength
100
RequiredLevel
None
Type
String
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
MaxValue
100000000000
MinValue
0.000000000001
Precision
12
RequiredLevel
None
Type
Decimal
FiscalPeriodType
Property
Value
Description
Type of fiscal period used in the sales quota.
DisplayName
Format
None
IsValidForForm
False
IsValidForRead
True
LogicalName
fiscalperiodtype
MaxValue
2147483647
MinValue
-2147483648
RequiredLevel
SystemRequired
Type
Integer
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
Targets
systemuser
Type
Lookup
ModifiedByName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedbyname
MaxLength
100
RequiredLevel
None
Type
String
ModifiedByYomiName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedbyyominame
MaxLength
100
RequiredLevel
None
Type
String
ModifiedOn
Property
Value
DateTimeBehavior
UserLocal
Description
Date and time when the quota for the monthly fiscal calendar was last modified.
DisplayName
Format
DateAndTime
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedon
RequiredLevel
None
Type
DateTime
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
Targets
systemuser
Type
Lookup
ModifiedOnBehalfByName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedonbehalfbyname
MaxLength
100
RequiredLevel
None
Type
String
ModifiedOnBehalfByYomiName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedonbehalfbyyominame
MaxLength
100
RequiredLevel
None
Type
String
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
MaxValue
922337203685477
MinValue
-922337203685477
Precision
4
PrecisionSource
2
RequiredLevel
None
Type
Money
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
MaxValue
922337203685477
MinValue
-922337203685477
Precision
4
PrecisionSource
2
RequiredLevel
None
Type
Money
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
MaxValue
922337203685477
MinValue
-922337203685477
Precision
4
PrecisionSource
2
RequiredLevel
None
Type
Money
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
MaxValue
922337203685477
MinValue
-922337203685477
Precision
4
PrecisionSource
2
RequiredLevel
None
Type
Money
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
MaxValue
922337203685477
MinValue
-922337203685477
Precision
4
PrecisionSource
2
RequiredLevel
None
Type
Money
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
MaxValue
922337203685477
MinValue
-922337203685477
Precision
4
PrecisionSource
2
RequiredLevel
None
Type
Money
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
MaxValue
922337203685477
MinValue
-922337203685477
Precision
4
PrecisionSource
2
RequiredLevel
None
Type
Money
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
MaxValue
922337203685477
MinValue
-922337203685477
Precision
4
PrecisionSource
2
RequiredLevel
None
Type
Money
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
MaxValue
922337203685477
MinValue
-922337203685477
Precision
4
PrecisionSource
2
RequiredLevel
None
Type
Money
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
MaxValue
922337203685477
MinValue
-922337203685477
Precision
4
PrecisionSource
2
RequiredLevel
None
Type
Money
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
MaxValue
922337203685477
MinValue
-922337203685477
Precision
4
PrecisionSource
2
RequiredLevel
None
Type
Money
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
MaxValue
922337203685477
MinValue
-922337203685477
Precision
4
PrecisionSource
2
RequiredLevel
None
Type
Money
SalesPersonIdName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
salespersonidname
MaxLength
100
RequiredLevel
SystemRequired
Type
String
SalesPersonIdYomiName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
salespersonidyominame
MaxLength
100
RequiredLevel
SystemRequired
Type
String
TransactionCurrencyIdName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
transactioncurrencyidname
MaxLength
100
RequiredLevel
None
Type
String
One-To-Many Relationships
Listed by SchemaName .
MonthlyFiscalCalendar_AsyncOperations
Same as the MonthlyFiscalCalendar_AsyncOperations many-to-one relationship for the asyncoperation table/entity.
Property
Value
ReferencingEntity
asyncoperation
ReferencingAttribute
regardingobjectid
IsHierarchical
False
IsCustomizable
False
ReferencedEntityNavigationPropertyName
MonthlyFiscalCalendar_AsyncOperations
AssociatedMenuConfiguration
Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration
Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade
MonthlyFiscalCalendar_BulkDeleteFailures
Same as the MonthlyFiscalCalendar_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure table/entity.
Property
Value
ReferencingEntity
bulkdeletefailure
ReferencingAttribute
regardingobjectid
IsHierarchical
False
IsCustomizable
False
ReferencedEntityNavigationPropertyName
MonthlyFiscalCalendar_BulkDeleteFailures
AssociatedMenuConfiguration
Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration
Assign: NoCascade Delete: Cascade 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 .
lk_monthlyfiscalcalendar_modifiedonbehalfby
See the lk_monthlyfiscalcalendar_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
lk_monthlyfiscalcalendar_modifiedby
See the lk_monthlyfiscalcalendar_modifiedby one-to-many relationship for the systemuser table/entity.
lk_monthlyfiscalcalendar_createdonbehalfby
See the lk_monthlyfiscalcalendar_createdonbehalfby one-to-many relationship for the systemuser table/entity.
transactioncurrency_monthlyfiscalcalendar
See the transactioncurrency_monthlyfiscalcalendar one-to-many relationship for the transactioncurrency table/entity.
lk_monthlyfiscalcalendar_salespersonid
See the lk_monthlyfiscalcalendar_salespersonid one-to-many relationship for the systemuser table/entity.
lk_monthlyfiscalcalendar_createdby
See the lk_monthlyfiscalcalendar_createdby one-to-many relationship for the systemuser table/entity.
See also
Dataverse table/entity reference
Web API Reference
monthlyfiscalcalendar EntityType