Letter
This is a table representing the Letter entities in Dynamics CRM.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier of the letter activity. |
| ActivityId | String | False |
Unique identifier of the letter activity. |
| ActivityTypeCode | String | True |
Type of activity. |
| ActualDurationMinutes | Integer | False |
Actual duration of the letter activity in minutes. |
| ActualEnd | Datetime | False |
Actual end time of the letter activity. |
| ActualStart | Datetime | False |
Actual start time of the letter activity. |
| Address | String | False |
Address for the letter. |
| bcc_Ids | String | False |
Blind carbon copy (BCC) recipient of the letter. |
| bcc_LogicalNames | String | False | |
| bcc_Names | String | False | |
| Category | String | False |
Category of the letter. |
| cc_Ids | String | False |
Carbon copy (CC) recipient of the letter. |
| cc_LogicalNames | String | False | |
| cc_Names | String | False | |
| CreatedBy_Id | String | True |
Unique identifier of the user who created the letter activity. |
| CreatedBy_LogicalName | String | True | |
| CreatedBy_Name | String | True | |
| CreatedOn | Datetime | True |
Date and time when the letter activity was created. |
| CreatedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who created the letter. |
| CreatedOnBehalfBy_LogicalName | String | True | |
| CreatedOnBehalfBy_Name | String | True | |
| Description | String | False |
Description of the letter activity. |
| DirectionCode | Boolean | False |
Direction code for the letter: incoming or outgoing. |
| ExchangeRate | Double | True |
Exchange rate for the currency associated with the letter with respect to the base currency. |
| from_Ids | String | False |
Who the letter is from. |
| from_LogicalNames | String | False | |
| from_Names | String | False | |
| ImportSequenceNumber | Integer | False |
Unique identifier of the data import or data migration that created this record. |
| IsBilled | Boolean | False |
Information regarding whether the letter 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 |
Indication of whether the letter activity was created by a workflow rule. |
| ModifiedBy_Id | String | True |
Unique identifier of the user who last modified the letter activity. |
| ModifiedBy_LogicalName | String | True | |
| ModifiedBy_Name | String | True | |
| ModifiedOn | Datetime | True |
Date and time when the letter activity was last modified. |
| ModifiedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who last modified the letter. |
| 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 letter activity. |
| OwnerId_LogicalName | String | False | |
| OwnerId_Name | String | False | |
| OwningBusinessUnit_Id | String | True |
Unique identifier of the business unit that owns the letter activity. |
| OwningBusinessUnit_LogicalName | String | True | |
| OwningBusinessUnit_Name | String | True | |
| OwningTeam_Id | String | True |
Unique identifier of the team that owns the letter activity. |
| OwningTeam_LogicalName | String | True | |
| OwningTeam_Name | String | True | |
| OwningUser_Id | String | True |
Unique identifier of the user that owns the letter activity. |
| OwningUser_LogicalName | String | True | |
| OwningUser_Name | String | True | |
| PriorityCode | String | False |
Priority code of the letter. |
| RegardingObjectId_Id | String | False |
Unique identifier of the object with which the letter activity is associated. |
| RegardingObjectId_LogicalName | String | False | |
| RegardingObjectId_Name | String | False | |
| ScheduledDurationMinutes | Integer | True |
Scheduled duration of the letter activity, specified in minutes. |
| ScheduledEnd | Datetime | False |
Scheduled end time of the letter activity. |
| ScheduledStart | Datetime | False |
Scheduled start time of the letter activity. |
| ServiceId_Id | String | False |
Unique identifier for an associated service. |
| ServiceId_LogicalName | String | False | |
| ServiceId_Name | String | False | |
| StateCode | String | True |
Status of the letter activity. |
| StatusCode | String | False |
Reason for the status of the letter activity. |
| Subcategory | String | False |
Subcategory of the letter activity. |
| Subject | String | False |
Subject associated with the letter activity. |
| TimeZoneRuleVersionNumber | Integer | False |
For internal use only. |
| to_Ids | String | False |
Who the letter is sent to. |
| to_LogicalNames | String | False | |
| to_Names | String | False | |
| TransactionCurrencyId_Id | String | False |
Unique identifier of the currency associated with the letter. |
| TransactionCurrencyId_LogicalName | String | False | |
| TransactionCurrencyId_Name | String | False | |
| UTCConversionTimeZoneCode | Integer | False |
Time zone code that was in use when the record was created. |