删除'BRMCUTZ190001','BRMCUTZ190002','BRMCUTZ190003','BRMNITZ200001'以外的所有合同
需求：删除'BRMCUTZ190001','BRMCUTZ190002','BRMCUTZ190003','BRMNITZ200001'以外的所有合同
数据准备
采购合同相关的业务
/*****************************采购***start*********************************************/
/*采购合同*/
select * from spot_contract where id in ('2c91669d72ca4a400172ca7cf7060068');
/*审批记录 合同*/
select * from wf_approve where doc_id in ('2c91669d73be99f20173e6bc31731546');
select * from wf_pending where doc_id in ('2c91669d73be99f20173e6bc31731546');
/*采购批次*/
select * from spot_lot where contract_id in ('2c91669d72ca4a400172ca7cf7060068');
/*采购交付批次*/
select * from spot_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca7cf7060068'));
/*定价*/
select * from spot_pricing where contract_id in ('2c91669d72ca4a400172ca7cf7060068');
/*入库*/
select * from spot_storage_delivery where in_lot_delivery_id in (select id from spot_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca7cf7060068')));
/*交付明细*/
select * from spot_delivery_detail where in_lot_delivery_id in (select id from spot_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca7cf7060068')));
/*报关*/
select * from spot_customs where contract_id in ('2c91669d72ca4a400172ca7cf7060068');
/*物流*/
select * from spot_serbia_logistics where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca7cf7060068'));
/*采购发票*/
select * from finance_invoice where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca7cf7060068'));
/*发票-交付批次 关联表*/
select * from spot_invoice_to_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca7cf7060068'));
/*预收付款*/
select * from finance_pay_before where contract_id in ('2c91669d72ca4a400172ca7cf7060068');
/*付款申请*/
select * from finance_fund where document_no in (select document_no from spot_invoice_to_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca7cf7060068')));
/*收付款 货款*/
select * from finance_fund_payment where invoice_id in (select id from finance_invoice where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca7cf7060068')));
/*收付款 预收付款*/
select * from finance_fund_payment where preRecevieAndPay_id in (select id from finance_pay_before where contract_id in ('2c91669d72ca4a400172ca7cf7060068'));
/*信用证*/
select * from finance_lc where contract_id in ('2c91669d72ca4a400172ca7cf7060068');
/*审批记录 发票*/
select * from wf_approve where doc_id in (select id from finance_fund where document_no in (select document_no from spot_invoice_to_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca7cf7060068'))));
select * from wf_pending where doc_id in (select id from finance_fund where document_no in (select document_no from spot_invoice_to_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca7cf7060068'))));
/*审批记录 预收付款*/
select * from wf_approve where doc_id in (select id from finance_pay_before where contract_id in ('2c91669d72ca4a400172ca7cf7060068'));
select * from wf_pending where doc_id in (select id from finance_pay_before where contract_id in ('2c91669d72ca4a400172ca7cf7060068'));
/*内部期货点价记录关联*/
select * from internal_position_detail where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca7cf7060068'));
/*内部头寸*/
select * from internal_position where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca7cf7060068'));
/*外部头寸*/
select * from external_position where internal_position_id in (select id from internal_position where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca7cf7060068')));
/*****************************采购***end*********************************************/
要删除的采购合同
/*删除的采购合同*/
select * from spot_contract where full_no not in (
'BRMCUTZ190001',
'BRMCUTZ190002',
'BRMCUTZ190003',
'BRMNITZ200001'
) and ps = 'B';
要删除的销售合同
select * from spot_contract where ps = 'S';
删除采购业务
/*定价*/
delete from spot_pricing where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395');
/*入库*/
delete from spot_storage_delivery where in_lot_delivery_id in (select id from spot_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395')));
/*交付明细*/
delete from spot_delivery_detail where in_lot_delivery_id in (select id from spot_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395')));
/*报关*/
delete from spot_customs where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395');
/*物流*/
delete from spot_serbia_logistics where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395'));
/*审批记录 预收付款*/
delete from wf_approve where doc_id in (select id from finance_pay_before where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395'));
delete from wf_pending where doc_id in (select id from finance_pay_before where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395'));
/*审批记录 发票*/
delete from wf_approve where doc_id in (select id from finance_fund where document_no in (select document_no from spot_invoice_to_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395'))));
delete from wf_pending where doc_id in (select id from finance_fund where document_no in (select document_no from spot_invoice_to_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395'))));
/*付款申请*/
delete from finance_fund where document_no in (select document_no from spot_invoice_to_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395')));
/*发票-交付批次 关联表*/
delete from spot_invoice_to_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395'));
/*收付款 货款*/
delete from finance_fund_payment where invoice_id in (select id from finance_invoice where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395')));
/*收付款 预收付款*/
delete from finance_fund_payment where preRecevieAndPay_id in (select id from finance_pay_before where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395'));
/*信用证*/
delete from finance_lc where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395');
/*采购发票*/
delete from finance_invoice where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395'));
/*预收付款*/
delete from finance_pay_before where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395');
/*外部头寸*/
delete from external_position where internal_position_id in (select id from internal_position where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395')));
/*内部期货点价记录关联*/
delete from internal_position_detail where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395'));
/*内部头寸*/
delete from internal_position where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395'));
/*采购交付批次*/
delete from spot_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395'));
/*采购合同*/
delete from spot_contract where id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395');
/*审批记录 合同*/
delete from wf_approve where doc_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395');
delete from wf_pending where doc_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395');
/*采购批次*/
delete from spot_lot where contract_id in ('2c91669d72ca4a400172ca58fdf4000a', '2c91669d72cc58160172ff10cd23087c', '2c91669d73470bd901734c0a4b7003f6', '2c91669d737681040173797c79330044', '2c91669d7380bfdf01739ea7945b0872', '2c91669d73be99f20173e6bc31731546', '2c91669d73f239950174002498a407b9', '2c91669d73f2399501740a8097ae0e94', '2c91669d73f2399501740ac4405f0ee8', '2c91669d74256b5c017428b998f900b0', '2c91669d74256b5c017428bf79f900bd', '2c91669d74256b5c017428c33ac800c5', '2c91669d74256b5c01742961ca3002de', '2c91669d74256b5c0174297f9a9d03c0', '2c91669d74338bad01744de6e1fb1713', '2c91669d74338bad01744de8fc2a171a', '2c91669d747b492801748a5891260917', '2c91669d74c5c8450174cdf238700395');
删除销售业务
/*定价*/
delete from spot_pricing where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f');
/*出库*/
delete from spot_storage_delivery where out_lot_delivery_id in (select id from spot_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f')));
/*交付明细*/
delete from spot_delivery_detail where out_lot_delivery_id in (select id from spot_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f')));
/*报关*/
delete from spot_customs where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f');
/*物流*/
delete from spot_serbia_logistics where lot_id in (select id from spot_lot where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f'));
/*审批记录 预收付款*/
delete from wf_approve where doc_id in (select id from finance_pay_before where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f'));
delete from wf_pending where doc_id in (select id from finance_pay_before where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f'));
/*审批记录 发票*/
delete from wf_approve where doc_id in (select id from finance_fund where document_no in (select document_no from spot_invoice_to_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f'))));
delete from wf_pending where doc_id in (select id from finance_fund where document_no in (select document_no from spot_invoice_to_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f'))));
/*付款申请*/
delete from finance_fund where document_no in (select document_no from spot_invoice_to_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f')));
/*发票-交付批次 关联表*/
delete from spot_invoice_to_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f'));
/*收付款 货款*/
delete from finance_fund_payment where invoice_id in (select id from finance_invoice where lot_id in (select id from spot_lot where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f')));
/*收付款 预收付款*/
delete from finance_fund_payment where preRecevieAndPay_id in (select id from finance_pay_before where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f'));
/*信用证*/
delete from finance_lc where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f');
/*发票*/
delete from finance_invoice where lot_id in (select id from spot_lot where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f'));
/*预收付款*/
delete from finance_pay_before where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f');
/*外部头寸*/
delete from external_position where internal_position_id in (select id from internal_position where lot_id in (select id from spot_lot where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f')));
/*内部期货点价记录关联*/
delete from internal_position_detail where lot_id in (select id from spot_lot where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f'));
/*内部头寸*/
delete from internal_position where lot_id in (select id from spot_lot where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f'));
/*交付批次*/
delete from spot_lot_delivery where lot_id in (select id from spot_lot where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f'));
/*合同*/
delete from spot_contract where id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f');
/*审批记录 合同*/
delete from wf_approve where doc_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f');
delete from wf_pending where doc_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f');
/*批次*/
delete from spot_lot where contract_id in ('2c91669d73470bd901734c122bbe042b', '2c91669d73be99f20173e706785615a8', '2c91669d74256b5c017428c3c9cf00cf','2c91669d72cc58160172e4f7e5d304b1','2c91669d72cc58160172feb11ef807ac','2c91669d72cc58160172ff01a7830859','2c91669d72cc58160172ff1346d60886','2c91669d73470bd901734c0a4b2903e7','2c91669d7380bfdf01739eb11ebd08db','2c91669d73be99f20173dc343e0b0fa9','2c91669d73be99f20173eada9d02193b','2c91669d73be99f20173ebba173919b8','2c91669d73f239950173ff90ea9b0755','2c91669d73f23995017400295e3707eb','2c91669d73f2399501740a8400440e9c','2c91669d74256b5c017428c9383a0191','2c91669d74256b5c017428ce33fd024d','2c91669d74256b5c017429511cb90285','2c91669d74256b5c0174297b0baa0392','2c91669d74256b5c01742983bdb403d1','2c91669d74338bad0174431111760e96','2c91669d74338bad01744d543f0515e7','2c91669d74338bad01744d56824e15ee','2c91669d74338bad01744decdf671720','2c91669d74338bad01744dee794e1731','2c91669d74338bad017452780d211a7a','2c91669d74338bad017452e5617a1aa4','2c91669d745dc37e01746b68286905f7','2c91669d745dc37e01746b704fd20600','2c91669d745dc37e01746cd6eba3063b','2c91669d747b492801748b310684094f','2c91669d747b492801748b34e9a9095e','2c91669d747b492801749052807d0c7c','2c91669d747b492801749054c0440c8a','2c91669d747b492801749056dedc0c98','2c91669d74b149a40174b9be1f090334','2c91669d74b149a40174b9c0c4250342','2c91669d74b149a40174b9c2a8940350','2c91669d74b149a40174b9c5793c035e','2c91669d74bb31a50174bdb9832d0001','2c91669d74bec9c30174c3199598032f');
浙公网安备 33010602011771号