title | description | ms.date | ms.service | ms.topic | ms.assetid | author | ms.author | search.audienceType | |
---|---|---|---|---|---|---|---|---|---|
AnnualFiscalCalendar table/entity reference (Microsoft Dataverse) | Microsoft Docs |
Includes schema information and supported messages for the AnnualFiscalCalendar table/entity. |
02/22/2024 |
powerapps |
reference |
3948cc48-07c8-7f60-0608-71c37158ad7c |
phecke |
pehecke |
|
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Year long fiscal calendar of an organization. A span of time during which the financial activities of an organization are calculated.
Message | Web API Operation | SDK class or method |
---|---|---|
Create | POST /annualfiscalcalendars See Create |
xref:Microsoft.Xrm.Sdk.Messages.CreateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Create* |
Delete | DELETE /annualfiscalcalendars(userfiscalcalendarid) See Delete |
xref:Microsoft.Xrm.Sdk.Messages.DeleteRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Delete* |
Retrieve | GET /annualfiscalcalendars(userfiscalcalendarid) See Retrieve |
xref:Microsoft.Xrm.Sdk.Messages.RetrieveRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Retrieve* |
RetrieveMultiple | GET /annualfiscalcalendars See Query Data |
xref:Microsoft.Xrm.Sdk.Messages.RetrieveMultipleRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.RetrieveMultiple* |
Update | PATCH /annualfiscalcalendars(userfiscalcalendarid) See Update |
xref:Microsoft.Xrm.Sdk.Messages.UpdateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Update* |
Property | Value |
---|---|
CollectionSchemaName | AnnualFiscalCalendars |
DisplayCollectionName | Annual Fiscal Calendars |
DisplayName | Annual Fiscal Calendar |
EntitySetName | annualfiscalcalendars |
IsBPFEntity | False |
LogicalCollectionName | annualfiscalcalendars |
LogicalName | annualfiscalcalendar |
OwnershipType | None |
PrimaryIdAttribute | userfiscalcalendarid |
PrimaryNameAttribute | |
SchemaName | AnnualFiscalCalendar |
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- EffectiveOn
- Period1
- SalesPersonId
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UserFiscalCalendarId
- UTCConversionTimeZoneCode
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the fiscal calendar sales quota takes effect. |
DisplayName | |
Format | DateOnly |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | effectiveon |
RequiredLevel | SystemRequired |
Type | DateTime |
Property | Value |
---|---|
Description | Sales quota for the first period in the fiscal year. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | annual |
MaxValue | 100000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | SystemRequired |
Type | Money |
Property | Value |
---|---|
Description | Unique identifier of the sales person associated with the sales quota. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | salespersonid |
RequiredLevel | SystemRequired |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timezoneruleversionnumber |
MaxValue | 2147483647 |
MinValue | -1 |
RequiredLevel | None |
Type | Integer |
Property | Value |
---|---|
Description | Unique identifier of the currency associated with the annual fiscal calendar. |
DisplayName | Currency |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | transactioncurrencyid |
RequiredLevel | ApplicationRequired |
Targets | transactioncurrency |
Type | Lookup |
Property | Value |
---|---|
Description | Unique identifier of the user associated with the annual fiscal calendar. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | userfiscalcalendarid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
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 |
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
- SalesPersonIdName
- SalesPersonIdYomiName
- TransactionCurrencyIdName
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | businessunitid |
RequiredLevel | ApplicationRequired |
Targets | businessunit |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | businessunitidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | Unique identifier of the user who created the quota for the annual fiscal calendar. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the quota for the annual fiscal calendar was created. |
DisplayName | |
Format | DateAndTime |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | SystemRequired |
Type | DateTime |
Property | Value |
---|---|
Description | Unique identifier of the delegate user who created the annualfiscalcalendar. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | Exchange rate for the currency associated with the annual 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 |
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 |
Property | Value |
---|---|
Description | Unique identifier of the user who last modified the quota for the annual fiscal calendar. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the annual fiscal calendar was last modified. |
DisplayName | |
Format | DateAndTime |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
Property | Value |
---|---|
Description | Unique identifier of the delegate user who last modified the annualfiscalcalendar. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | Base currency equivalent of the sales quota for the first period in the fiscal year. |
DisplayName | |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | annual_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | salespersonidname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | salespersonidyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | transactioncurrencyidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Listed by SchemaName.
Same as the AnnualFiscalCalendar_AsyncOperations many-to-one relationship for the asyncoperation table/entity.
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | AnnualFiscalCalendar_AsyncOperations |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Same as the AnnualFiscalCalendar_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure table/entity.
Property | Value |
---|---|
ReferencingEntity | bulkdeletefailure |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | AnnualFiscalCalendar_BulkDeleteFailures |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- transactioncurrency_annualfiscalcalendar
- lk_annualfiscalcalendar_salespersonid
- lk_annualfiscalcalendar_modifiedonbehalfby
- lk_annualfiscalcalendar_modifiedby
- lk_annualfiscalcalendar_createdonbehalfby
- lk_annualfiscalcalendar_createdby
See the transactioncurrency_annualfiscalcalendar one-to-many relationship for the transactioncurrency table/entity.
See the lk_annualfiscalcalendar_salespersonid one-to-many relationship for the systemuser table/entity.
See the lk_annualfiscalcalendar_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
See the lk_annualfiscalcalendar_modifiedby one-to-many relationship for the systemuser table/entity.
See the lk_annualfiscalcalendar_createdonbehalfby one-to-many relationship for the systemuser table/entity.
See the lk_annualfiscalcalendar_createdby one-to-many relationship for the systemuser table/entity.