MonthlyFiscalCalendar テーブル/エンティティの参照

  • [アーティクル]

注意

テーブルとエンティティの違いについて不明な点がありますか? 開発者: Microsoft Dataverse の用語を理解するを参照してください。

Monthly fiscal calendar of an organization. A span of time during which the financial activities of an organization are calculated.

メッセージ

メッセージ Web API 操作 SDK クラスまたはメソッド
Create POST [org URI]/api/data/v9.0/monthlyfiscalcalendars
作成を参照		 CreateRequest または
Create
Delete DELETE [org URI]/api/data/v9.0/monthlyfiscalcalendars(userfiscalcalendarid)
削除を参照		 DeleteRequest または
Delete
Retrieve GET [org URI]/api/data/v9.0/monthlyfiscalcalendars(userfiscalcalendarid)
取得を参照		 RetrieveRequest または
Retrieve
RetrieveMultiple GET [org URI]/api/data/v9.0/monthlyfiscalcalendars
データのクエリを参照		 RetrieveMultipleRequest または
RetrieveMultiple
Update PATCH [org URI]/api/data/v9.0/monthlyfiscalcalendars(userfiscalcalendarid)
更新を参照		 UpdateRequest または
Update

プロパティ

プロパティ 値
CollectionSchemaName MonthlyFiscalCalendars
DisplayCollectionName Monthly Fiscal Calendars
DisplayName Monthly Fiscal Calendar
EntitySetName monthlyfiscalcalendars
IsBPFEntity False
LogicalCollectionName monthlyfiscalcalendars
LogicalName monthlyfiscalcalendar
OwnershipType None
PrimaryIdAttribute userfiscalcalendarid
PrimaryNameAttribute
SchemaName MonthlyFiscalCalendar

書き込み可能な列/属性

これらの列/属性は IsValidForCreate または IsValidForUpdate のいずれかについて true を返します (通常は両方)。 SchemaName が一覧表示。

EffectiveOn

プロパティ 値
DateTimeBehavior UserLocal
Description Date and time when the monthly fiscal calendar sales quota takes effect.
DisplayName
Format DateOnly
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName effectiveon
RequiredLevel SystemRequired
Type DateTime

Period1

プロパティ 値
Description Sales quota for the first month in the fiscal year.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName month1
MaxValue 100000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel SystemRequired
Type Money

Period10

プロパティ 値
Description Sales quota for the tenth month in the fiscal year.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName month10
MaxValue 100000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel SystemRequired
Type Money

Period11

プロパティ 値
Description Sales quota for the eleventh month in the fiscal year.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName month11
MaxValue 100000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel SystemRequired
Type Money

Period12

プロパティ 値
Description Sales quota for the twelfth month in the fiscal year.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName month12
MaxValue 100000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel SystemRequired
Type Money

Period2

プロパティ 値
Description Sales quota for the second month in the fiscal year.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName month2
MaxValue 100000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel SystemRequired
Type Money

Period3

プロパティ 値
Description Sales quota for the third month in the fiscal year.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName month3
MaxValue 100000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel SystemRequired
Type Money

Period4

プロパティ 値
Description Sales quota for the fourth month in the fiscal year.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName month4
MaxValue 100000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel SystemRequired
Type Money

Period5

プロパティ 値
Description Sales quota for the fifth month in the fiscal year.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName month5
MaxValue 100000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel SystemRequired
Type Money

Period6

プロパティ 値
Description Sales quota for the sixth month in the fiscal year.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName month6
MaxValue 100000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel SystemRequired
Type Money

Period7

プロパティ 値
Description Sales quota for the seventh month in the fiscal year.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName month7
MaxValue 100000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel SystemRequired
Type Money

Period8

プロパティ 値
Description Sales quota for the eighth month in the fiscal year.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName month8
MaxValue 100000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel SystemRequired
Type Money

Period9

プロパティ 値
Description Sales quota for the ninth month in the fiscal year.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName month9
MaxValue 100000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel SystemRequired
Type Money

SalesPersonId

プロパティ 値
Description Unique identifier of the associated salesperson.
DisplayName
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName salespersonid
RequiredLevel SystemRequired
Targets systemuser
Type Lookup

TimeZoneRuleVersionNumber

プロパティ 値
Description For internal use only.
DisplayName
Format None
IsValidForForm False
IsValidForRead True
LogicalName timezoneruleversionnumber
MaxValue 2147483647
MinValue -1
RequiredLevel None
Type Integer

TransactionCurrencyId

プロパティ 値
Description Unique identifier of the currency associated with the monthly fiscal calendar.
DisplayName Currency
IsValidForForm True
IsValidForRead True
IsValidForUpdate False
LogicalName transactioncurrencyid
RequiredLevel ApplicationRequired
Targets transactioncurrency
Type Lookup

UserFiscalCalendarId

プロパティ 値
Description Unique identifier of the monthly fiscal calendar.
DisplayName
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName userfiscalcalendarid
RequiredLevel SystemRequired
Type Uniqueidentifier

UTCConversionTimeZoneCode

プロパティ 値
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

読み取り専用列/属性

これらの列/属性は IsValidForCreate または IsValidForUpdate の両方について false を返します。 SchemaName が一覧表示。

BusinessUnitId

プロパティ 値
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName businessunitid
RequiredLevel ApplicationRequired
Targets businessunit
Type Lookup

BusinessUnitIdName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName businessunitidname
MaxLength 100
RequiredLevel None
Type String

CreatedBy

プロパティ 値
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

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyname
MaxLength 100
RequiredLevel None
Type String

CreatedByYomiName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyyominame
MaxLength 100
RequiredLevel None
Type String

CreatedOn

プロパティ 値
DateTimeBehavior UserLocal
Description Date and time when the quota for the monthly fiscal calendar was modified.
DisplayName
Format DateAndTime
IsValidForForm False
IsValidForRead True
LogicalName createdon
RequiredLevel SystemRequired
Type DateTime

CreatedOnBehalfBy

プロパティ 値
Description Unique identifier of the delegate user who created the monthlyfiscalcalendar.
DisplayName Created By (Delegate)
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedOnBehalfByName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOnBehalfByYomiName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

ExchangeRate

プロパティ 値
Description Exchange rate for the currency associated with the 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

プロパティ 値
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

プロパティ 値
Description Unique identifier of the user who last modified the quota for the monthly fiscal calendar.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedByName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedByYomiName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyyominame
MaxLength 100
RequiredLevel None
Type String

ModifiedOn

プロパティ 値
DateTimeBehavior UserLocal
Description Date and time when the quota for the monthly fiscal calendar was last modified.
DisplayName
Format DateAndTime
IsValidForForm False
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime

ModifiedOnBehalfBy

プロパティ 値
Description Unique identifier of the delegate user who last modified the monthlyfiscalcalendar.
DisplayName Modified By (Delegate)
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedOnBehalfByName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOnBehalfByYomiName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

Period1_Base

プロパティ 値
Description Base currency equivalent of the sales quota for the first month in the fiscal year.
DisplayName
IsValidForForm True
IsValidForRead True
LogicalName month1_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

Period10_Base

プロパティ 値
Description Base currency equivalent of the sales quota for the tenth month in the fiscal year.
DisplayName
IsValidForForm True
IsValidForRead True
LogicalName month10_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

Period11_Base

プロパティ 値
Description Base currency equivalent of the sales quota for the eleventh month in the fiscal year.
DisplayName
IsValidForForm True
IsValidForRead True
LogicalName month11_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

Period12_Base

プロパティ 値
Description Base currency equivalent of the sales quota for the twelfth month in the fiscal year.
DisplayName
IsValidForForm True
IsValidForRead True
LogicalName month12_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

Period2_Base

プロパティ 値
Description Base currency equivalent of the sales quota for the second month in the fiscal year.
DisplayName
IsValidForForm True
IsValidForRead True
LogicalName month2_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

Period3_Base

プロパティ 値
Description Base currency equivalent of the sales quota for the third month in the fiscal year.
DisplayName
IsValidForForm True
IsValidForRead True
LogicalName month3_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

Period4_Base

プロパティ 値
Description Base currency equivalent of the sales quota for the fourth month in the fiscal year.
DisplayName
IsValidForForm True
IsValidForRead True
LogicalName month4_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

Period5_Base

プロパティ 値
Description Base currency equivalent of the sales quota for the fifth month in the fiscal year.
DisplayName
IsValidForForm True
IsValidForRead True
LogicalName month5_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

Period6_Base

プロパティ 値
Description Base currency equivalent of the sales quota for the sixth month in the fiscal year.
DisplayName
IsValidForForm True
IsValidForRead True
LogicalName month6_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

Period7_Base

プロパティ 値
Description Base currency equivalent of the sales quota for the seventh month in the fiscal year.
DisplayName
IsValidForForm True
IsValidForRead True
LogicalName month7_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

Period8_Base

プロパティ 値
Description Base currency equivalent of the sales quota for the eighth month in the fiscal year.
DisplayName
IsValidForForm True
IsValidForRead True
LogicalName month8_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

Period9_Base

プロパティ 値
Description Base currency equivalent of the sales quota for the ninth month in the fiscal year.
DisplayName
IsValidForForm True
IsValidForRead True
LogicalName month9_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

SalesPersonIdName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName salespersonidname
MaxLength 100
RequiredLevel SystemRequired
Type String

SalesPersonIdYomiName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName salespersonidyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

TransactionCurrencyIdName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName transactioncurrencyidname
MaxLength 100
RequiredLevel None
Type String

一対多関連付け

SchemaName が一覧表示。

MonthlyFiscalCalendar_AsyncOperations

asyncoperation テーブル/エンティティの多対一のリレーションシップ MonthlyFiscalCalendar_AsyncOperations と同じです。

プロパティ 値
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName MonthlyFiscalCalendar_AsyncOperations
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

MonthlyFiscalCalendar_BulkDeleteFailures

bulkdeletefailure テーブル/エンティティの多対一のリレーションシップ MonthlyFiscalCalendar_BulkDeleteFailures と同じです。

プロパティ 値
ReferencingEntity bulkdeletefailure
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName MonthlyFiscalCalendar_BulkDeleteFailures
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

多対一関連付け

各多対一の関係付けは、関連するテーブルとの対応する一対多の関係付けによって定義されます。 SchemaName が一覧表示。

lk_monthlyfiscalcalendar_modifiedonbehalfby

systemuser テーブル/エンティティの一対多のリレーションシップ lk_monthlyfiscalcalendar_modifiedonbehalfby を参照してください。

lk_monthlyfiscalcalendar_modifiedby

systemuser テーブル/エンティティの一対多のリレーションシップ lk_monthlyfiscalcalendar_modifiedby を参照してください。

lk_monthlyfiscalcalendar_createdonbehalfby

systemuser テーブル/エンティティの一対多のリレーションシップ lk_monthlyfiscalcalendar_createdonbehalfby を参照してください。

transactioncurrency_monthlyfiscalcalendar

transactioncurrency テーブル/エンティティの一対多のリレーションシップ transactioncurrency_monthlyfiscalcalendar を参照してください。

lk_monthlyfiscalcalendar_salespersonid

systemuser テーブル/エンティティの一対多のリレーションシップ lk_monthlyfiscalcalendar_salespersonid を参照してください。

lk_monthlyfiscalcalendar_createdby

systemuser テーブル/エンティティの一対多のリレーションシップ lk_monthlyfiscalcalendar_createdby を参照してください。

関連項目

Dataverse テーブル/エンティティ参照 Web API リファレンス monthlyfiscalcalendar EntityType