EstimateLinkedTransactions
Query QuickBooks Estimate Linked transactions.
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 | The unique identifier in the format EstimateId|ItemLineId. | |
| EstimateId | String |
Estimates.ID | The estimate identifier. |
| ReferenceNumber | String | Transaction reference number. | |
| TxnNumber | Integer | The transaction number. An identifying number for the transaction, different from the QuickBooks-generated Id. | |
| CustomerName | String | Customer name this transaction is recorded under. | |
| CustomerId | String |
Customers.ID | Customer Id this transaction is recorded under. |
| Date | Date | Transaction date. | |
| 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 estimate and linked transaction. | |
| TimeModified | Datetime | When the credit memo was last modified. | |
| TimeCreated | Datetime | When the credit memo was 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 | Item price level name. QuickBooks will not return the price level. |