EstimateLinkedTransactions
Queries transactions linked to specific QuickBooks Estimates, such as associated invoices or adjustments.
Table Specific Information
Linked transactions are transactions that have been associated with the Estimate specified by the EstimateId column.
Columns
| Name | Type | References | Description |
| ID [KEY] | String | A unique identifier representing the combination of the estimate and linked transaction, formatted as EstimateId|ItemLineId. | |
| EstimateId | String |
Estimates.ID | The unique identifier of the estimate associated with this transaction. |
| ReferenceNumber | String | A user-defined reference number for the estimate. | |
| TxnNumber | Integer | A Quickbooks assigned transaction number for this estimate, distinct from its internal ID. | |
| CustomerName | String | The name of the customer associated with the estimate and linked transaction. | |
| CustomerId | String |
Customers.ID | The unique ID of the customer associated with the estimate and linked transaction. |
| Date | Date | The date when the estimate was created or last modified. | |
| TransactionId | String | The unique identifier of the transaction linked to this estimate. | |
| TransactionAmount | Decimal | The monetary amount associated with the linked transaction. | |
| TransactionDate | Date | The date of the linked transaction. | |
| TransactionReferenceNumber | String | A user-defined reference number for the linked transaction. | |
| TransactionType | String | The specific type of the linked transaction, such as Invoice, Sales Order, or Payment. | |
| TransactionLinkType | String | Describes the relationship between the estimate and the linked transaction, such as 'applied to' or 'referenced by.' | |
| TimeModified | Datetime | The date and time when the linked transaction was last modified. | |
| TimeCreated | Datetime | The date and time when the linked transaction was initially created. |
Pseudo-Columns
Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| ItemPriceLevel | String | The price level applied to items in this estimate or linked transaction. Note: QuickBooks does not return this value. |