Time Zone Definition (TimeZoneDefinition) table/entity reference

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
• 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

See also

Dataverse table/entity reference
Dataverse Web API Reference
timezonedefinition