Power BI Connector for QuickBooks

Build 23.0.8839

CreditMemoLinkedTransactions

Query QuickBooks Credit Memo Linked Transactions.

Table Specific Information

Linked transactions are transactions that have been associated with the CreditMemo specified by the CreditMemoId column.

Columns

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

CreditMemos.ID

The credit memo identifier.
ReferenceNumber String The transaction reference number.
TxnNumber Integer The transaction number. An identifying number for the transaction, different from the QuickBooks-generated Id.
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.
CustomerId String

Customers.ID

The id of the customer on the credit memo.
CustomerName String The name of the customer on the credit memo.
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 credit memo and linked transaction.
TimeModified Datetime When the credit memo was last modified.
TimeCreated Datetime When the credit memo was created.

Pseudo-Columns

Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ItemPriceLevel String Item price level name. QuickBooks will not return the price level.

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