Attachables
Stores the actual files or metadata of attachments that are uploaded to QuickBooks Online, such as receipts, contracts, or images that support financial transactions or customer/vendor records.
Table Specific Information
Select
All filterable columns support the following operators:
- =
- !=
- >=
- <=
- >
- <
- IN
- LIKE
- CONTAINS
The driver processes other filters client-side within the driver.
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| Id [KEY] | String | True | True | True |
The unique identifier (Id) that is assigned to the attachable record. This Id is used to reference the specific attachment in QuickBooks Online transactions and API operations. | |
| SyncToken | String | True | False | False |
The version number that is assigned to the attachable entity. This value must be provided when you perform update or delete operations to ensure data consistency and prevent concurrency conflicts. | |
| MetaData_CreateTime | Datetime | True | True | True |
The date and time when the attachable record was originally created in QuickBooks Online. This timestamp helps track the origin of the attachment in audit or integration scenarios. | |
| MetaData_LastUpdatedTime | Datetime | True | True | True |
The date and time when the attachable record was last modified in QuickBooks Online. This timestamp is useful for synchronization, auditing, and identifying the most recent version of the attachment. | |
| FileName | String | False | True | True |
The name of the attached file, including its original filename as provided by the user or source system. | |
| Size | Integer | False | True | True |
The size of the attached file in bytes. This information allows applications and users to verify file size before download or processing. | |
| ContentType | String | False | True | True |
The content type of the attached file (for example, image/jpeg or application/pdf). This value informs QuickBooks Online and client applications how to handle the attachment. | |
| Category | String | False | True | True |
The category that is assigned to the attachment, indicating its functional type or purpose (for example, receipt, invoice backup, or supporting document). | |
| Latitude | Double | False | True | True |
The latitude coordinate that indicates where the attachment was uploaded or associated, if location information is available. Useful for geotagging or location-based reporting. | |
| Longitude | Double | False | True | True |
The longitude coordinate indicating where the attachment was uploaded or associated, if location information is available. Useful for geotagging or location-based reporting. | |
| Note | String | False | True | True |
A free-form note that is provided by the user. This note can describe the context of the attachment or stand alone as a note record that is linked to the company file. | |
| PlaceName | String | False | True | True |
The name of the place where the attachment was uploaded or associated, if provided. This name can correspond to a business location or event name. | |
| Tag | String | False | True | True |
A tag or label that is applied to the attachment to facilitate organization, filtering, or grouping of related files within QuickBooks Online. | |
| AttachableRefAggregate | String | False | False | False |
The aggregate reference that specifies the QuickBooks transaction or entity (for example, Invoice, Bill, or Customer) to which this attachable file is linked. This reference establishes the attachment's relationship within the company file. | |
| FileAccessUri | String | False | False | False |
The full path Uniform Resource Identifier (URI) that allows secure access to the attachment file in QuickBooks Online. Applications use this URI to retrieve the attachment programmatically. | |
| TempDownloadUri | String | False | False | False |
The temporary download URI that allows clients to directly download the attachment file within a limited time window. Typically, this URI is used for one-time or short-lived download operations. |