金蝶/K3Wise 单据删除语句

--出入库单
update icstockbill set fcheckerid=0 ,fvchinterid=0 ,FCancellation=0 where fdate<='2020-01-31'
delete from icstockbill where fdate<='2020-01-31'
delete from icstockbillentry where finterid not in (select finterid from icstockbill )"

--采购发票
update icpurchase set fcheckerid=0 ,FCancellation=0 where fdate<='2020-01-31'
delete from icpurchase where fdate<='2020-01-31'
delete from icpurchaseentry where finterid not in (select finterid from icpurchase )"

--销售发票
update icsale set fcheckerid=0 ,FCancellation=0 where fdate<='2020-01-31'
delete from icsale where fdate<='2020-01-31'
delete from icsaleentry where finterid not in (select finterid from icsale )"

--采购订单
update poorder set fcheckerid=0 ,FCancellation=0,FOrderAffirm=0 where fdate<='2020-01-31'
delete from poorder where fdate<='2020-01-31'
delete from poorderentry where finterid not in (select finterid from poorder )"

--销售订单
update seorder set fcheckerid=0 ,FCancellation=0,FOrderAffirm=0 where fdate<='2020-01-31'
delete from seorder where fdate<='2020-01-31'
delete from seorderentry where finterid not in (select finterid from seorder )"

--库存余额表
delete from icbal where fyear<='2020'