InvoiceLinkedTransactions
Query QuickBooks Invoice Linked Transactions.
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 | The unique identifier in the format InvoiceId|ItemLineId. | |
| InvoiceId | String |
Invoices.ID | The invoice identifier. |
| ReferenceNumber | String | The transaction reference number. | |
| TxnNumber | Integer | The transaction number. An identifying number for the transaction, different from the QuickBooks-generated Id. | |
| CustomerName | String | The name of the customer on the invoice. Either CustomerName or CustomerId must have a value when inserting. | |
| CustomerId | String |
Customers.ID | The Id of the customer on the invoice. Alternatively give this field a value when inserting instead of CustomerName. |
| Account | String | A reference to the accounts-receivable account where the money received from this transaction will be deposited. | |
| AccountId | String |
Accounts.ID | A reference to the accounts-receivable account where the money received from this transaction will be deposited. |
| 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. | |
| 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 invoice and linked transaction. | |
| TimeModified | Datetime | When the invoice was last modified. | |
| TimeCreated | Datetime | When the invoice was created. |