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
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru