FixedMonthlyFiscalCalendar table/entity reference
Articol 06/04/2024
5 colaboratori
Feedback
În acest articol
Fixed 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
FixedMonthlyFiscalCalendars
DisplayCollectionName
Fixed Monthly Fiscal Calendars
DisplayName
Fixed Monthly Fiscal Calendar
EntitySetName
fixedmonthlyfiscalcalendars
IsBPFEntity
False
LogicalCollectionName
fixedmonthlyfiscalcalendars
LogicalName
fixedmonthlyfiscalcalendar
OwnershipType
None
PrimaryIdAttribute
userfiscalcalendarid
PrimaryNameAttribute
SchemaName
FixedMonthlyFiscalCalendar
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 fixed 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 period in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
period1
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period10
Property
Value
Description
Sales quota for the tenth period in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
period10
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period11
Property
Value
Description
Sales quota for the eleventh period in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
period11
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period12
Property
Value
Description
Sales quota for the twelfth period in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
period12
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period13
Property
Value
Description
Sales quota for the thirteenth period in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
period13
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period2
Property
Value
Description
Sales quota for the second period in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
period2
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period3
Property
Value
Description
Sales quota for the third period in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
period3
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period4
Property
Value
Description
Sales quota for the fourth period in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
period4
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period5
Property
Value
Description
Sales quota for the fifth period in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
period5
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period6
Property
Value
Description
Sales quota for the sixth period in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
period6
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period7
Property
Value
Description
Sales quota for the seventh period in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
period7
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period8
Property
Value
Description
Sales quota for the eighth period in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
period8
MaxValue
100000000000
MinValue
0
Precision
2
PrecisionSource
2
RequiredLevel
SystemRequired
Type
Money
Period9
Property
Value
Description
Sales quota for the ninth period in the fiscal year.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
period9
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 fixed 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 user of the 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
Business unit responsible for the quota associated with this calendar.
DisplayName
Business Unit
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 fixed monthly fiscal calendar was created.
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 fixedmonthlyfiscalcalendar.
DisplayName
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 fixed 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 fixed monthly fiscal calendar 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 fixed 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 fixed 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 fixedmonthlyfiscalcalendar.
DisplayName
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 period in the fiscal year.
DisplayName
IsValidForForm
True
IsValidForRead
True
LogicalName
period1_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 period in the fiscal year.
DisplayName
IsValidForForm
True
IsValidForRead
True
LogicalName
period10_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 period in the fiscal year.
DisplayName
IsValidForForm
True
IsValidForRead
True
LogicalName
period11_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 period in the fiscal year.
DisplayName
IsValidForForm
True
IsValidForRead
True
LogicalName
period12_base
MaxValue
922337203685477
MinValue
-922337203685477
Precision
4
PrecisionSource
2
RequiredLevel
None
Type
Money
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
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 period in the fiscal year.
DisplayName
IsValidForForm
True
IsValidForRead
True
LogicalName
period2_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 period in the fiscal year.
DisplayName
IsValidForForm
True
IsValidForRead
True
LogicalName
period3_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 period in the fiscal year.
DisplayName
IsValidForForm
True
IsValidForRead
True
LogicalName
period4_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 period in the fiscal year.
DisplayName
IsValidForForm
True
IsValidForRead
True
LogicalName
period5_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 period in the fiscal year.
DisplayName
IsValidForForm
True
IsValidForRead
True
LogicalName
period6_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 period in the fiscal year.
DisplayName
IsValidForForm
True
IsValidForRead
True
LogicalName
period7_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 period in the fiscal year.
DisplayName
IsValidForForm
True
IsValidForRead
True
LogicalName
period8_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 period in the fiscal year.
DisplayName
IsValidForForm
True
IsValidForRead
True
LogicalName
period9_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 .
FixedMonthlyFiscalCalendar_AsyncOperations
Same as the FixedMonthlyFiscalCalendar_AsyncOperations many-to-one relationship for the asyncoperation table/entity.
Property
Value
ReferencingEntity
asyncoperation
ReferencingAttribute
regardingobjectid
IsHierarchical
False
IsCustomizable
False
ReferencedEntityNavigationPropertyName
FixedMonthlyFiscalCalendar_AsyncOperations
AssociatedMenuConfiguration
Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration
Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade
FixedMonthlyFiscalCalendar_BulkDeleteFailures
Same as the FixedMonthlyFiscalCalendar_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure table/entity.
Property
Value
ReferencingEntity
bulkdeletefailure
ReferencingAttribute
regardingobjectid
IsHierarchical
False
IsCustomizable
False
ReferencedEntityNavigationPropertyName
FixedMonthlyFiscalCalendar_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 .
transactioncurrency_fixedmonthlyfiscalcalendar
See the transactioncurrency_fixedmonthlyfiscalcalendar one-to-many relationship for the transactioncurrency table/entity.
lk_fixedmonthlyfiscalcalendar_salespersonid
See the lk_fixedmonthlyfiscalcalendar_salespersonid one-to-many relationship for the systemuser table/entity.
lk_fixedmonthlyfiscalcalendar_modifiedby
See the lk_fixedmonthlyfiscalcalendar_modifiedby one-to-many relationship for the systemuser table/entity.
lk_fixedmonthlyfiscalcalendar_createdby
See the lk_fixedmonthlyfiscalcalendar_createdby one-to-many relationship for the systemuser table/entity.
lk_fixedmonthlyfiscalcalendar_createdonbehalfby
See the lk_fixedmonthlyfiscalcalendar_createdonbehalfby one-to-many relationship for the systemuser table/entity.
lk_fixedmonthlyfiscalcalendar_modifiedonbehalfby
See the lk_fixedmonthlyfiscalcalendar_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
See also
Dataverse table/entity reference
Web API Reference
fixedmonthlyfiscalcalendar EntityType