Bilgi Bankası Makalelerinde Ara

Database Clear

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

Bu makaleyi yararlı buldunuz mu?

İlişkili Makaleler

  • Menü Yaml Formatı

    - Name: Test Item 1 GroupCode: Test Items Barcode: 12345 Tag: Tag1 Portions: - Name: Pcs ...

  • Ürün Listesi Raporlama

    [Price List:5 ,3,6, 2] >ÜRÜN|PORS|KATEGORİ|[C]FİYAT {REPORT SQL DETAILS: ...

  • Payment - Transactions Report

    [Report:1,2, 1] >Payment Total|| CREDIT CARD TOLTAL:||[=F((TN("{ACCOUNT TRANSACTION TOTAL:Payment...

  • Server Clock Out Report

    [Server Checkout:1,1]User|{SETTING:CURRENTUSER}Clocked In|{REPORT TASK DETAILS:T.StartDate,T.StartTi...

  • metrik

    [S1:1, 1]{REPORT TICKET TYPES:!PreOrder && TotalAmount >= 0} [O1:1, 1]{REPORT TICKET TYPE...