ODBC Driver for QuickBooks Online

Build 25.0.9434

Transfers

Represents transfers of funds between bank, credit card, or other accounts, recording movement of money within the business.

Columns

Name Type ReadOnly References Filterable Sortable Description
Id [KEY] String True True True

The unique identifier (Id) that is assigned by QuickBooks Online to this transfer transaction. It is used to retrieve or reference the transfer programmatically and is required for updates or deletions.

TxnDate Date False True True

The transaction date that is entered by the user when this transfer occurred. This date determines the accounting period for the transfer.

PrivateNote String False False False

A user-entered, organization-private note about this transfer transaction. This note does not appear on customer-facing or vendor-facing forms by default.

FromAccountRef String False

Accounts.Id

False False

The unique Id of the account from which the funds are transferred. This Id links the transfer to the originating account in QuickBooks Online.

FromAccountRef_Name String False

Accounts.Name

False False

The display name of the account from which the funds are transferred. This name helps users identify the originating account in reports and on forms.

ToAccountRef String False

Accounts.Id

False False

The unique Id of the account to which the funds are transferred. This Id links the transfer to the destination account in QuickBooks Online.

ToAccountRef_Name String False

Accounts.Name

False False

The display name of the account to which the funds are transferred. This name helps users identify the destination account in reports and on forms.

Amount Decimal False False False

The total monetary amount of the funds that are transferred in this transaction. This total represents the amount moved between accounts.

SyncToken String True False False

The version control token for this transfer transaction that is used to prevent conflicting updates. QuickBooks Online increments this sync token each time the transaction is modified, and only the latest sync token is accepted for edits.

MetaData_CreateTime Datetime True True True

The date and time stamp (Coordinated Universal Time) when QuickBooks Online created this transfer-transaction record.

MetaData_LastUpdatedTime Datetime True True True

The date and time stamp (Coordinated Universal Time) when this transfer-transaction record was last modified in QuickBooks Online.

TransactionLocationType String False False False

The account location type that is associated with this transfer transaction. This field is valid only in the FR editions.

使用できる値は次のとおりです。WithinFrance, FranceOverseas, OutsideFranceWithEU, OutsideEU

RecurDataRef String True False False

The unique Id of the reference to the recurring transaction template from which this transfer was created. This field captures which recurring transaction template the transfer originated from.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434