1.删除仓库数据，

若启用了业务系统，删除delete from icbal

若没有启用业务系统，删除delete from ICInvInitial（删除存货初始数据）

2.删除BOM表

delete from ICbomChild

delete from Icbom

delete from ICBomgroup

3.删除物料；

要删除物料，先删除附属信息表。

select * from t_icitembase where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitembase where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitemcore where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitemcustom where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitemdesign where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitemmaterial where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitemplan where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitemquality where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitemstandard where fitemid in (select Fitemid from t_item where fitemclassid=4)

--其中Fitemclassid为4，是表示4代表物料类。接下来删除物料；

delete from t_item where fitemclassid=4 or fitemclassid=2001

很高兴为你解答，希望我的回复能够帮到你，满意请采纳，谢谢！

产品问题清空业务初始化数据

产品问题 清空业务初始化数据