隐藏门店收货单的配送单

wbv123

create table #disable_u_dist_c (id int)
update b set md_wareqty=wareqty from u_dist_m a, u_dist_c b where a.distno=b.distno
and a.billcode in(‘DIs’ ,’ADD’ ) and execdate<=’2019-09-05′
drop table #disable_u_dist_c
隐藏按照日期在门店收货单里面的配送单

create table #disable_u_dist_c (id int)
update b set md_wareqty=wareqty from u_dist_m a, u_dist_c b where a.distno=b.distno
and a.billcode in(‘DIs’ ,’ADD’ ) and a.distno=’21121600000305′
drop table #disable_u_dist_c

隐藏按照单号在门店收货单里面的配送单