TimeZoneDefinition table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Time zone definition, including name and time zone code.
Messages
| Message | Web API Operation | SDK Assembly |
|---|---|---|
| GetAllTimeZonesWithDisplayName | GetAllTimeZonesWithDisplayName Function | GetAllTimeZonesWithDisplayNameRequest |
| GetTimeZoneCodeByLocalizedName | GetTimeZoneCodeByLocalizedName Function | GetTimeZoneCodeByLocalizedNameRequest |
| LocalTimeFromUtcTime | LocalTimeFromUtcTime Function | LocalTimeFromUtcTimeRequest |
| Retrieve | GET [org URI]/api/data/v9.0/timezonedefinitions(timezonedefinitionid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/timezonedefinitions See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| UtcTimeFromLocalTime | UtcTimeFromLocalTimeRequest |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | TimeZoneDefinitions |
| DisplayCollectionName | Time Zone Definitions |
| DisplayName | Time Zone Definition |
| EntitySetName | timezonedefinitions |
| IsBPFEntity | False |
| LogicalCollectionName | timezonedefinitions |
| LogicalName | timezonedefinition |
| OwnershipType | None |
| PrimaryIdAttribute | timezonedefinitionid |
| PrimaryNameAttribute | userinterfacename |
| SchemaName | TimeZoneDefinition |
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 |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | bias |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
DaylightName
| Property | Value |
|---|---|
| Description | Time zone name for the daylight time. |
| DisplayName | Daylight Name |
| FormatName | Text |
| IsLocalizable | True |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | daylightname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
RetiredOrder
| Property | Value |
|---|---|
| Description | Order an entry for a time zone definition is retired. 0 for the latest entry. |
| DisplayName | Retired Order |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | retiredorder |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | SystemRequired |
| Type | Integer |
StandardName
| Property | Value |
|---|---|
| Description | Time zone name for the standard time. |
| DisplayName | Standard Name |
| FormatName | Text |
| IsLocalizable | True |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | standardname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
TimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone identification code. |
| DisplayName | Time Zone Code |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | timezonecode |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | SystemRequired |
| Type | Integer |
TimeZoneDefinitionId
| Property | Value |
|---|---|
| Description | Unique identifier of the time zone record. |
| DisplayName | Time Zone Definition |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| 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 |
| FormatName | Text |
| IsLocalizable | True |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | userinterfacename |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- 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 |
| Targets | systemuser |
| Type | Lookup |
CreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the time zone record 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 timezonedefinition. |
| 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 record. |
| 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 record 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 timezonedefinition. |
| 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 definition. |
| 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 |
One-To-Many Relationships
Listed by SchemaName.
lk_timezonerule_timezonedefinitionid
Same as timezonerule table lk_timezonerule_timezonedefinitionid Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | timezonerule |
| ReferencingAttribute | timezonedefinitionid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | lk_timezonerule_timezonedefinitionid |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
lk_timezonelocalizedname_timezonedefinitionid
Same as timezonelocalizedname table lk_timezonelocalizedname_timezonedefinitionid Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | timezonelocalizedname |
| ReferencingAttribute | timezonedefinitionid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | lk_timezonelocalizedname_timezonedefinitionid |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
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_timezonedefinition_modifiedby
- lk_timezonedefinition_modifiedonbehalfby
- lk_timezonedefinition_createdonbehalfby
- lk_timezonedefinition_createdby
lk_timezonedefinition_modifiedby
See systemuser Table lk_timezonedefinition_modifiedby One-To-Many relationship.
lk_timezonedefinition_modifiedonbehalfby
See systemuser Table lk_timezonedefinition_modifiedonbehalfby One-To-Many relationship.
lk_timezonedefinition_createdonbehalfby
See systemuser Table lk_timezonedefinition_createdonbehalfby One-To-Many relationship.
lk_timezonedefinition_createdby
See systemuser Table lk_timezonedefinition_createdby One-To-Many relationship.
See also
About the table reference
Web API Reference
timezonedefinition EntityType