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

注意

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

Fixed 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/fixedmonthlyfiscalcalendars 作成を参照	CreateRequest または Create
Delete	DELETE [org URI]/api/data/v9.0/fixedmonthlyfiscalcalendars(userfiscalcalendarid) 削除を参照	DeleteRequest または Delete
Retrieve	GET [org URI]/api/data/v9.0/fixedmonthlyfiscalcalendars(userfiscalcalendarid) 取得を参照	RetrieveRequest または Retrieve
RetrieveMultiple	GET [org URI]/api/data/v9.0/fixedmonthlyfiscalcalendars データのクエリを参照	RetrieveMultipleRequest または RetrieveMultiple
Update	PATCH [org URI]/api/data/v9.0/fixedmonthlyfiscalcalendars(userfiscalcalendarid) 更新を参照	UpdateRequest または Update

プロパティ

プロパティ	値
CollectionSchemaName	FixedMonthlyFiscalCalendars
DisplayCollectionName	Fixed Monthly Fiscal Calendars
DisplayName	Fixed Monthly Fiscal Calendar
EntitySetName	fixedmonthlyfiscalcalendars
IsBPFEntity	False
LogicalCollectionName	fixedmonthlyfiscalcalendars
LogicalName	fixedmonthlyfiscalcalendar
OwnershipType	None
PrimaryIdAttribute	userfiscalcalendarid
PrimaryNameAttribute
SchemaName	FixedMonthlyFiscalCalendar

書き込み可能な列/属性

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

• EffectiveOn
• Period1
• Period10
• Period11
• Period12
• Period13
• Period2
• Period3
• Period4
• Period5
• Period6
• Period7
• Period8
• Period9
• SalesPersonId
• TimeZoneRuleVersionNumber
• TransactionCurrencyId
• UserFiscalCalendarId
• UTCConversionTimeZoneCode

EffectiveOn

プロパティ	値
DateTimeBehavior	UserLocal
Description	Date and time when the fixed 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 period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period1
MaxValue	100000000000
MinValue	0
Precision	2
PrecisionSource	2
RequiredLevel	SystemRequired
Type	Money

Period10

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

Period11

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

Period12

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

Period13

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

Period2

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

Period3

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

Period4

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

Period5

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

Period6

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

Period7

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

Period8

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

Period9

プロパティ	値
Description	Sales quota for the ninth period in the fiscal year.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	period9
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 fixed 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 user of the 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
• Period13_Base
• Period2_Base
• Period3_Base
• Period4_Base
• Period5_Base
• Period6_Base
• Period7_Base
• Period8_Base
• Period9_Base
• SalesPersonIdName
• SalesPersonIdYomiName
• TransactionCurrencyIdName

BusinessUnitId

プロパティ	値
Description	Business unit responsible for the quota associated with this calendar.
DisplayName	Business Unit
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 fixed monthly fiscal calendar was created.
DisplayName
Format	DateAndTime
IsValidForForm	False
IsValidForRead	True
LogicalName	createdon
RequiredLevel	SystemRequired
Type	DateTime

CreatedOnBehalfBy

プロパティ	値
Description	Unique identifier of the delegate user who created the fixedmonthlyfiscalcalendar.
DisplayName
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 fixed 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 fixed monthly fiscal calendar 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 fixed 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 fixed 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 fixedmonthlyfiscalcalendar.
DisplayName
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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period1_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period10_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period11_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period12_base
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2
RequiredLevel	None
Type	Money

Period13_Base

プロパティ	値
Description	Base currency equivalent of the sales quota for the thirteenth period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period13_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period2_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period3_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period4_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period5_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period6_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period7_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period8_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 period in the fiscal year.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	period9_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 が一覧表示。

• FixedMonthlyFiscalCalendar_AsyncOperations
• FixedMonthlyFiscalCalendar_BulkDeleteFailures

FixedMonthlyFiscalCalendar_AsyncOperations

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

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

FixedMonthlyFiscalCalendar_BulkDeleteFailures

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

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

多対一関連付け

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

• transactioncurrency_fixedmonthlyfiscalcalendar
• lk_fixedmonthlyfiscalcalendar_salespersonid
• lk_fixedmonthlyfiscalcalendar_modifiedby
• lk_fixedmonthlyfiscalcalendar_createdby
• lk_fixedmonthlyfiscalcalendar_createdonbehalfby
• lk_fixedmonthlyfiscalcalendar_modifiedonbehalfby

transactioncurrency_fixedmonthlyfiscalcalendar

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

lk_fixedmonthlyfiscalcalendar_salespersonid

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

lk_fixedmonthlyfiscalcalendar_modifiedby

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

lk_fixedmonthlyfiscalcalendar_createdby

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

lk_fixedmonthlyfiscalcalendar_createdonbehalfby

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

lk_fixedmonthlyfiscalcalendar_modifiedonbehalfby

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

関連項目

テーブルの参照について
Web API リファレンス
fixedmonthlyfiscalcalendar EntityType