清除帐套中指定 年月后的所有数据
操作前需做好备份,语句仅供参考
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
牛
清除帐套中指定 年月后的所有数据
本文2024-09-16 16:26:00发表“k3wise知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3wise-9204.html