CREATE PROCEDURE DBO.DeleteAllEconomics AS
SET NOCOUNT ON

/* 
 KJ20201202: Added missing tables.
 NB20151022 Invoice has been rewritten 
 KJ20130321 Identityfields has been rewritten. Case #CR054144
 KJ20100505 Added TransactionDeleteNote and TransactionsRelation
 KJ20080924 Fix for constaint errors.
 KJ20080821 Changed TableName to DBTableName
 KJ20070216 Added ForecastDaily
 KJ20060501 Removed IdentityFields-tables - using Identity
 KJ20050808 Removed some tables
*/

delete from AccountDaily
delete from BillCardInfo
delete from CustomerOrdreBook
delete from FolioRestResTableChairsXTab
delete from FolioBillXTab
DELETE FROM DebtorAccounting
delete from invoices
delete from InvoiceTransactionXTab
delete from ReceiptFiscal
delete from Invoice
delete from MISBUDGET
delete from MISTable
delete from TransactionKitchenStatementXTab
delete from KitchenStatement
DELETE FROM TransactionDeleteNote
DELETE FROM TransactionsRelation
DELETE FROM TransactionOnlinePaymentXtab
delete from Transactions
delete from folios
delete from waredaily

UPDATE IdentityInvoice SET IdentityField = 0
DELETE IdentityGlobalTransactionNumber
DBCC CHECKIDENT('IdentityGlobalTransactionNumber', RESEED, 0)