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
• Period1
• Period10
• Period11
• Period12
• Period2
• Period3
• Period4
• Period5
• Period6
• Period7
• Period8
• Period9
• SalesPersonId
• TimeZoneRuleVersionNumber
• TransactionCurrencyId
• UserFiscalCalendarId
• UTCConversionTimeZoneCode

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
• BusinessUnitIdName
• CreatedBy
• CreatedByName
• CreatedByYomiName
• CreatedOn
• CreatedOnBehalfBy
• CreatedOnBehalfByName
• CreatedOnBehalfByYomiName
• ExchangeRate
• FiscalPeriodType
• ModifiedBy
• ModifiedByName
• ModifiedByYomiName
• ModifiedOn
• ModifiedOnBehalfBy
• ModifiedOnBehalfByName
• ModifiedOnBehalfByYomiName
• Period1_Base
• Period10_Base
• Period11_Base
• Period12_Base
• Period2_Base
• Period3_Base
• Period4_Base
• Period5_Base
• Period6_Base
• Period7_Base
• Period8_Base
• Period9_Base
• SalesPersonIdName
• SalesPersonIdYomiName
• TransactionCurrencyIdName

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
• MonthlyFiscalCalendar_BulkDeleteFailures

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
• lk_monthlyfiscalcalendar_modifiedby
• lk_monthlyfiscalcalendar_createdonbehalfby
• transactioncurrency_monthlyfiscalcalendar
• lk_monthlyfiscalcalendar_salespersonid
• lk_monthlyfiscalcalendar_createdby

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