ServiceAppointment
This is a table representing the ServiceAppointment entities in Dynamics CRM.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier of the service activity. |
| ActivityId | String | False |
Unique identifier of the service activity. |
| ActivityTypeCode | String | True |
Type of activity. |
| ActualDurationMinutes | Integer | False |
Actual duration of the service activity in minutes. |
| ActualEnd | Datetime | False |
Actual end time of the service activity. |
| ActualStart | Datetime | False |
Actual start time of the service activity. |
| Category | String | False |
Category of the service activity. |
| CreatedBy_Id | String | True |
Unique identifier of the user who created the service activity. |
| CreatedBy_LogicalName | String | True | |
| CreatedBy_Name | String | True | |
| CreatedOn | Datetime | True |
Date and time when the service activity was created. |
| CreatedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who created the serviceappointment. |
| CreatedOnBehalfBy_LogicalName | String | True | |
| CreatedOnBehalfBy_Name | String | True | |
| Customers_Ids | String | False |
Customers for whom the service activity is performed. |
| Customers_LogicalNames | String | False | |
| Customers_Names | String | False | |
| Description | String | False |
Description of the service activity. |
| ExchangeRate | Double | True |
Exchange rate for the currency associated with the serviceappointment with respect to the base currency. |
| ImportSequenceNumber | Integer | False |
Unique identifier of the data import or data migration that created this record. |
| IsAllDayEvent | Boolean | False |
Information which specifies if the service activity is an all day event. |
| IsBilled | Boolean | False |
Information which specifies whether the service activity was billed as part of resolving a case. |
| IsRegularActivity | Boolean | True |
Information regarding whether the activity is a regular activity type or event type. |
| IsWorkflowCreated | Boolean | False |
Information which specifies if the service activity was created from a workflow rule. |
| Location | String | False |
Location where the service activity is to occur. |
| ModifiedBy_Id | String | True |
Unique identifier of the user who last modified the service activity. |
| ModifiedBy_LogicalName | String | True | |
| ModifiedBy_Name | String | True | |
| ModifiedOn | Datetime | True |
Date and time when the service activity was last modified. |
| ModifiedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who last modified the serviceappointment. |
| ModifiedOnBehalfBy_LogicalName | String | True | |
| ModifiedOnBehalfBy_Name | String | True | |
| OverriddenCreatedOn | Datetime | False |
Date and time that the record was migrated. |
| OwnerId_Id | String | False |
Unique identifier of the user or team who owns the service activity. |
| OwnerId_LogicalName | String | False | |
| OwnerId_Name | String | False | |
| OwningBusinessUnit_Id | String | True |
Unique identifier of the business unit that owns the service activity. |
| OwningBusinessUnit_LogicalName | String | True | |
| OwningBusinessUnit_Name | String | True | |
| OwningTeam_Id | String | True |
Unique identifier of the team that owns the service activity. |
| OwningTeam_LogicalName | String | True | |
| OwningTeam_Name | String | True | |
| OwningUser_Id | String | True |
Unique identifier of the user that owns the service activity. |
| OwningUser_LogicalName | String | True | |
| OwningUser_Name | String | True | |
| PriorityCode | String | False |
Priority of the service activity. |
| RegardingObjectId_Id | String | False |
Unique identifier of the object with which the service activity is associated. |
| RegardingObjectId_LogicalName | String | False | |
| RegardingObjectId_Name | String | False | |
| Resources_Ids | String | False |
Users or facility/equipment that are required for the service activity. |
| Resources_LogicalNames | String | False | |
| Resources_Names | String | False | |
| ScheduledDurationMinutes | Integer | False |
Scheduled duration of the service activity, specified in minutes. |
| ScheduledEnd | Datetime | False |
Scheduled end time of the service activity. |
| ScheduledStart | Datetime | False |
Scheduled start time of the service activity. |
| ServiceId_Id | String | False |
Unique identifier for an associated service. |
| ServiceId_LogicalName | String | False | |
| ServiceId_Name | String | False | |
| SiteId_Id | String | False |
Site where the service activity is located. |
| SiteId_LogicalName | String | False | |
| SiteId_Name | String | False | |
| StateCode | String | True |
Status of the service activity. |
| StatusCode | String | False |
Reason for the status of the service activity. |
| Subcategory | String | False |
Sub-category of the activity. |
| Subject | String | False |
Subject associated with the service activity. |
| TimeZoneRuleVersionNumber | Integer | False |
For internal use only. |
| TransactionCurrencyId_Id | String | False |
Unique identifier of the currency associated with the serviceappointment. |
| TransactionCurrencyId_LogicalName | String | False | |
| TransactionCurrencyId_Name | String | False | |
| UTCConversionTimeZoneCode | Integer | False |
Time zone code that was in use when the record was created. |