EAS_资金对账票据对账sql

=======资金对账====================T_FM_FmSettleResult
SELECT top 50 rt.FFmBizType,p.FNumber,rt.FDiffAmount as "差异金额",rte.* FROM  T_FM_FmReconResult rt 
--资金对账中心分录
left join  T_FM_FmReconResultEntry rte on rte.FParentID = rt.FID
--资金对账方向
left join   T_REC_SipgFmReconDirection  rd on rd.FID = rt.FDirectionID
--资金对账关系
left join  T_REC_SipgFmReconMapping rm on rm.FID = rt.FMappingID
--资金对账关系分录
left join  T_REC_SipgFmReconMappingEntry rme on rme.FParentID = rm.FID
--融资品种
left join  T_FIN_FinancingProducts fp on fp.FID = rme.FProductsID
left join T_ORG_Company co on co.FId = rt.FCompanyID
left join T_BD_Period p on p.FID = rt.FPeriodEntryID
where co.FNumber='01.01' order by rt.FCreateTime desc,rt.fid