Time Zone Definition (TimeZoneDefinition) table/entity reference (Microsoft Dataverse)

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
`Associate` Event: True	Associate records	Associate records
`Disassociate` Event: True	Disassociate records	Disassociate records
`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
DaylightName
RetiredOrder
StandardName
TimeZoneCode
TimeZoneDefinitionId
UserInterfaceName

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
CreatedOn
CreatedOnBehalfBy
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OrganizationId
VersionNumber

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
lk_timezonedefinition_createdonbehalfby
lk_timezonedefinition_modifiedby
lk_timezonedefinition_modifiedonbehalfby

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
lk_timezonerule_timezonedefinitionid

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`

Feedback

Was this page helpful?

Last updated on 2025-10-31