V1\V3\A8车辆费用单

一、车辆费用单怎么修改和删除

处理方法：

1、车辆费用单开单界面点击调入单据，可以调需要修改的单据进来修改。

2、备份数据后执行下面脚本进行删除：

DELETE FROM dbo.CM_FeeIndex WHERE BillCode='替换成要删除的单据编号'

DELETE FROM dbo.CM_FeeBill WHERE BillNumberId IN(SELECT BillNumberId FROM dbo.CM_FeeIndex WHERE BillCode='替换成要删除的单据编号')

DELETE FROM dbo.CM_FeeBill WHERE BillNumberId NOT IN(SELECT BillNumberId FROM dbo.CM_FeeIndex )