JDBC Driver for QuickBooks Online

Build 22.0.8675

AttachableRefs

Attachables

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
EntityRefId [KEY] String True True True

The ID of the Entity Ref of the attachable.

AttachableId [KEY] String True

Attachables.ID

True True

The Id of the attachable.

SyncToken String True False False

The version number of the entity. This must be specified when executing an update or delete.

MetaData_CreateTime Datetime True True True

The time the record was created.

MetaData_LastUpdatedTime Datetime True True True

The time the record was last updated.

FileName String False True True

FileName of the attachment.

Size Integer False True True

Size of the attachment.

ContentType String False True True

ContentType of the attachment.

Category String False True True

Category of the attachment.

Latitude Double False True True

Latitude from where the attachment was requested.

Longitude Double False True True

Longitude from where the attachment was requested.

Note String False True True

Note either related to the attachment or as a standalone note.

PlaceName String False True True

PlaceName from where the attachment was requested.

Tag String False True True

Tag name for the requested attachment.

AttachableRef_EntityRef String False True False

Value

AttachableRef_EntityRef_type String False True False

Type

AttachableRef_EntityRef_name String False False False

Type name

AttachableRef_IncludeOnSend Boolean False True False

On sending email to customer (most likely for txns), this field indicates whether or not the attachment is to be sent together with the email.

AttachableRef_LineInfo String False True True

If the entity is a transaction, user can also specify a transaction detail line to reference.

FileAccessUri String False True True

FullPath FileAccess URI of the attachment.

TempDownloadUri String False True True

TempDownload URI which can be directly downloaded by clients.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8675