--ÖÊÁ¿¹ÜÀí
|
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'
|
