편집

TimeZoneRule table/entity reference

  • 아티클

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

Definition for time conversion between local time and Coordinated Universal Time (UTC) for a particular time zone at a particular time period.

Messages

Message Web API Operation SDK class or method
Retrieve GET /timezonerules(timezoneruleid)
See Retrieve		 RetrieveRequest or
Retrieve
RetrieveMultiple GET /timezonerules
See Query Data		 RetrieveMultipleRequest or
RetrieveMultiple

Properties

Property Value
CollectionSchemaName TimeZoneRules
DisplayCollectionName Time Zone Rules
DisplayName Time Zone Rule
EntitySetName timezonerules
IsBPFEntity False
LogicalCollectionName timezonerules
LogicalName timezonerule
OwnershipType None
PrimaryIdAttribute timezoneruleid
PrimaryNameAttribute timezoneruleversionnumber
SchemaName TimeZoneRule

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

Bias

Property Value
Description Base time bias of the time zone rule.
DisplayName Bias
Format None
IsValidForForm True
IsValidForRead True
LogicalName bias
MaxValue 2147483647
MinValue -2147483648
RequiredLevel SystemRequired
Type Integer

DaylightBias

Property Value
Description Time bias in addition to the base bias for daylight savings time.
DisplayName Daylight Bias
Format None
IsValidForForm True
IsValidForRead True
LogicalName daylightbias
MaxValue 2147483647
MinValue -2147483648
RequiredLevel SystemRequired
Type Integer

DaylightDay

Property Value
Description Day of the month when daylight savings time starts.
DisplayName Daylight Day
Format None
IsValidForForm True
IsValidForRead True
LogicalName daylightday
MaxValue 31
MinValue 0
RequiredLevel SystemRequired
Type Integer

DaylightDayOfWeek

Property Value
Description Day of the week when daylight savings time starts.
DisplayName Daylight Day Of Week
Format None
IsValidForForm True
IsValidForRead True
LogicalName daylightdayofweek
MaxValue 6
MinValue 0
RequiredLevel SystemRequired
Type Integer

DaylightHour

Property Value
Description Hour of the day when daylight savings time starts
DisplayName Daylight Hour
Format None
IsValidForForm True
IsValidForRead True
LogicalName daylighthour
MaxValue 23
MinValue 0
RequiredLevel SystemRequired
Type Integer

DaylightMinute

Property Value
Description Minute of the hour when daylight savings time starts.
DisplayName Daylight Minute
Format None
IsValidForForm True
IsValidForRead True
LogicalName daylightminute
MaxValue 59
MinValue 0
RequiredLevel SystemRequired
Type Integer

DaylightMonth

Property Value
Description Month when daylight savings time starts.
DisplayName Daylight Month
Format None
IsValidForForm True
IsValidForRead True
LogicalName daylightmonth
MaxValue 12
MinValue 0
RequiredLevel SystemRequired
Type Integer

DaylightSecond

Property Value
Description Second of the minute when daylight savings time starts
DisplayName Daylight Second
Format None
IsValidForForm True
IsValidForRead True
LogicalName daylightsecond
MaxValue 59
MinValue 0
RequiredLevel SystemRequired
Type Integer

DaylightYear

Property Value
Description Year when daylight savings times starts.
DisplayName Daylight Year
Format None
IsValidForForm True
IsValidForRead True
LogicalName daylightyear
MaxValue 32768
MinValue 0
RequiredLevel SystemRequired
Type Integer

EffectiveDateTime

Property Value
DateTimeBehavior UserLocal
Description Time that this rule takes effect, in local time.
DisplayName Effective Date Time
Format DateOnly
IsValidForForm True
IsValidForRead True
LogicalName effectivedatetime
RequiredLevel SystemRequired
Type DateTime

StandardBias

Property Value
Description Time bias in addition to the base bias for standard time.
DisplayName Standard Bias
Format None
IsValidForForm True
IsValidForRead True
LogicalName standardbias
MaxValue 2147483647
MinValue -2147483648
RequiredLevel SystemRequired
Type Integer

StandardDay

Property Value
Description Day of the month when standard time starts.
DisplayName Standard Day
Format None
IsValidForForm True
IsValidForRead True
LogicalName standardday
MaxValue 31
MinValue 0
RequiredLevel SystemRequired
Type Integer

StandardDayOfWeek

Property Value
Description Day of the week when standard time starts.
DisplayName Standard Day Of Week
Format None
IsValidForForm True
IsValidForRead True
LogicalName standarddayofweek
MaxValue 6
MinValue 0
RequiredLevel SystemRequired
Type Integer

StandardHour

Property Value
Description Hour of the day when standard time starts.
DisplayName Standard Hour
Format None
IsValidForForm True
IsValidForRead True
LogicalName standardhour
MaxValue 23
MinValue 0
RequiredLevel SystemRequired
Type Integer

StandardMinute

Property Value
Description Minute of the hour when standard time starts.
DisplayName Standard Minute
Format None
IsValidForForm True
IsValidForRead True
LogicalName standardminute
MaxValue 59
MinValue 0
RequiredLevel SystemRequired
Type Integer

StandardMonth

Property Value
Description Month when standard time starts.
DisplayName Standard Month
Format None
IsValidForForm True
IsValidForRead True
LogicalName standardmonth
MaxValue 12
MinValue 0
RequiredLevel SystemRequired
Type Integer

StandardSecond

Property Value
Description Second of the Minute when standard time starts.
DisplayName Standard Second
Format None
IsValidForForm True
IsValidForRead True
LogicalName standardsecond
MaxValue 59
MinValue 0
RequiredLevel SystemRequired
Type Integer

StandardYear

Property Value
Description Year when standard time starts.
DisplayName Standard Year
Format None
IsValidForForm True
IsValidForRead True
LogicalName standardyear
MaxValue 32768
MinValue 0
RequiredLevel SystemRequired
Type Integer

TimeZoneDefinitionId

Property Value
Description Unique identifier of the time zone definition.
DisplayName Time Zone Definition
IsValidForForm False
IsValidForRead True
LogicalName timezonedefinitionid
RequiredLevel SystemRequired
Targets timezonedefinition
Type Lookup

TimeZoneRuleId

Property Value
Description Unique identifier of the time zone rule.
DisplayName Time Zone Rule
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName timezoneruleid
RequiredLevel SystemRequired
Type Uniqueidentifier

TimeZoneRuleVersionNumber

Property Value
Description For internal use only
DisplayName Time Zone Rule Version Number
Format None
IsValidForForm True
IsValidForRead True
LogicalName timezoneruleversionnumber
MaxValue 2147483647
MinValue -1
RequiredLevel SystemRequired
Type Integer

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.

CreatedBy

Property Value
Description Unique identifier of the user who created the time zone rule.
DisplayName Created By
IsValidForForm True
IsValidForRead True
LogicalName createdby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedOn

Property Value
DateTimeBehavior UserLocal
Description Date and time when the time zone rule was created.
DisplayName Created On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime

CreatedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who created the timezonerule.
DisplayName Created By (Delegate)
IsValidForForm True
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

ModifiedBy

Property Value
Description Unique identifier of the user who last modified the time zone rule.
DisplayName Modified By
IsValidForForm True
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedOn

Property Value
DateTimeBehavior UserLocal
Description Date and time when the time zone rule was modified.
DisplayName Modified On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime

ModifiedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who last modified the timezonerule.
DisplayName Modified By (Delegate)
IsValidForForm True
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

OrganizationId

Property Value
Description Unique identifier of the organization associated with the time zone rule.
DisplayName Organization
IsValidForForm False
IsValidForRead True
LogicalName organizationid
RequiredLevel None
Targets organization
Type Lookup

VersionNumber

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

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_timezonerule_createdby

See the lk_timezonerule_createdby one-to-many relationship for the systemuser table/entity.

lk_timezonerule_modifiedonbehalfby

See the lk_timezonerule_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.

lk_timezonerule_modifiedby

See the lk_timezonerule_modifiedby one-to-many relationship for the systemuser table/entity.

lk_timezonerule_timezonedefinitionid

See the lk_timezonerule_timezonedefinitionid one-to-many relationship for the timezonedefinition table/entity.

lk_timezonerule_createdonbehalfby

See the lk_timezonerule_createdonbehalfby one-to-many relationship for the systemuser table/entity.

See also

Dataverse table/entity reference
Web API Reference
timezonerule EntityType