DELETE FROM [AccountTransactions]
GO
DELETE FROM [CashTransactions]
GO
DELETE FROM [CostItems]
GO
DELETE FROM [Discounts]
GO
DELETE FROM [PaidItems]
GO
DELETE FROM [Payments]
GO
DELETE FROM [PeriodicConsumptionItems]
GO
DELETE FROM [PeriodicConsumptions]
GO
DELETE FROM [TicketItemProperties]
GO
DELETE FROM [TicketItems]
GO
DELETE FROM [Tickets]
GO
DELETE FROM [TransactionItems]
GO
DELETE FROM [Transactions]
GO
DELETE FROM [WorkPeriods]
GO
Update Numerators set Number = 0
GO
Update Tables set TicketId = 0, IsTicketLocked = 0






bunuda oku adisyon kayboldu
http://forum2.sambapos.com/index.php?topic=1004.5;wap2

v3 sfrlama


DELETE FROM [TicketEntities]
GO
 
DELETE FROM [Tickets]
GO
 
DELETE FROM [AccountTransactionDocuments]
GO
 
DELETE FROM [AccountTransactions]
GO
 
DELETE FROM [AccountTransactionValues]
GO
 
DELETE FROM [Calculations]
GO
 
DELETE FROM [CostItems]
GO
 
DELETE FROM [InventoryTransactionDocuments]
GO
 
DELETE FROM [InventoryTransactions]
GO
 
DELETE FROM [Orders]
GO
 
DELETE FROM [PaidItems]
GO
 
DELETE FROM [PeriodicConsumptionItems]
GO
 
DELETE FROM [PeriodicConsumptions]
GO
 
DELETE FROM [ProductTimerValues]
GO
 
DELETE FROM [Payments]
GO
 
DELETE FROM [WarehouseConsumptions]
GO
 
DELETE FROM [WorkPeriods]
GO
 
UPDATE [Numerators] SET Number = 0
GO
 
UPDATE [EntityStateValues] SET EntityStates = '[{"S":"Available","SN":"Status"}]' Where EntityStates like '%Status%'
GO
