use hbposev9  
go
--【处理销售流水】
Insert into t_rm_saleflow
(flow_id,flow_no,branch_no,item_no,source_price,sale_price,sale_qnty,sale_money,sell_way,
oper_id,sale_man,counter_no,oper_date,shift_no,spec_flag,pref_amt, in_price,posid,spec_sheet_no,
pr_spec_sheet_no,pr_spec_pref_amt,ot_spec_sheet_no,ot_spec_pref_amt,item_no_Fresh) 
select 
flow_id,flow_no,branch_no,item_no,source_price,sale_price,sale_qnty,sale_money,sell_way,
oper_id,sale_man,counter_no,oper_date,shift_no,spec_flag,pref_amt, in_price,posid,spec_sheet_no,
pr_spec_sheet_no,pr_spec_pref_amt,ot_spec_sheet_no,ot_spec_pref_amt,item_no_Fresh
from t_rm_saleflow_temp where flow_no not in (select flow_no from t_rm_saleflow)
go
--【处理付款流水】
 Insert into t_rm_payflow (
 flow_id,flow_no,sale_amount,branch_no,pay_way,sell_way,card_no,vip_no,coin_no,coin_rate,
 pay_amount,oper_date,oper_id,counter_no,sale_man,memo,voucher_no,shift_no,posid)
 select 
 flow_id,flow_no,sale_amount,branch_no,pay_way,sell_way,card_no,vip_no,coin_no,coin_rate,
 pay_amount,oper_date,oper_id,counter_no,sale_man,memo,voucher_no,shift_no,posid 
 from  t_rm_payflow_temp where flow_no not in (select flow_no from t_rm_payflow)
 go