편집

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 class or method
GetAllTimeZonesWithDisplayName GetAllTimeZonesWithDisplayName GetAllTimeZonesWithDisplayNameRequest
GetTimeZoneCodeByLocalizedName GetTimeZoneCodeByLocalizedName GetTimeZoneCodeByLocalizedNameRequest
LocalTimeFromUtcTime LocalTimeFromUtcTime LocalTimeFromUtcTimeRequest
Retrieve GET /timezonedefinitions(timezonedefinitionid)
See Retrieve		 RetrieveRequest or
Retrieve
RetrieveMultiple GET /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

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 the lk_timezonerule_timezonedefinitionid many-to-one relationship for the timezonerule table/entity.

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 the lk_timezonelocalizedname_timezonedefinitionid many-to-one relationship for the timezonelocalizedname table/entity.

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

See the lk_timezonedefinition_modifiedby one-to-many relationship for the systemuser table/entity.

lk_timezonedefinition_modifiedonbehalfby

See the lk_timezonedefinition_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.

lk_timezonedefinition_createdonbehalfby

See the lk_timezonedefinition_createdonbehalfby one-to-many relationship for the systemuser table/entity.

lk_timezonedefinition_createdby

See the lk_timezonedefinition_createdby one-to-many relationship for the systemuser table/entity.

See also

Dataverse table/entity reference
Web API Reference
timezonedefinition EntityType