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 | The Id of the VendorCredit transaction. | |
VendorName | String | 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. |