QuarterlyFiscalCalendar table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Quarterly fiscal calendar of an organization. A span of time during which the financial activities of an organization are calculated.
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
Create | POST /quarterlyfiscalcalendars See Create |
CreateRequest or Create |
Delete | DELETE /quarterlyfiscalcalendars(userfiscalcalendarid) See Delete |
DeleteRequest or Delete |
Retrieve | GET /quarterlyfiscalcalendars(userfiscalcalendarid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /quarterlyfiscalcalendars See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
Update | PATCH /quarterlyfiscalcalendars(userfiscalcalendarid) See Update |
UpdateRequest or Update |
Properties
Property | Value |
---|---|
CollectionSchemaName | QuarterlyFiscalCalendars |
DisplayCollectionName | Quarterly Fiscal Calendars |
DisplayName | Quarterly Fiscal Calendar |
EntitySetName | quarterlyfiscalcalendars |
IsBPFEntity | False |
LogicalCollectionName | quarterlyfiscalcalendars |
LogicalName | quarterlyfiscalcalendar |
OwnershipType | None |
PrimaryIdAttribute | userfiscalcalendarid |
PrimaryNameAttribute | |
SchemaName | QuarterlyFiscalCalendar |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- EffectiveOn
- Period1
- Period10
- Period4
- Period7
- SalesPersonId
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UserFiscalCalendarId
- UTCConversionTimeZoneCode
EffectiveOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the quarterly 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 quarter in the fiscal year. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | quarter1 |
MaxValue | 100000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | SystemRequired |
Type | Money |
Period10
Property | Value |
---|---|
Description | Sales quota for the fourth quarter in the fiscal year. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | quarter4 |
MaxValue | 100000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | SystemRequired |
Type | Money |
Period4
Property | Value |
---|---|
Description | Sales quota for the second quarter in the fiscal year. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | quarter2 |
MaxValue | 100000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | SystemRequired |
Type | Money |
Period7
Property | Value |
---|---|
Description | Sales quota for the third quarter in the fiscal year. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | quarter3 |
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 quarterly 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 quarterly 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
- BusinessUnitIdName
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ExchangeRate
- FiscalPeriodType
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- Period1_Base
- Period10_Base
- Period4_Base
- Period7_Base
- SalesPersonIdName
- SalesPersonIdYomiName
- TransactionCurrencyIdName
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 quarterly 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 quarterly 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 quarterlyfiscalcalendar. |
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 quarterly 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 quarterly 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 quarterly 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 quarterlyfiscalcalendar. |
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 quarter in the fiscal year. |
DisplayName | |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | quarter1_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 fourth quarter in the fiscal year. |
DisplayName | |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | quarter4_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 second quarter in the fiscal year |
DisplayName | |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | quarter2_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 third quarter in the fiscal year. |
DisplayName | |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | quarter3_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.
QuarterlyFiscalCalendar_AsyncOperations
Same as the QuarterlyFiscalCalendar_AsyncOperations many-to-one relationship for the asyncoperation table/entity.
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | QuarterlyFiscalCalendar_AsyncOperations |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
QuarterlyFiscalCalendar_BulkDeleteFailures
Same as the QuarterlyFiscalCalendar_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure table/entity.
Property | Value |
---|---|
ReferencingEntity | bulkdeletefailure |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | QuarterlyFiscalCalendar_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_quarterlyfiscalcalendar_modifiedonbehalfby
- lk_quarterlyfiscalcalendar_createdby
- transactioncurrency_quarterlyfiscalcalendar
- lk_quarterlyfiscalcalendar_createdonbehalfby
- lk_quarterlyfiscalcalendar_salespersonid
- lk_quarterlyfiscalcalendar_modifiedby
lk_quarterlyfiscalcalendar_modifiedonbehalfby
See the lk_quarterlyfiscalcalendar_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
lk_quarterlyfiscalcalendar_createdby
See the lk_quarterlyfiscalcalendar_createdby one-to-many relationship for the systemuser table/entity.
transactioncurrency_quarterlyfiscalcalendar
See the transactioncurrency_quarterlyfiscalcalendar one-to-many relationship for the transactioncurrency table/entity.
lk_quarterlyfiscalcalendar_createdonbehalfby
See the lk_quarterlyfiscalcalendar_createdonbehalfby one-to-many relationship for the systemuser table/entity.
lk_quarterlyfiscalcalendar_salespersonid
See the lk_quarterlyfiscalcalendar_salespersonid one-to-many relationship for the systemuser table/entity.
lk_quarterlyfiscalcalendar_modifiedby
See the lk_quarterlyfiscalcalendar_modifiedby one-to-many relationship for the systemuser table/entity.
See also
Dataverse table/entity reference
Web API Reference
quarterlyfiscalcalendar EntityType
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기