Time Zone Definition (TimeZoneDefinition) table/entity reference

  • Article

Time zone definition, including name and time zone code.

Messages

The following table lists the messages for the Time Zone Definition (TimeZoneDefinition) 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
GetAllTimeZonesWithDisplayName
Event: False		 GetAllTimeZonesWithDisplayName GetAllTimeZonesWithDisplayNameRequest
GetTimeZoneCodeByLocalizedName
Event: False		 GetTimeZoneCodeByLocalizedName GetTimeZoneCodeByLocalizedNameRequest
LocalTimeFromUtcTime
Event: False		 LocalTimeFromUtcTime LocalTimeFromUtcTimeRequest
Retrieve
Event: False		 GET /timezonedefinitions(timezonedefinitionid)
See Retrieve		 Retrieve records
RetrieveMultiple
Event: False		 GET /timezonedefinitions
See Query data		 Query data
UtcTimeFromLocalTime
Event: False		 UtcTimeFromLocalTimeRequest

Properties

The following table lists selected properties for the Time Zone Definition (TimeZoneDefinition) table.

Property Value
DisplayName Time Zone Definition
DisplayCollectionName Time Zone Definitions
SchemaName TimeZoneDefinition
CollectionSchemaName TimeZoneDefinitions
EntitySetName timezonedefinitions
LogicalName timezonedefinition
LogicalCollectionName timezonedefinitions
PrimaryIdAttribute timezonedefinitionid
PrimaryNameAttribute userinterfacename
TableType Standard
OwnershipType None

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.
DisplayName Bias
IsValidForForm True
IsValidForRead True
LogicalName bias
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

DaylightName

Property Value
Description Time zone name for the daylight time.
DisplayName Daylight Name
IsValidForForm True
IsValidForRead True
LogicalName daylightname
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable True
MaxLength 100

RetiredOrder

Property Value
Description Order an entry for a time zone definition is retired. 0 for the latest entry.
DisplayName Retired Order
IsValidForForm True
IsValidForRead True
LogicalName retiredorder
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

StandardName

Property Value
Description Time zone name for the standard time.
DisplayName Standard Name
IsValidForForm True
IsValidForRead True
LogicalName standardname
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable True
MaxLength 100

TimeZoneCode

Property Value
Description Time zone identification code.
DisplayName Time Zone Code
IsValidForForm True
IsValidForRead True
LogicalName timezonecode
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

TimeZoneDefinitionId

Property Value
Description Unique identifier of the time zone record.
DisplayName Time Zone Definition
IsValidForForm False
IsValidForRead True
LogicalName timezonedefinitionid
RequiredLevel SystemRequired
Type Uniqueidentifier

UserInterfaceName

Property Value
Description Display name for the time zone in the Microsoft Windows registry.
DisplayName User Interface Name
IsValidForForm True
IsValidForRead True
LogicalName userinterfacename
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable True
MaxLength 100

Read-only columns/attributes

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

CreatedBy

Property Value
Description Unique identifier of the user who created the time zone record.
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 record 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 timezonedefinition.
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 record.
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 record 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 timezonedefinition.
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 definition.
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_timezonedefinition_createdby

One-To-Many Relationship: systemuser lk_timezonedefinition_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_timezonedefinition_createdonbehalfby

One-To-Many Relationship: systemuser lk_timezonedefinition_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_timezonedefinition_modifiedby

One-To-Many Relationship: systemuser lk_timezonedefinition_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_timezonedefinition_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_timezonedefinition_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

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

lk_timezonelocalizedname_timezonedefinitionid

Many-To-One Relationship: timezonelocalizedname lk_timezonelocalizedname_timezonedefinitionid

Property Value
ReferencingEntity timezonelocalizedname
ReferencingAttribute timezonedefinitionid
ReferencedEntityNavigationPropertyName lk_timezonelocalizedname_timezonedefinitionid
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

lk_timezonerule_timezonedefinitionid

Many-To-One Relationship: timezonerule lk_timezonerule_timezonedefinitionid

Property Value
ReferencingEntity timezonerule
ReferencingAttribute timezonedefinitionid
ReferencedEntityNavigationPropertyName lk_timezonerule_timezonedefinitionid
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
timezonedefinition