OpportunityFileAttachment
Captures files that are attached to opportunity records, including proposals, contracts, or supporting documents. This table supports sales documentation workflows by enabling users to store and access materials that support opportunity advancement.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | False |
Represents the identifier (Id) that uniquely identifies the attachment record that is stored in the OpportunityFileAttachment table. This value links the attachment record to related Opportunity data. |
| ContentSubType | String | False |
Specifies the content subtype that is associated with the attachment record in the OpportunityFileAttachment table. This value helps systems determine the correct application or viewer for rendering the attached file. |
| ContentType | String | False |
Indicates the high-level content type that describes the attached file for the attachment record in the OpportunityFileAttachment table. This value assists downstream modules in applying the correct processing rules. |
| DateAdded | Datetime | False |
Captures the date and time when the attachment record is added to the OpportunityFileAttachment table. This timestamp supports audit trails, ordering, and lifecycle analysis. |
| Description | String | False |
Provides a human-readable summary that describes the attachment record in the OpportunityFileAttachment table. This text is often used to help users identify the purpose or contents of the file. |
| Directory | String | False |
Specifies the directory path that is associated with the attachment record in the OpportunityFileAttachment table. This path indicates where the physical file is stored within the organization's storage system. |
| Distribution | String | False |
Specifies the distribution setting that is applied to the attachment record that is stored in the OpportunityFileAttachment table. This value controls how the file can be shared across modules and integrations. |
| ExternalID | String | False |
Stores an external system Id that is associated with the attachment record in the OpportunityFileAttachment table. This value allows external platforms to correlate their file metadata with Bullhorn CRM records. |
| FileExtension | String | False |
Indicates the file extension that is associated with the attachment record in the OpportunityFileAttachment table. This extension helps systems determine appropriate handling and rendering of the file. |
| FileOwnerId | Int | False |
Identifies the user Id that is designated as the owner of the attachment record in the OpportunityFileAttachment table. This value is used for permission checks, auditing, and workflow routing. |
| FileSize | Int | False |
Captures the size of the attached file that is represented by the attachment record in the OpportunityFileAttachment table. This information is used to validate transfer limits and optimize storage. |
| FileType | String | False |
Indicates the specific file type that corresponds to the attachment record in the OpportunityFileAttachment table. This value is used for classification, workflow rules, and filtering. |
| IsCopied | Bool | False |
Returns a value of 'true' when the attachment record that is stored in the OpportunityFileAttachment table represents a file that is copied from another location. It returns a value of 'false' when the attachment record does not represent a copied file. |
| IsEncrypted | Bool | False |
Returns a value of 'true' when the attached file that is represented in the OpportunityFileAttachment table is encrypted. It returns a value of 'false' when the file is stored without encryption. |
| IsExternal | Bool | False |
Returns a value of 'true' when the attachment record in the OpportunityFileAttachment table corresponds to a file that is stored outside the primary document repository. It returns a value of 'false' when the file is stored internally. |
| IsOpen | Bool | False |
Returns a value of 'true' when the attachment record in the OpportunityFileAttachment table is flagged as currently opened or accessed. It returns a value of 'false' when no active viewing state is recorded. |
| IsPrivate | Bool | False |
Returns a value of 'true' when the attachment record that is stored in the OpportunityFileAttachment table is marked as private. It returns a value of 'false' when the record is available for broader visibility. |
| IsSendOut | Bool | False |
Returns a value of 'true' when the attachment record in the OpportunityFileAttachment table is marked for outbound distribution. It returns a value of 'false' when it is not designated for outgoing workflows. |
| Name | String | False |
Specifies the name that is assigned to the attachment record in the OpportunityFileAttachment table. This name is used for display purposes and helps users distinguish among multiple files. |
| Type | String | False |
Indicates the functional classification that is assigned to the attachment record in the OpportunityFileAttachment table. This type influences workflow rules and integration handling. |
| Uuid | String | False |
Stores the universally unique Id that is associated with the attachment record in the OpportunityFileAttachment table. This value ensures consistent identification across distributed systems. |
| IsDeleted | Bool | False |
Returns a value of 'true' when the attachment record that is stored in the OpportunityFileAttachment table is marked as deleted. It returns a value of 'false' when the record remains active in the system. |