TxnDeleted Table

Back to list of tables.

ColumnData typeData type nameLengthCan be queried?Can be updated?Can be inserted?Mandatory when inserting?FormatRefers ToVersion introduced inEdition available in
TxnDelType12VARCHAR75TrueFalseFalseFalse
Bill
BillPaymentCheck
BillPaymentCreditCard
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
Invoice
InventoryAdjustment
ItemReceipt
JournalEntry
PurchaseOrder
ReceivePayment
SalesOrder
SalesReceipt
SalesTaxPaymentCheck
TimeTracking
VendorCredit
ARRefundCreditCard
VehicleMileage
2.0US, CA, UK
TxnID12VARCHAR20TrueFalseFalseFalse%s2.0US, CA, UK
TimeCreated93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ2.0US, CA, UK
TimeDeleted93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ2.0US, CA, UK
TimeModified11TIMESTAMP16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ2.0US, CA, UK
RefNumber12VARCHAR20TrueFalseFalseFalse%s2.0US, CA, UK