InvoiceLinkedTransactions
Queries transactions linked to QuickBooks Invoices, such as payments or credits applied.
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 | A unique identifier combining the InvoiceId and ItemLineId, used to reference specific linked transactions associated with an invoice. | |
| InvoiceId | String |
Invoices.ID | The unique identifier of the invoice to which the linked transaction pertains. |
| ReferenceNumber | String | The transaction reference number for identifying the invoice. | |
| TxnNumber | Integer | A unique number assigned to the transaction by QuickBooks, distinct from the InvoiceId. | |
| CustomerName | String | The name of the customer associated with the invoice. Either CustomerName or CustomerId must be provided during insertion. | |
| CustomerId | String |
Customers.ID | The Quickbooks generated identifier for the customer associated with the invoice. Can be used as an alternative to CustomerName for insertion. |
| Account | String | The name of the accounts-receivable account where funds from this invoice are deposited. | |
| AccountId | String |
Accounts.ID | The unique identifier for the accounts-receivable account where funds from this invoice are deposited. |
| Date | Date | The transaction date for the invoice. If specified in a query, it overrides the StartDate and EndDate pseudo-columns. | |
| TransactionId | String | The unique identifier for the transaction linked to the invoice. | |
| TransactionAmount | Decimal | The monetary value of the linked transaction associated with the invoice. | |
| TransactionDate | Date | The date when the linked transaction occurred. | |
| TransactionReferenceNumber | String | The reference number assigned to the linked transaction. | |
| TransactionType | String | The type of transaction linked to the invoice, such as payment or credit memo. | |
| TransactionLinkType | String | Specifies the relationship between the invoice and the linked transaction (for example, payment, credit, or refund). | |
| TimeModified | Datetime | The date and time when the invoice was last modified. | |
| TimeCreated | Datetime | The date and time when the invoice was created. |