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

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

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 cbWMaterie