SSIS Components for QuickBooks Online

Build 24.0.9060

CreditCardPayments

Query QuickBooks Credit Card Payments.

View Specific Information

Select

This view will retrieve all the credit card payments from the user's account.

SELECT * FROM CreditCardPayments WHERE Id = '1234'

SELECT * FROM CreditCardPayments WHERE TxnDate > '2020-01-01'

Columns

Name Type References Description
Id [KEY] String The Id of the credit card payment.
SyncToken String 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 Time the entity was created in the source domain.
MetaData_LastUpdatedTime Datetime Time the entity was last updated in the source domain.
TxnDate Date The date entered by the user when this transaction occurred.
CurrencyRef String The currency entered by the user when this transaction occurred.
ExchangeRate Decimal The exchange rate when this transaction occurred.
CreditCardAccountRef String Identifies the credit card account to which funds are transfered.
BankAccountRef String Identifies the bank account from which funds are transfered.
Amount Decimal Indicates the total amount of the transaction.

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