DeletedTransactions
Query deleted Transactions.
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 | |
| RefNumber | String | The transaction's reference number. | |
| TimeCreated | Datetime | The time the object was created. | |
| TimeDeleted | Datetime | The time the object was deleted. |
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 | The modified date to search for. |