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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCsD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCsD
	print '19.  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 '20.  AcCsM Transactions Deleted'
GO

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

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

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

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCsMUpload]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCsMUpload
	print '24.  AcCsMUpload 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 '25.  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 '26.  AcCshInOut 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 '27.  AcCsTempD 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 '28.  AcCsTempM Transactions Deleted'
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcScM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcScM
	print '86.  AcScM 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 '87.  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 '88.  AcSerialCrd Transactions Deleted'
GO

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcSerialCrdHis]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcSerialCrdHis
	print '90.  AcSerialCrdHis 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 '91.  AcSerialCrdTemp Transactions Deleted'
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SysLogTrxErr]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table SysLogTrxErr
	print '137. 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 '138. 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 '139. SysLogUserLogin Transactions Deleted'
GO

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

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



UPDATE ACACC SET OPENING =0,Month1=0,month2=0,month3=0,
Month4=0,month5=0,month6=0,Month7=0,month8=0,month9=0,
Month10=0,month11=0,month12=0,LYOPENING=0,LYMONTH1=0, LYMONTH2=0,
LYMONTH3=0, LYMONTH4=0,LYMONTH5=0, LYMONTH6=0,LYMONTH7=0, LYMONTH8=0,
LYMONTH9=0, LYMONTH10=0,LYMONTH11=0, LYMONTH12=0,LYMONTH13=0, LYMONTH14=0,
LYMONTH15=0, LYMONTH16=0,LYMONTH17=0, LYMONTH18=0,LYMONTH19=0, LYMONTH20=0,
LYMONTH21=0, LYMONTH22=0,LYMONTH23=0, LYMONTH24=0

GO

Update AcCard Set PointBal1 = 0, PointBal2 = 0, SubComPoint = 0
GO

