ODBC Driver for Bullhorn CRM

Build 25.0.9539

ClientContactFileAttachment

Captures files (for example, contracts, forms, or communication documents) that are attached to client contact records. This table supports documentation workflows by enabling users to store, retrieve, and audit contact-related attachments.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) for the client contact file attachment. This field enables Bullhorn CRM to distinguish this attachment from other stored files and supports accurate retrieval across contact records.

ClientContactId Int False

Specifies the Id of the client contact who is associated with the attachment. This field links the file to the correct individual and ensures that documents appear in the appropriate Bullhorn CRM profile.

ContentSubType String False

Specifies the subcategory of the file's content type. This field helps Bullhorn CRM classify files more precisely for filtering, storage rules, and content-based workflows.

ContentType String False

Specifies the content type or general format of the attached file. This field assists Bullhorn CRM in determining how the file should be processed, displayed, or validated.

DateAdded Datetime False

Captures the date and time when the file attachment is added. This field supports audit histories and enables users to identify the most recent or relevant documents quickly.

Description String False

Captures a descriptive summary of the file attachment. This field helps users understand the attachment's purpose, contents, or relevance without needing to open the file.

Directory String False

Specifies the storage directory or structural location of the attachment. This field supports file organization and assists Bullhorn CRM in mapping storage paths.

Distribution String False

Captures details that describe how the file is distributed or shared. This field helps Bullhorn CRM users understand sharing scope, routing, or document workflows.

ExternalID String False

Captures the external Id that is associated with the attachment in other connected systems. This field supports cross-platform synchronization and traceability during integrations.

FileExtension String False

Specifies the file extension of the attachment. This field helps Bullhorn CRM determine file type behavior, validation rules, and applicable handling actions.

FileOwnerId Int False

Specifies the Id of the user who owns or uploaded the file. This field supports record accountability, permission control, and ownership tracking within Bullhorn CRM.

FileSize Int False

Captures the size of the file attachment in bytes. This field supports storage management, bandwidth considerations, and troubleshooting efforts for upload issues.

FileType String False

Specifies the file classification or predefined type category. This field assists Bullhorn CRM in organizing attachments and applying file-type-specific rules or workflows.

IsCopied Bool False

Returns a value of 'true' when the attachment is identified as a copied file. It returns a value of 'false' when the file originates from its source location, helping Bullhorn CRM track duplication behavior.

IsEncrypted Bool False

Returns a value of 'true' when the attachment is encrypted. It returns a value of 'false' when the file is stored in an unencrypted format, supporting security and compliance needs.

IsExternal Bool False

Returns a value of 'true' when the attachment originates from an external source system. It returns a value of 'false' when the file is uploaded internally, supporting import tracing and data lineage within Bullhorn CRM.

IsOpen Bool False

Returns a value of 'true' when the attachment is currently open or being viewed. It returns a value of 'false' when it is not open, supporting activity monitoring and document usage tracking.

IsPrivate Bool False

Returns a value of 'true' when access to the attachment is restricted for privacy. It returns a value of 'false' when the file is available to authorized users, supporting confidentiality workflows.

IsSendOut Bool False

Returns a value of 'true' when the attachment is designated for sending out, such as part of a distribution or communication workflow. It returns a value of 'false' when the file is not used for outbound processes within Bullhorn CRM.

Name String False

Specifies the display name of the attached file. This field helps users recognize the file's purpose and improves visibility within the file listing.

Type String False

Specifies the attachment's type classification. This field supports organizational rules and may influence how Bullhorn CRM processes or categorizes the file.

Uuid String False

Captures the universally unique Id that is associated with the file attachment. This field ensures system-level uniqueness and supports integrations that require globally unique references.

IsDeleted Bool False

Returns a value of 'true' when the attachment is marked as deleted. It returns a value of 'false' when the file remains active and available for use within Bullhorn CRM.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539