SSIS Components for QuickBooks Online

Build 24.0.9060

Transfers

Create, update, delete, and query QuickBooks Transfers

Columns

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

The Id of the payment.

TxnDate Date False True True

The date entered by the user when this transaction occurred.

PrivateNote String False False False

User entered, organization-private note about the transaction.

FromAccountRef String False

Accounts.Id

False False

The account Id from which the funds were transfered.

FromAccountRef_Name String False

Accounts.Name

False False

The account Name from which the funds were transfered.

ToAccountRef String False

Accounts.Id

False False

The account Id to which the funds were transfered.

ToAccountRef_Name String False

Accounts.Name

False False

The account Name to which the funds were transfered.

Amount Decimal False False False

The total amount of the transaction

CurrencyRef String False False False

The Id of the currency used in the transaction.

CurrencyRef_Name String True False False

The name of the currency used in the transaction.

SyncToken String True False False

Version number of the object. It is used to lock an object for use by one app at a time. As soon as an application modifies an object, its SyncToken is incremented. Attempts to modify an object specifying an older SyncToken fails. Only the latest version of the object is maintained by QuickBooks Online.

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.

TransactionLocationType String False False False

The account location. This field is valid in only the FR editions.

The allowed values are WithinFrance, FranceOverseas, OutsideFranceWithEU, OutsideEU.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060