DeletedEntities
Queries entities deleted in QuickBooks, providing an audit trail for tracking removed records.
Table Specific Information
Select
The QuickBooks component requires filtering on ListDelType in order to perform the query, for example:
SELECT * FROM DeletedEntities WHERE ListDelType='Account'
Columns
| Name | Type | References | Description |
| ListID [KEY] | String | The unique identifier of the deleted entity. | |
| ListDelType | String | Specifies the type of entity that was deleted. The allowed values are Account, BillingRate, Class, Currency, Customer, CustomerMsg, CustomerType, DateDrivenTerms, Employee, InventorySite, ItemDiscount, ItemFixedAsset, ItemGroup, ItemInventory, ItemInventoryAssembly, ItemNonInventory, ItemOtherCharge, ItemPayment, ItemSalesTax, ItemSalesTaxGroup, ItemService, ItemSubtotal, JobType, OtherName, PaymentMethod, PayrollItemNonWage, PayrollItemWage, PriceLevel, SalesRep, SalesTaxCode, ShipMethod, StandardTerms, ToDo, UnitOfMeasureSet, Vehicle, Vendor, VendorType, and WorkersCompCode. | |
| FullName | String | The full name of the deleted entity, including any hierarchy if applicable. | |
| TimeCreated | Datetime | The date and time when the entity was initially created in the system. | |
| TimeDeleted | Datetime | The date and time when the entity 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 | Allows searching for deleted entities based on the last modified date. |