SambaPOS V3 Clear Transaction Data
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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment