JDBC Driver for QuickBooks

Build 22.0.8462

StatementChargeLinkedTransactions

Query QuickBooks Statement Charge Linked Transactions.

Table Specific Information

Linked transactions are transactions that have been associated with the StatementCharge specified by the StatementChargeId column.

Columns

Name Type References Description
ID [KEY] String The unique identifier in the format StatementChargeId|TransactionLineId.
StatementChargeId String

StatementCharges.ID

The item identifier.
ReferenceNumber String Transaction reference number.
TxnNumber Integer The transaction number. An identifying number for the transaction, different from the QuickBooks-generated Id.
CustomerName String Customer name this transaction is recorded under.
CustomerId String

Customers.ID

Customer Id this transaction is recorded under.
Date Date Transaction date.
TransactionId String The Id of the linked transaction.
TransactionAmount Decimal The amount of the linked transaction.
TransactionDate Date The date of the linked transaction.
TransactionReferenceNumber String The reference number of the linked transaction.
TransactionType String The type of linked transaction.
TransactionLinkType String The link type between the statement charge and linked transaction.
TimeModified Datetime When the statement charge was last modified.
TimeCreated Datetime When the statement charge was created.

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