DeletedTransactions
Query deleted Transactions.
Table Specific Information
Select
The Reckon 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. | |
| TxnDelType | String | The owner of a data extension. | |
| ReferenceNumber | String | The entity full name. | |
| 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 | |
| StartTxnDate | String | Earliest modified date to search for. | |
| EndTxnDate | String | Latest modified date to search for. |