Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Entity used for time entry.
Messages
The following table lists the messages for the Time Entry (msdyn_timeentry) 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 |
|---|---|---|
AssignEvent: True |
PATCH /msdyn_timeentries(msdyn_timeentryid)Update the ownerid property. |
AssignRequest |
AssociateEvent: True |
Associate records | Associate records |
BulkRetainEvent: True |
BulkRetain | Learn to use messages with the SDK for .NET |
CreateEvent: True |
POST /msdyn_timeentriesSee Create |
Create records |
CreateMultipleEvent: True |
CreateMultiple | CreateMultipleRequest |
DeleteEvent: True |
DELETE /msdyn_timeentries(msdyn_timeentryid)See Delete |
Delete records |
DisassociateEvent: True |
Disassociate records | Disassociate records |
GrantAccessEvent: True |
GrantAccess | GrantAccessRequest |
IsValidStateTransitionEvent: False |
IsValidStateTransition | IsValidStateTransitionRequest |
ModifyAccessEvent: True |
ModifyAccess | ModifyAccessRequest |
PurgeRetainedContentEvent: True |
PurgeRetainedContent | Learn to use messages with the SDK for .NET |
RestoreEvent: True |
Restore | Learn to use messages with the SDK for .NET |
RetainEvent: True |
Retain | Learn to use messages with the SDK for .NET |
RetrieveEvent: True |
GET /msdyn_timeentries(msdyn_timeentryid)See Retrieve |
Retrieve records |
RetrieveMultipleEvent: True |
GET /msdyn_timeentriesSee Query data |
Query data |
RetrievePrincipalAccessEvent: True |
RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccessEvent: True |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccessEvent: True |
RevokeAccess | RevokeAccessRequest |
RollbackRetainEvent: True |
RollbackRetain | Learn to use messages with the SDK for .NET |
SetStateEvent: True |
PATCH /msdyn_timeentries(msdyn_timeentryid)Update the statecode and statuscode properties. |
SetStateRequest |
UpdateEvent: True |
PATCH /msdyn_timeentries(msdyn_timeentryid)See Update |
Update records |
UpdateMultipleEvent: True |
UpdateMultiple | UpdateMultipleRequest |
UpsertEvent: False |
PATCH /msdyn_timeentries(msdyn_timeentryid)See Upsert a table row |
UpsertRequest |
UpsertMultipleEvent: False |
UpsertMultiple | UpsertMultipleRequest |
ValidateRetentionConfigEvent: True |
ValidateRetentionConfig | Learn to use messages with the SDK for .NET |
Properties
The following table lists selected properties for the Time Entry (msdyn_timeentry) table.
| Property | Value |
|---|---|
| DisplayName | Time Entry |
| DisplayCollectionName | Time Entries |
| SchemaName | msdyn_timeentry |
| CollectionSchemaName | msdyn_timeentries |
| EntitySetName | msdyn_timeentries |
| LogicalName | msdyn_timeentry |
| LogicalCollectionName | msdyn_timeentries |
| PrimaryIdAttribute | msdyn_timeentryid |
| PrimaryNameAttribute | msdyn_description |
| TableType | Standard |
| OwnershipType | UserOwned |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ImportSequenceNumber
- msdyn_bookableresource
- msdyn_BookableResourceBooking
- msdyn_BookingStatus
- msdyn_description
- msdyn_duration
- msdyn_end
- msdyn_entryStatus
- msdyn_externalDescription
- msdyn_internalflags
- msdyn_start
- msdyn_timeentryId
- msdyn_timeentrysettingId
- msdyn_timeoffrequest
- msdyn_type
- msdyn_WorkOrder
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- processid
- stageid
- statecode
- statuscode
- TimeZoneRuleVersionNumber
- traversedpath
- UTCConversionTimeZoneCode
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Sequence number of the import that created this record. |
| DisplayName | Import Sequence Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | importsequencenumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
msdyn_bookableresource
| Property | Value |
|---|---|
| Description | Shows the bookable resource. |
| DisplayName | Bookable Resource |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_bookableresource |
| RequiredLevel | None |
| Type | Lookup |
| Targets | bookableresource |
msdyn_BookableResourceBooking
| Property | Value |
|---|---|
| Description | Unique identifier for Resource Booking associated with Time Entry. |
| DisplayName | Bookable Resource Booking |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_bookableresourcebooking |
| RequiredLevel | None |
| Type | Lookup |
| Targets | bookableresourcebooking |
msdyn_BookingStatus
| Property | Value |
|---|---|
| Description | Booking Status |
| DisplayName | Booking Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_bookingstatus |
| RequiredLevel | None |
| Type | Lookup |
| Targets | bookingstatus |
msdyn_description
| Property | Value |
|---|---|
| Description | Type the description of the time entry. |
| DisplayName | Description |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_description |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
msdyn_duration
| Property | Value |
|---|---|
| Description | Shows the time spent. |
| DisplayName | Duration |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_duration |
| RequiredLevel | ApplicationRequired |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
msdyn_end
| Property | Value |
|---|---|
| Description | The end time of the time entry. |
| DisplayName | End |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_end |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Auto |
| SourceTypeMask | 0 |
msdyn_entryStatus
| Property | Value |
|---|---|
| Description | Select the entry status. |
| DisplayName | Entry Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_entrystatus |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 192350000 |
| GlobalChoiceName | msdyn_timeentrystatus |
msdyn_entryStatus Choices/Options
| Value | Label |
|---|---|
| 192350000 | Draft |
| 192350001 | Returned |
| 192350002 | Approved |
| 192350003 | Submitted |
| 192354320 | Cancelled |
msdyn_externalDescription
| Property | Value |
|---|---|
| Description | Type the external description of the time entry. |
| DisplayName | External Comments |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_externaldescription |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
msdyn_internalflags
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Internal Flags |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_internalflags |
| RequiredLevel | None |
| Type | Memo |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1048576 |
msdyn_start
| Property | Value |
|---|---|
| Description | The start time of the time entry. |
| DisplayName | Start |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_start |
| RequiredLevel | ApplicationRequired |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Auto |
| SourceTypeMask | 0 |
msdyn_timeentryId
| Property | Value |
|---|---|
| Description | The unique identifier for a time entry. |
| DisplayName | Time Entry |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | msdyn_timeentryid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
msdyn_timeentrysettingId
| Property | Value |
|---|---|
| Description | Unique identifier for Time Source associated with Time Entry. |
| DisplayName | Time Source |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_timeentrysettingid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | msdyn_timeentrysetting |
msdyn_timeoffrequest
| Property | Value |
|---|---|
| Description | Unique identifier for Time Off Request associated with Time Entry. This field is auto-populated when a Time Entry is auto-created from a Time Off Request. |
| DisplayName | Time Off Request |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_timeoffrequest |
| RequiredLevel | None |
| Type | Lookup |
| Targets | msdyn_timeoffrequest |
msdyn_type
| Property | Value |
|---|---|
| Description | Select the time entry type. |
| DisplayName | Type |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_type |
| RequiredLevel | ApplicationRequired |
| Type | Picklist |
| DefaultFormValue | 192350000 |
| GlobalChoiceName | msdyn_timeentrytype |
msdyn_type Choices/Options
| Value | Label |
|---|---|
| 192350000 | Work |
| 192350001 | Absence |
| 192350002 | Vacation |
| 192354320 | Overtime |
| 192355000 | On Break |
| 192355001 | Travel |
msdyn_WorkOrder
| Property | Value |
|---|---|
| Description | Unique identifier for Work Orders associated with Time Entry. |
| DisplayName | Work Order |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_workorder |
| RequiredLevel | None |
| Type | Lookup |
| Targets | msdyn_workorder |
OverriddenCreatedOn
| Property | Value |
|---|---|
| Description | Date and time that the record was migrated. |
| DisplayName | Record Created On |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | overriddencreatedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
OwnerId
| Property | Value |
|---|---|
| Description | Owner Id |
| DisplayName | Owner |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Type | Owner |
| Targets | systemuser, team |
OwnerIdType
| Property | Value |
|---|---|
| Description | Owner Id Type |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
processid
| Property | Value |
|---|---|
| Description | Contains the id of the process associated with the entity. |
| DisplayName | Process Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | processid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
stageid
| Property | Value |
|---|---|
| Description | Contains the id of the stage where the entity is located. |
| DisplayName | (Deprecated) Stage Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | stageid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
statecode
| Property | Value |
|---|---|
| Description | Status of the Time Entry |
| DisplayName | Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
| DefaultFormValue | |
| GlobalChoiceName | msdyn_timeentry_statecode |
statecode Choices/Options
| Value | Details |
|---|---|
| 0 | Label: Active DefaultStatus: 1 InvariantName: Active |
| 1 | Label: Inactive DefaultStatus: 2 InvariantName: Inactive |
statuscode
| Property | Value |
|---|---|
| Description | Reason for the status of the Time Entry |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
| DefaultFormValue | |
| GlobalChoiceName | msdyn_timeentry_statuscode |
statuscode Choices/Options
| Value | Details |
|---|---|
| 1 | Label: Active State:0 TransitionData: None |
| 2 | Label: Inactive State:1 TransitionData: None |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
traversedpath
| Property | Value |
|---|---|
| Description | A comma separated list of string values representing the unique identifiers of stages in a Business Process Flow Instance in the order that they occur. |
| DisplayName | (Deprecated) Traversed Path |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | traversedpath |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1250 |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- VersionNumber
CreatedBy
| Property | Value |
|---|---|
| Description | Unique identifier of the user who created the 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 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 record. |
| 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 modified the 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 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 modified the record. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
OwnerIdName
| Property | Value |
|---|---|
| Description | Name of the owner |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
OwnerIdYomiName
| Property | Value |
|---|---|
| Description | Yomi name of the owner |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier for the business unit that owns the record |
| DisplayName | Owning Business Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Type | Lookup |
| Targets | businessunit |
OwningTeam
| Property | Value |
|---|---|
| Description | Unique identifier for the team that owns the record. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Type | Lookup |
| Targets | team |
OwningUser
| Property | Value |
|---|---|
| Description | Unique identifier for the user that owns the record. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
VersionNumber
| Property | Value |
|---|---|
| Description | Version Number |
| DisplayName | Version Number |
| 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.
- msdyn_bookableresource_msdyn_timeentry_bookableresource
- msdyn_bookableresourcebooking_msdyn_timeentry_BookableResourceBooking
- msdyn_bookingstatus_msdyn_timeentry_BookingStatus
- msdyn_msdyn_timeentrysetting_msdyn_timeentry
- msdyn_msdyn_timeoffrequest_msdyn_timeentry
- msdyn_msdyn_workorder_msdyn_timeentry_WorkOrder
msdyn_bookableresource_msdyn_timeentry_bookableresource
One-To-Many Relationship: bookableresource msdyn_bookableresource_msdyn_timeentry_bookableresource
| Property | Value |
|---|---|
| ReferencedEntity | bookableresource |
| ReferencedAttribute | bookableresourceid |
| ReferencingAttribute | msdyn_bookableresource |
| ReferencingEntityNavigationPropertyName | msdyn_bookableresource |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
msdyn_bookableresourcebooking_msdyn_timeentry_BookableResourceBooking
One-To-Many Relationship: bookableresourcebooking msdyn_bookableresourcebooking_msdyn_timeentry_BookableResourceBooking
| Property | Value |
|---|---|
| ReferencedEntity | bookableresourcebooking |
| ReferencedAttribute | bookableresourcebookingid |
| ReferencingAttribute | msdyn_bookableresourcebooking |
| ReferencingEntityNavigationPropertyName | msdyn_BookableResourceBooking |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
msdyn_bookingstatus_msdyn_timeentry_BookingStatus
One-To-Many Relationship: bookingstatus msdyn_bookingstatus_msdyn_timeentry_BookingStatus
| Property | Value |
|---|---|
| ReferencedEntity | bookingstatus |
| ReferencedAttribute | bookingstatusid |
| ReferencingAttribute | msdyn_bookingstatus |
| ReferencingEntityNavigationPropertyName | msdyn_BookingStatus |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
msdyn_msdyn_timeentrysetting_msdyn_timeentry
One-To-Many Relationship: msdyn_timeentrysetting msdyn_msdyn_timeentrysetting_msdyn_timeentry
| Property | Value |
|---|---|
| ReferencedEntity | msdyn_timeentrysetting |
| ReferencedAttribute | msdyn_timeentrysettingid |
| ReferencingAttribute | msdyn_timeentrysettingid |
| ReferencingEntityNavigationPropertyName | msdyn_timeentrysettingId |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
msdyn_msdyn_timeoffrequest_msdyn_timeentry
One-To-Many Relationship: msdyn_timeoffrequest msdyn_msdyn_timeoffrequest_msdyn_timeentry
| Property | Value |
|---|---|
| ReferencedEntity | msdyn_timeoffrequest |
| ReferencedAttribute | msdyn_timeoffrequestid |
| ReferencingAttribute | msdyn_timeoffrequest |
| ReferencingEntityNavigationPropertyName | msdyn_timeoffrequest |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
msdyn_msdyn_workorder_msdyn_timeentry_WorkOrder
One-To-Many Relationship: msdyn_workorder msdyn_msdyn_workorder_msdyn_timeentry_WorkOrder
| Property | Value |
|---|---|
| ReferencedEntity | msdyn_workorder |
| ReferencedAttribute | msdyn_workorderid |
| ReferencingAttribute | msdyn_workorder |
| ReferencingEntityNavigationPropertyName | msdyn_WorkOrder |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
See also
Dataverse table/entity reference
Dataverse Web API Reference