清除5月份之前进销存

wbv123

delete from c_mail_doc where mailno in (select mailno from c_mail_m where sendtime<‘2019-05-01’)
delete from c_mail_m where sendtime<‘2019-05-01’
delete from c_mail_receiver where receivetime<‘2019-05-01’
–零售
alter table u_sale_c disable trigger all
alter table u_sale_m disable trigger all
alter table u_sale_pay disable trigger all
delete from u_sale_pay where saleno in (select saleno from u_sale_m where accdate<‘2019-05-01’)
delete from u_sale_c where accdate<‘2019-05-01’
delete from u_sale_m where accdate<‘2019-05-01’
alter table u_sale_c enable trigger all
alter table u_sale_m enable trigger all
alter table u_sale_pay enable trigger all

delete from r_sale where accdate<‘2019-05-01’
delete from r_sale_memcard where accdate<‘2019-05-01’
delete from r_sale_payee where accdate<‘2019-05-01’
delete from r_sale_pos where accdate<‘2019-05-01’
delete from r_sale_prom where accdate<‘2019-05-01’
delete from r_sale_saler where accdate<‘2019-05-01’
delete from r_ware_in_out where period<convert(varchar(12),cast(‘2019-05-01’ as datetime),112)

—————————————配送申请—–
alter table u_distapply_m disable trigger all
alter table u_distapply_c disable trigger all
delete from u_distapply_c where applyno in (select applyno from u_distapply_m where execdate<‘2019-05-01’)
delete from u_distapply_m where execdate<‘2019-05-01’
alter table u_distapply_m enable trigger all
alter table u_distapply_c enable trigger all
———————配送退仓—————
alter table u_dist_c disable trigger all
alter table u_dist_m disable trigger all
delete from u_dist_c where distno in (select distno from u_dist_m where execdate<‘2019-05-01’)
delete from u_dist_m where execdate<‘2019-05-01’
alter table u_dist_c enable trigger all
alter table u_dist_m enable trigger all

————–入库———————-
alter table u_accept_m disable trigger all
alter table u_accept_c disable trigger all
delete from u_accept_c where acceptno in (select acceptno from u_accept_m where execdate<‘2019-05-01’)
delete from u_accept_m where execdate<‘2019-05-01’
alter table u_accept_m enable trigger all
alter table u_accept_c enable trigger all
———————-报损————-
alter table u_abnormity_m disable trigger all
alter table u_abnormity_c disable trigger all
delete from u_abnormity_c where abnormityno in (select abnormityno from u_abnormity_m where execdate<‘2019-05-01’)
delete from u_abnormity_m where execdate<‘2019-05-01’
alter table u_abnormity_m enable trigger all
alter table u_abnormity_c enable trigger all
—————–盘点——————————–
alter table u_check_reg disable trigger all
alter table u_check_account disable trigger all
alter table u_Check_diff disable trigger all
alter table u_check_track_m disable trigger all
alter table u_check_track_c disable trigger all

alter table u_check_diffsum disable trigger all

delete from u_check_account where checkno in (select checkno from u_check_reg where endtime<‘2019-05-01’)
delete from u_check_diff where createtime<‘2019-05-01’
delete from u_check_diffsum where checkno in (select checkno from u_check_reg where endtime<‘2019-05-01’)

delete from u_check_track_m where checkno in (select checkno from u_check_reg where endtime<‘2019-05-01’)
delete from u_check_track_c where checkno in (select checkno from u_check_reg where endtime<‘2019-05-01’)

delete from u_check_reg where endtime<‘2019-05-01’

alter table u_check_reg enable trigger all
alter table u_check_account enable trigger all
alter table u_Check_diff enable trigger all
alter table u_check_track_m enable trigger all
alter table u_check_track_c enable trigger all

alter table u_check_diffsum enable trigger all
—需求单
alter table u_buyerdemand_m disable trigger all
alter table u_buyerdemand_c disable trigger all
delete from u_buyerdemand_c where demandno in (select demandno from u_buyerdemand_m where execdate<‘2019-05-01’)
delete from u_buyerdemand_m where execdate<‘2019-05-01’
alter table u_buyerdemand_c enable trigger all
alter table u_buyerdemand_m enable trigger all
————–收货单———————-
alter table u_md_notice_accept_c disable trigger all
alter table u_md_notice_accept_m disable trigger all
delete from u_md_notice_accept_c where acceptno in (select acceptno from u_md_notice_accept_m where execdate<‘2019-05-01’)
delete from u_md_notice_accept_m where execdate<‘2019-05-01’
alter table u_md_notice_accept_m enable trigger all
alter table u_md_notice_accept_c enable trigger all

————–验收单———————-
alter table u_md_tally_accept_c disable trigger all
alter table u_md_tally_accept_m disable trigger all
delete from u_md_tally_accept_c where acceptno in (select acceptno from u_md_tally_accept_m where execdate<‘2019-05-01’)
delete from u_md_tally_accept_m where execdate<‘2019-05-01’
alter table u_md_tally_accept_m enable trigger all
alter table u_md_tally_accept_c enable trigger all

————–不合格销毁单———————-
alter table u_failure_c disable trigger all
alter table u_failure_m disable trigger all
delete from u_failure_c where failureno in (select failureno from u_failure_m where execdate<‘2019-05-01’)
delete from u_failure_m where execdate<‘2019-05-01’
alter table u_failure_m enable trigger all
alter table u_failure_c enable trigger all
————–门店货位调整单———————-
alter table u_md_stall_dist_c disable trigger all
alter table u_md_stall_dist_m disable trigger all
delete from u_md_stall_dist_c where stldistno in (select stldistno from u_md_stall_dist_m where execdate<‘2019-05-01’)
delete from u_md_stall_dist_m where execdate<‘2019-05-01’
alter table u_md_stall_dist_m enable trigger all
alter table u_md_stall_dist_c enable trigger all