CREATE PROCEDURE DBO.DeleteAllEconomics AS
SET NOCOUNT ON

/* Changes:
 KJ 20161107: Added missing tables.
 KJ 20130321: Identityfields has been rewritten. Case #CR054144
 KJ 20100505: Added TransactionDeleteNote and TransactionsRelation
 KJ 20080924: Fix for constaint errors.
 KJ 20080821: Changed TableName to DBTableName
 KJ 20070216: Added ForecastDaily
 KJ20060528: Removed CustomerAttentionTurnover
 KJ20060501: Removed IdentityFields-tables - using Identity
 KJ20050808: Removed some tables
*/

delete from AccountDaily
delete from BillCardInfo
delete from canceledBillNumbers
delete from CustomerOrdreBook
delete from FolioBillXTab
delete from FolioRestResTableChairsXTab
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 Transactions
delete from folios
delete from waredaily
DELETE ForecastDaily

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