DeletedEntities
Query deleted Entities.
Table Specific Information
Select
The Reckon Accounts Hosted 本製品 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. | |
| ListDelType | String | The entity type. Valid 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, WorkersCompCode | |
| FullName | String | The entity full name. | |
| TimeCreated | Datetime | The time the object was created. | |
| TimeDeleted | Datetime | The time the object was deleted. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| TimeModified | String | The modified date to search for. |