Time Zone Rule (TimeZoneRule) table/entity reference
Definition for time conversion between local time and Coordinated Universal Time (UTC) for a particular time zone at a particular time period.
Messages
The following table lists the messages for the Time Zone Rule (TimeZoneRule) table. Messages represent operations that can be performed on the table. They may also be events.
Name Is Event? |
Web API Operation | SDK for .NET |
---|---|---|
Retrieve Event: False |
GET /timezonerules(timezoneruleid)See Retrieve |
Retrieve records |
RetrieveMultiple Event: False |
GET /timezonerulesSee Query data |
Query data |
Properties
The following table lists selected properties for the Time Zone Rule (TimeZoneRule) table.
Property | Value |
---|---|
DisplayName | Time Zone Rule |
DisplayCollectionName | Time Zone Rules |
SchemaName | TimeZoneRule |
CollectionSchemaName | TimeZoneRules |
EntitySetName | timezonerules |
LogicalName | timezonerule |
LogicalCollectionName | timezonerules |
PrimaryIdAttribute | timezoneruleid |
PrimaryNameAttribute | timezoneruleversionnumber |
TableType | Standard |
OwnershipType | None |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- Bias
- DaylightBias
- DaylightDay
- DaylightDayOfWeek
- DaylightHour
- DaylightMinute
- DaylightMonth
- DaylightSecond
- DaylightYear
- EffectiveDateTime
- StandardBias
- StandardDay
- StandardDayOfWeek
- StandardHour
- StandardMinute
- StandardMonth
- StandardSecond
- StandardYear
- TimeZoneDefinitionId
- TimeZoneRuleId
- TimeZoneRuleVersionNumber
Bias
Property | Value |
---|---|
Description | Base time bias of the time zone rule. |
DisplayName | Bias |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | bias |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -2147483648 |
DaylightBias
Property | Value |
---|---|
Description | Time bias in addition to the base bias for daylight savings time. |
DisplayName | Daylight Bias |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | daylightbias |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -2147483648 |
DaylightDay
Property | Value |
---|---|
Description | Day of the month when daylight savings time starts. |
DisplayName | Daylight Day |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | daylightday |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 31 |
MinValue | 0 |
DaylightDayOfWeek
Property | Value |
---|---|
Description | Day of the week when daylight savings time starts. |
DisplayName | Daylight Day Of Week |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | daylightdayofweek |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 6 |
MinValue | 0 |
DaylightHour
Property | Value |
---|---|
Description | Hour of the day when daylight savings time starts |
DisplayName | Daylight Hour |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | daylighthour |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 23 |
MinValue | 0 |
DaylightMinute
Property | Value |
---|---|
Description | Minute of the hour when daylight savings time starts. |
DisplayName | Daylight Minute |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | daylightminute |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 59 |
MinValue | 0 |
DaylightMonth
Property | Value |
---|---|
Description | Month when daylight savings time starts. |
DisplayName | Daylight Month |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | daylightmonth |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 12 |
MinValue | 0 |
DaylightSecond
Property | Value |
---|---|
Description | Second of the minute when daylight savings time starts |
DisplayName | Daylight Second |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | daylightsecond |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 59 |
MinValue | 0 |
DaylightYear
Property | Value |
---|---|
Description | Year when daylight savings times starts. |
DisplayName | Daylight Year |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | daylightyear |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 32768 |
MinValue | 0 |
EffectiveDateTime
Property | Value |
---|---|
Description | Time that this rule takes effect, in local time. |
DisplayName | Effective Date Time |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | effectivedatetime |
RequiredLevel | SystemRequired |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateOnly |
ImeMode | Inactive |
SourceTypeMask | 0 |
StandardBias
Property | Value |
---|---|
Description | Time bias in addition to the base bias for standard time. |
DisplayName | Standard Bias |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | standardbias |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -2147483648 |
StandardDay
Property | Value |
---|---|
Description | Day of the month when standard time starts. |
DisplayName | Standard Day |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | standardday |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 31 |
MinValue | 0 |
StandardDayOfWeek
Property | Value |
---|---|
Description | Day of the week when standard time starts. |
DisplayName | Standard Day Of Week |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | standarddayofweek |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 6 |
MinValue | 0 |
StandardHour
Property | Value |
---|---|
Description | Hour of the day when standard time starts. |
DisplayName | Standard Hour |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | standardhour |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 23 |
MinValue | 0 |
StandardMinute
Property | Value |
---|---|
Description | Minute of the hour when standard time starts. |
DisplayName | Standard Minute |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | standardminute |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 59 |
MinValue | 0 |
StandardMonth
Property | Value |
---|---|
Description | Month when standard time starts. |
DisplayName | Standard Month |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | standardmonth |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 12 |
MinValue | 0 |
StandardSecond
Property | Value |
---|---|
Description | Second of the Minute when standard time starts. |
DisplayName | Standard Second |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | standardsecond |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 59 |
MinValue | 0 |
StandardYear
Property | Value |
---|---|
Description | Year when standard time starts. |
DisplayName | Standard Year |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | standardyear |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 32768 |
MinValue | 0 |
TimeZoneDefinitionId
Property | Value |
---|---|
Description | Unique identifier of the time zone definition. |
DisplayName | Time Zone Definition |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timezonedefinitionid |
RequiredLevel | SystemRequired |
Type | Lookup |
Targets | timezonedefinition |
TimeZoneRuleId
Property | Value |
---|---|
Description | Unique identifier of the time zone rule. |
DisplayName | Time Zone Rule |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timezoneruleid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
TimeZoneRuleVersionNumber
Property | Value |
---|---|
Description | For internal use only |
DisplayName | Time Zone Rule Version Number |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | timezoneruleversionnumber |
RequiredLevel | SystemRequired |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -1 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- OrganizationId
- VersionNumber
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 |
Type | Lookup |
Targets | systemuser |
CreatedOn
Property | Value |
---|---|
Description | Date and time when the time zone rule was created. |
DisplayName | Created On |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
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 |
Type | Lookup |
Targets | systemuser |
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 |
Type | Lookup |
Targets | systemuser |
ModifiedOn
Property | Value |
---|---|
Description | Date and time when the time zone rule was modified. |
DisplayName | Modified On |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
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 |
Type | Lookup |
Targets | systemuser |
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 |
Type | Lookup |
Targets | organization |
VersionNumber
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
RequiredLevel | None |
Type | BigInt |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
Many-to-One relationships
These relationships are many-to-one. Listed by SchemaName.
- lk_timezonerule_createdby
- lk_timezonerule_createdonbehalfby
- lk_timezonerule_modifiedby
- lk_timezonerule_modifiedonbehalfby
- lk_timezonerule_timezonedefinitionid
lk_timezonerule_createdby
One-To-Many Relationship: systemuser lk_timezonerule_createdby
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | createdby |
ReferencingEntityNavigationPropertyName | createdby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
lk_timezonerule_createdonbehalfby
One-To-Many Relationship: systemuser lk_timezonerule_createdonbehalfby
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | createdonbehalfby |
ReferencingEntityNavigationPropertyName | createdonbehalfby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
lk_timezonerule_modifiedby
One-To-Many Relationship: systemuser lk_timezonerule_modifiedby
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | modifiedby |
ReferencingEntityNavigationPropertyName | modifiedby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
lk_timezonerule_modifiedonbehalfby
One-To-Many Relationship: systemuser lk_timezonerule_modifiedonbehalfby
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | modifiedonbehalfby |
ReferencingEntityNavigationPropertyName | modifiedonbehalfby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
lk_timezonerule_timezonedefinitionid
One-To-Many Relationship: timezonedefinition lk_timezonerule_timezonedefinitionid
Property | Value |
---|---|
ReferencedEntity | timezonedefinition |
ReferencedAttribute | timezonedefinitionid |
ReferencingAttribute | timezonedefinitionid |
ReferencingEntityNavigationPropertyName | timezonedefinitionid |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
See also
Dataverse table/entity reference
Dataverse Web API Reference
timezonerule