DeletedTransactions
Query deleted Transactions.
Table Specific Information
Select
The Reckon Accounts Hosted driver 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. | |
| TxnDelType | String | The transaction type. Valid values are ARRefundCreditCard, Bill, BillPaymentCheck, BillPaymentCreditCard, BuildAssembly, Charge, Check, CreditCardCharge, CreditCardCredit, CreditMemo, Deposit, Estimate, InventoryAdjustment, Invoice, ItemReceipt, JournalEntry, PurchaseOrder, ReceivePayment, SalesOrder, SalesReceipt, SalesTaxPaymentCheck, TimeTracking, TransferInventory, VehicleMileage, VendorCredit
The allowed values are ARRefundCreditCard, Bill, BillPaymentCheck, BillPaymentCreditCard, BuildAssembly, Charge, Check, CreditCardCharge, CreditCardCredit, CreditMemo, Deposit, Estimate, InventoryAdjustment, Invoice, ItemReceipt, JournalEntry, PurchaseOrder, ReceivePayment, SalesOrder, SalesReceipt, SalesTaxPaymentCheck, TimeTracking, TransferInventory, VehicleMileage, VendorCredit. | |
| ReferenceNumber | String | The reference number of the deleted transaction. | |
| TimeCreated | Datetime | The time the object was created. | |
| TimeDeleted | Datetime | The time the object was deleted. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| TimeModified | String | The deletion time to search for. Filters on TimeDeleted, not on when the transaction was last modified before deletion. |