Power BI Connector for QuickBooks

Build 23.0.8839

InvoiceLinkedTransactions

Query QuickBooks Invoice Linked Transactions.

Table Specific Information

Linked transactions are transactions that have been associated with the Invoice specified by the InvoiceId column.

Columns

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

Invoices.ID

The invoice identifier.
ReferenceNumber String The transaction reference number.
TxnNumber Integer The transaction number. An identifying number for the transaction, different from the QuickBooks-generated Id.
CustomerName String The name of the customer on the invoice. Either CustomerName or CustomerId must have a value when inserting.
CustomerId String

Customers.ID

The Id of the customer on the invoice. Alternatively give this field a value when inserting instead of CustomerName.
Account String A reference to the accounts-receivable account where the money received from this transaction will be deposited.
AccountId String

Accounts.ID

A reference to the accounts-receivable account where the money received from this transaction will be deposited.
Date Date The date of the transaction. If it is set in the WHERE clause of a SELECT query, the pseudo columns StartDate and EndDate are overwritten with the value.
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 invoice and linked transaction.
TimeModified Datetime When the invoice was last modified.
TimeCreated Datetime When the invoice was created.

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