Attachment table/entity reference (Microsoft Dataverse)
Attachment for an email activity.
Messages
The following table lists the messages for the Attachment 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 |
|---|---|---|
AssociateEvent: True |
Associate records | Associate records |
DisassociateEvent: True |
Disassociate records | Disassociate records |
Properties
The following table lists selected properties for the Attachment table.
| Property | Value |
|---|---|
| DisplayName | Attachment |
| DisplayCollectionName | Attachments |
| SchemaName | Attachment |
| CollectionSchemaName | Attachments |
| EntitySetName | attachments |
| LogicalName | attachment |
| LogicalCollectionName | attachments |
| PrimaryIdAttribute | attachmentid |
| PrimaryNameAttribute | filename |
| TableType | Standard |
| OwnershipType | None |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
AttachmentId
| Property | Value |
|---|---|
| Description | Unique identifier of the attachment. |
| DisplayName | Attachment |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | attachmentid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
Body
| Property | Value |
|---|---|
| Description | Contents of the attachment. |
| DisplayName | Body |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | body |
| RequiredLevel | None |
| Type | String |
| Format | TextArea |
| FormatName | TextArea |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1073741823 |
FileName
| Property | Value |
|---|---|
| Description | File name of the attachment. |
| DisplayName | File Name |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | filename |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 255 |
MimeType
| Property | Value |
|---|---|
| Description | MIME type of the attachment. |
| DisplayName | MIME Type |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | mimetype |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 256 |
Subject
| Property | Value |
|---|---|
| Description | Subject associated with the attachment. |
| DisplayName | Subject |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | subject |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 2000 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
FilePointer
| Property | Value |
|---|---|
| Description | File pointer of the attachment. |
| DisplayName | File Pointer |
| IsValidForForm | False |
| IsValidForRead | False |
| LogicalName | filepointer |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 255 |
FileSize
| Property | Value |
|---|---|
| Description | File size of the attachment. |
| DisplayName | File Size (Bytes) |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | filesize |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 1000000000 |
| MinValue | 0 |
Prefix
| Property | Value |
|---|---|
| Description | Prefix of the file pointer in blob storage. |
| DisplayName | Prefix |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | prefix |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 10 |
StoragePointer
| Property | Value |
|---|---|
| Description | Storage pointer. |
| DisplayName | Storage Pointer |
| IsValidForForm | False |
| IsValidForRead | False |
| LogicalName | storagepointer |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 10 |
VersionNumber
| Property | Value |
|---|---|
| Description | Version number of the attachment. |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| RequiredLevel | None |
| Type | BigInt |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
attachment_activity_mime_attachments
Many-To-One Relationship: activitymimeattachment attachment_activity_mime_attachments
| Property | Value |
|---|---|
| ReferencingEntity | activitymimeattachment |
| ReferencingAttribute | attachmentid |
| ReferencedEntityNavigationPropertyName | attachment_activity_mime_attachments |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Attachment_SyncErrors
Many-To-One Relationship: syncerror Attachment_SyncErrors
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Attachment_SyncErrors |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
See also
Dataverse table/entity reference
Dataverse Web API Reference
attachment