Excel Add-In for QuickBooks

Build 21.0.7930

VendorCreditLinkedTransactions

Query QuickBooks Vendor Credit Linked Transactions.

Table Specific Information

Linked transactions are transactions that have been associated with the VendorCredit specified by the VendorCreditId column.

Columns

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

VendorCredits.ID

The Id of the VendorCredit transaction.
VendorName String

Vendors.Name

Vendor for this transaction. Either VendorName or VendorId is required to have a value when inserting.
VendorId String

Vendors.ID

Vendor for this transaction. Either VendorName or VendorId is required to have a value when inserting.
Date Date 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.
TxnNumber Integer The transaction number. An identifying number for the transaction, different from the QuickBooks-generated Id.
ReferenceNumber String Reference number for the transaction.
TransactionId String

Bills.ID

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 vendor credit and linked transaction.
TimeModified Datetime When the vendor credit was last modified.
TimeCreated Datetime When the vendor credit was created.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930