貳伍陸門's Blog......

前方是絕路,希望在轉角!

金蝶KIS K/3删除核算项目语句

删除物料:

delete from t_icitembase
delete from t_icitemcore
delete from t_icitemcustom
delete from t_icitemmaterial
delete from t_icitemplan
delete from t_Icitemquality
delete from t_icitemstandard
delete from t_item where fitemclassid=2001
delete from t_item where fitemclassid=4


删除客户资料:

delete from t_Organization
delete from t_item where fitemclassid=1


删除供应商资料:

delete from t_Supplier
delete from t_item where fitemclassid=8

分页:[«]1[»]