SemiAnnualFiscalCalendar table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Calendar representing the semi-annual span of time during which the financial activities of an organization are calculated.
Messages
| Message | Web API Operation | SDK Assembly |
|---|---|---|
| Create | POST [org URI]/api/data/v9.0/semiannualfiscalcalendars See Create |
CreateRequest or Create |
| Delete | DELETE [org URI]/api/data/v9.0/semiannualfiscalcalendars(userfiscalcalendarid) See Delete |
DeleteRequest or Delete |
| Retrieve | GET [org URI]/api/data/v9.0/semiannualfiscalcalendars(userfiscalcalendarid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/semiannualfiscalcalendars See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| Update | PATCH [org URI]/api/data/v9.0/semiannualfiscalcalendars(userfiscalcalendarid) See Update |
UpdateRequest or Update |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | SemiAnnualFiscalCalendars |
| DisplayCollectionName | Semiannual Fiscal Calendars |
| DisplayName | Semiannual Fiscal Calendar |
| EntitySetName | semiannualfiscalcalendars |
| IsBPFEntity | False |
| LogicalCollectionName | semiannualfiscalcalendars |
| LogicalName | semiannualfiscalcalendar |
| OwnershipType | None |
| PrimaryIdAttribute | userfiscalcalendarid |
| PrimaryNameAttribute | |
| SchemaName | SemiAnnualFiscalCalendar |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- EffectiveOn
- ImportSequenceNumber
- Period1
- Period7
- SalesPersonId
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UserFiscalCalendarId
- UTCConversionTimeZoneCode
EffectiveOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the semiannual fiscal calendar sales quota takes effect. |
| DisplayName | |
| Format | DateOnly |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | effectiveon |
| RequiredLevel | SystemRequired |
| Type | DateTime |
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Unique identifier of the data import or data migration that created this record. |
| DisplayName | Import Sequence Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | importsequencenumber |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
Period1
| Property | Value |
|---|---|
| Description | Sales quota for the first half of the fiscal year. |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | firsthalf |
| MaxValue | 100000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | SystemRequired |
| Type | Money |
Period7
| Property | Value |
|---|---|
| Description | Sales quota for the second half of the fiscal year. |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | secondhalf |
| 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 semiannual fiscal calendar. |
| DisplayName | Currency |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | transactioncurrencyid |
| RequiredLevel | ApplicationRequired |
| Targets | transactioncurrency |
| Type | Lookup |
UserFiscalCalendarId
| Property | Value |
|---|---|
| Description | Unique identifier for the user who created the semiannual 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
- Period7_Base
- SalesPersonIdName
- SalesPersonIdYomiName
- TransactionCurrencyIdName
BusinessUnitId
| Property | Value |
|---|---|
| Description | Unique identifier of the business unit with which the calendar is associated. |
| 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 semiannual 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 semiannual 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 semiannualfiscalcalendar. |
| 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 semiannual 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 semiannual 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 semiannual 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 semiannualfiscalcalendar. |
| 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 for the sales quota for the first half of the fiscal year. |
| DisplayName | |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | firsthalf_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 second half of the fiscal year. |
| DisplayName | |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | secondhalf_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.
SemiAnnualFiscalCalendar_AsyncOperations
Same as asyncoperation table SemiAnnualFiscalCalendar_AsyncOperations Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SemiAnnualFiscalCalendar_AsyncOperations |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SemiAnnualFiscalCalendar_BulkDeleteFailures
Same as bulkdeletefailure table SemiAnnualFiscalCalendar_BulkDeleteFailures Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SemiAnnualFiscalCalendar_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_semiannualfiscalcalendar_createdonbehalfby
- lk_semiannualfiscalcalendar_salespersonid
- lk_semiannualfiscalcalendar_modifiedonbehalfby
- lk_semiannualfiscalcalendar_modifiedby
- lk_semiannualfiscalcalendar_createdby
- transactioncurrency_semiannualfiscalcalendar
lk_semiannualfiscalcalendar_createdonbehalfby
See systemuser Table lk_semiannualfiscalcalendar_createdonbehalfby One-To-Many relationship.
lk_semiannualfiscalcalendar_salespersonid
See systemuser Table lk_semiannualfiscalcalendar_salespersonid One-To-Many relationship.
lk_semiannualfiscalcalendar_modifiedonbehalfby
See systemuser Table lk_semiannualfiscalcalendar_modifiedonbehalfby One-To-Many relationship.
lk_semiannualfiscalcalendar_modifiedby
See systemuser Table lk_semiannualfiscalcalendar_modifiedby One-To-Many relationship.
lk_semiannualfiscalcalendar_createdby
See systemuser Table lk_semiannualfiscalcalendar_createdby One-To-Many relationship.
transactioncurrency_semiannualfiscalcalendar
See transactioncurrency Table transactioncurrency_semiannualfiscalcalendar One-To-Many relationship.
See also
About the table reference
Web API Reference
semiannualfiscalcalendar EntityType