清除帐套中指定 年月后的所有数据

操作前需做好备份，语句仅供参考

UPDATE ICPurchase   -----删除采购发票

SET FCheckerID = 0,FCheckDate = NULL,FCancellation=0 where fdate>=@MaxDate

DELETE FROM ICPurchaseEntry where finterid in(select finterid from icpurchase where fdate>=@MaxDate)

DELETE FROM ICPurchase where fdate>=@MaxDate

DELETE FROM ICInvBackup

-----删除生产任务单

update icmo set FConveyerID=0,FCommitDate=null,FStatus=0

delete from icmo where fcheckdate>=@MaxDate

-----删除生产任务单结束

DELETE FROM PPBOMEntry where finterid in(select finterid from ppbom where fdate>=@MaxDate)

update ppbom set fcheckerid=null,fcheckdate=null where fdate>=@MaxDate

DELETE FROM PPBOM  where fdate>=@MaxDate  ------删除生产投料单

----删除成本系统中  成本余额表  数据

DELETE FROM cbBalance

----cbCostObjDetail 成本余额材料明细表

DELETE FROM cbCostObjDetail  

----cbMakeDistributeInfo 制造费用分配表

----CBWasterAmends 废品索赔表

DELETE FROM CBWasterAmends

----CBOnInitBalance 期初在产品调整单

----cbCalInfo 成本计算单

DELETE FROM cbCalInfo

----cbWMaterielInfo 废品损失材料费用分配表

DELETE FROM cbWMaterielInfo

----cbWNCalInfo 废品不可修复成本计算单

DELETE FROM cbWNCalInfo

----删除成本系统中  其他费用 数据

DELETE FROM CBCostExpenseInfo

----删除成本系统中  材料费用分配  数据

DELETE FROM cbMaterielInfo

----cbCompleteQty 完工产量

DELETE FROM cbCompleteQty

----cbInQty 成本投入产量表

DELETE FROM cbInQty

----cbCostObjCheck 在产品月末盘点表

DELETE FROM cbCostObjCheck

----cbProductCalInfo 完工产品成本计算单

DELETE FROM cbProductCalInfo

----cbProductQty 产品本期完工产量表

DELETE FROM cbProductQty

----CBKZProductCalInfo 标准产品成本计算单

DELETE FROM CBKZProductCalInfo

----CBProductMatWip 在产品盘点表

DELETE FROM CBProductMatWip

----cbRationStandardInfo 分配标准数值表

DELETE FROM cbRationStandardInfo

----cbCalInfo 成本计算单

delete from cbcalinfo