DeletedTransactions
Queries transactions deleted in QuickBooks, offering insight into adjustments or corrections made in the system.
Table Specific Information
Select
The QuickBooks connector requires filtering on TxnDelType in order to perform the query, for example:
SELECT * FROM DeletedTransactions WHERE TxnDelType='Estimate'
Columns
| Name | Type | References | Description |
| TxnID [KEY] | String | The unique identifier of the deleted transaction. | |
| TxnDelType | String | Specifies the type of transaction that was deleted. Valid values include ARRefundCreditCard, Bill, BillPaymentCheck, BillPaymentCreditCard, BuildAssembly, Charge, Check, CreditCardCharge, CreditCardCredit, CreditMemo, Deposit, Estimate, InventoryAdjustment, Invoice, ItemReceipt, JournalEntry, PurchaseOrder, ReceivePayment, SalesOrder, SalesReceipt, SalesTaxPaymentCheck, TimeTracking, TransferInventory, VehicleMileage, and VendorCredit. | |
| RefNumber | String | The reference number associated with the deleted transaction. | |
| TimeCreated | Datetime | The date and time when the transaction was originally created in the system. | |
| TimeDeleted | Datetime | The date and time when the transaction was deleted from the system. |
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 | |
| TimeModified | String | Allows searching for deleted transactions based on the last modified date. |