--ÖÊÁ¿¹ÜÀí
TRUNCATE TABLE ICQCBill
TRUNCATE TABLE ICQCBillEntry
truncate table  dbo.QMReject
truncate table  dbo.QMRejectEntry
truncate table  QMSaleCkRequest
truncate table  QMSaleCkRequestEntry
truncate table  QMINQCReq
truncate table  QMINQCReqEntry
truncate table  QMOtCkRequest
truncate table  QMOtCkRequestEntry

--ÎïÁÏÐèÇó¼Æ»®
truncate table ICMrpInfo
truncate table ICMrpResult
truncate table ICMrpDestBills

--Éú²ú¹ÜÀí
DELETE FROM ICSerialFlow
truncate table ICClientVer
truncate table ICPlan_PMCDetail
truncate table ICPlanOrderRel
truncate table ICShop_ItemConsumeEntry
truncate table ICMOConvertBill
truncate table ICMOConvertBillEntry
truncate table PPBomChange
truncate table PPBomChangeEntry
truncate table PPBOMEntry
truncate table ICitemScrap
truncate table ICitemScrapEntry
truncate table ICMORpt
truncate table ICMORptEntry
truncate table ppbom
truncate table dbo.PPBOMEntry
truncate table ICChange
truncate table ICChangeEntry
truncate table ICMOChange
truncate table ICMOChangeEntry
truncate table ICMO

--²É¹º¹ÜÀí
truncate table dbo.PORequest
truncate table dbo.PORequestEntry
truncate table dbo.POInStock
truncate table dbo.POInStockEntry
truncate table dbo.ICExpenses
truncate table dbo.ICExpensesEntry
   
--ίÍâ¼Ó¹¤

--ÏúÊÛ¹ÜÀí
truncate table t_dev_freight
truncate table t_dev_freightEntry2

--²Ö¿â¹ÜÀí
truncate table ICSTJGBill
truncate table ICSTJGBillEntry
  
--ÐèÈ«²¿É¾³ýºó£¬Ðè¸üÐÂÆôÓÃÆÚ¼äºóÕËÌײÅÄÜ¿ªÊ¼Ê¹ÓÃ
update t_SystemProfile set FValue=9 where FCategory='ic' and FKey='currentperiod'
update t_SystemProfile set FValue=2020 where FCategory='ic' and FKey='currentyear'
update t_SystemProfile set FValue=9 where FCategory='ic' and FKey='startperiod'
update t_SystemProfile set FValue=2020 where FCategory='ic' and FKey='startyear'