Page tree
Skip to end of metadata
Go to start of metadata

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

处理方法:

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 )

  • No labels