/* 外汇远期、外汇期权 无本金交割现金流.类型由本金改成损益 */
update t_tm_cashflow set ftype='pl' where fbillid in
(select t_tm_trade.fid from t_tm_trade
left join t_tm_trade_f on t_tm_trade.fid=t_tm_trade_f.fid
where t_tm_trade.fprotecttypeid in (937487193708953600,941773368233832448)
and t_tm_trade_f.fdeliveryway = 'non-deliverable');

/* 外汇远期、外汇期权 无本金交割备份现金流.类型由本金改成损益 */
update t_tm_cashflow_bak set ftype='pl' where fbillid in 
(select t_tm_trade.fid from t_tm_trade
left join t_tm_trade_f on t_tm_trade.fid=t_tm_trade_f.fid
where t_tm_trade.fprotecttypeid in (937487193708953600,941773368233832448)
and t_tm_trade_f.fdeliveryway = 'non-deliverable');