KIS专业版删除固定资产变动记录

症状:固定资产卡片最近一次变动记录删除不了,删除时提示:“数据已存在”。
解决方法:执行以下语句
--删除固定资产变动记录,FAlterID为变动记录号
delete from t_FAExpense where FAlterID = 220
delete from t_FAVoucher where FAlterID = 220
delete from t_faorgfor where FAlterID = 220
delete from t_facarditem where FAlterID = 220
delete from t_FADept where FAlterID = 220
delete from t_FACard where FAlterID = 220
delete from t_FAAlter where FAlterID = 220

上一篇:Codeforces Round #551题解


下一篇:地理-地点:鸡黍镇