if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCsD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCsD
	print '1.   AcCsD Transactions Deleted'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCsM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCsM
	print '2.   AcCsM Transactions Deleted'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCshCnt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCshCnt
	print '3.   AcCshCnt Transactions Deleted'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCshInOut]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCshInOut
	print '4.   AcCshInOut Transactions Deleted'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCsTempM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCsTempM
	print '5.   AcCsTempM Transactions Deleted'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCsTempD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCsTempD
	print '6.   AcCsTempD Transactions Deleted'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcSerial]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcSerial
	print '7.   AcSerial Transactions Deleted'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcSerialCrd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcSerialCrd
	print '8.   AcSerialCrd Transactions Deleted'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcSerialCrdTemp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcSerialCrdTemp
	print '9.   AcSerialCrdTemp Transactions Deleted'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcStkQtyD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcStkQtyD
	print '10.  AcStkQtyD Transactions Deleted'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcStkQtyDownLoad]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcStkQtyDownLoad
	print '11.  AcStkQtyDownLoad Transactions Deleted'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SysDocNo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Update SysDocNo Set LastNumber = '100000'
	print '12. SysDocNo Last Number Updated back to 100000'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SysLogTrxErr]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table SysLogTrxErr
	print '13. SysLogTrxErr Transactions Deleted'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SysLogUserActivity]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table SysLogUserActivity
	print '14. SysLogUserActivity Transactions Deleted'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SysLogUserLogin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table SysLogUserLogin
	print '15. SysLogUserLogin Transactions Deleted'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCardDump]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCardDump
	print '111. AcCardDump Truncated'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcSerialDump]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcSerialDump
	print '112. AcSerialDump Truncated'
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcStkDump]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcStkDump
	print '113. AcStkDump Truncated'
GO

