ODBC Driver for QuickBooks

Build 24.0.9175

Transfers

Manages QuickBooks Transfers, supporting creation, updates, and queries for tracking movement of funds between accounts. Requires QBXML Version 12.0 or higher.

Columns

Name Type ReadOnly References ColumnSize Description
ID [KEY] String True 255

The unique identifier for the transfer transaction.

TxnNumber String True 21

A user-defined transaction number for identifying the transfer. This is different from the Quickbooks generated ID.

TxnDate Date False

The date when the transfer occurred, formatted as YYYY-MM-DD.

TransferFromAccountRef_ListID String False

Accounts.ID

255

The unique identifier (ListID) of the account from which the funds are transferred.

TransferFromAccountRef_FullName String False 1000

The full name of the account from which the funds are transferred.

FromAccountBalance Double True

The balance of the source account from which the funds are being transferred.

TransferToAccountRef_ListID String False

Accounts.ID

255

The unique identifier (ListID) of the account to which the funds are transferred.

TransferToAccountRef_FullName String False 1000

The full name of the account to which the funds are transferred.

ToAccountBalance Double True

The balance of the destination account to which the funds are being transferred.

ClassRef_ListID String False

Class.ID

255

The unique identifier (ListID) of the class assigned to this transfer transaction.

ClassRef_FullName String False 1000

The full name of the class assigned to this transfer transaction.

Amount Decimal False

The total amount of money being transferred in this transaction.

Memo String False 5000

Optional notes or comments associated with this transfer transaction.

TimeCreated Datetime True

The date and time when this transfer transaction was created, formatted as YYYY-MM-DD HH:MM:SS.

TimeModified Datetime True

The date and time when this transfer transaction was last modified, formatted as YYYY-MM-DD HH:MM:SS.

EditSequence String True 16

A unique identifier used for version control to ensure the transaction data is current.

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