ListDeleted Table
| Column | Data type | Data type name | Length | Can be queried? | Can be updated? | Can be inserted? | Mandatory when inserting? | Format | Refers To | Version introduced in | Edition available in |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ListID | 12 | VARCHAR | 125 | True | False | False | False | %s | 2.0 | US, CA, UK | |
| ListDelType | 12 | VARCHAR | 20 | True | False | False | False | Account Customer Employee OtherName Vendor StandardTerms DateDrivenTerms Class SalesRep CustomerType VendorType JobType CustomerMsg PaymentMethod ShipMethod SalesTaxCode ToDo ItemService ItemNonInventory ItemOtherCharge ItemInventory ItemInventoryAssembly ItemFixedAsset ItemSubtotal ItemDiscount ItemPayment ItemSalesTax ItemSalesTaxGroup ItemGroup PriceLevel PayrollItemNonWage PayrollItemWage VehicleMileage |
2.0 | US, CA, UK | |
| TimeCreated | 93 | TIMESTAMP | 23 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | 2.0 | US, CA, UK | |
| TimeDeleted | 93 | TIMESTAMP | 23 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | 2.0 | US, CA, UK | |
| FullName | 12 | VARCHAR | 41 | True | False | False | False | %s | 2.0 | US, CA, UK |