VendorCreditLinkedTransactions
Queries transactions linked to QuickBooks Vendor Credits, such as associated bills or payments.
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 for the linked transaction, formatted as VendorCreditId|ItemLineId to combine the vendor credit ID and the linked item line ID. | |
| VendorCreditId | String | The unique identifier of the VendorCredit transaction associated with the linked transaction. | |
| VendorName | String | The name of the vendor associated with this transaction. Either VendorName or VendorId must be provided when inserting. | |
| VendorId | String |
Vendors.ID | The unique identifier of the vendor associated with this transaction. Either VendorName or VendorId must be provided when inserting. |
| Date | Date | The date of the vendor credit transaction in the format YYYY-MM-DD. Overrides StartDate and EndDate pseudo columns when specified in a WHERE clause. | |
| TxnNumber | Integer | An identifying number for the transaction, distinct from the Quickbooks generated ID. | |
| ReferenceNumber | String | The reference number assigned to this vendor credit transaction. | |
| TransactionId | String |
Bills.ID | The unique identifier of the linked transaction associated with this vendor credit. |
| TransactionAmount | Decimal | The amount involved in the linked transaction. | |
| TransactionDate | Date | The date of the linked transaction in the format YYYY-MM-DD. | |
| TransactionReferenceNumber | String | The reference number assigned to the linked transaction. | |
| TransactionType | String | The type of the linked transaction, such as Bill, Payment, or JournalEntry. | |
| TransactionLinkType | String | Describes the link type between the vendor credit and the linked transaction, indicating the nature of their relationship. | |
| TimeModified | Datetime | The date and time when the vendor credit was last modified, in the format YYYY-MM-DD HH:MM:SS. | |
| TimeCreated | Datetime | The date and time when the vendor credit was created, in the format YYYY-MM-DD HH:MM:SS. |