获取多类别基础资料字段（往来单位为客户为例）

 SELECT a.FBILLNO,FNOTVERIFICATEAMOUNT,C.FNUMBER,bbl.FNAME

 FROM T_AR_RECEIVEBILL a  --收款单

  INNER JOIN T_AR_RECEIVEBILLENTRY b ON a.FID=b.FID

  LEFT JOIN  V_FIN_CONTACTTYPE C ON C.FITEMID=a.FCONTACTUNIT AND c.FFORMID='BD_Customer'--这里获取客户就写BD_Customer，获取供应商写BD_Supplier 根据自己业务需求来

--AND FNUMBER='W0174'--

 LEFT JOIN T_BD_CURRENCY bb ON bb.FCURRENCYID=a.FCURRENCYID--币别--币别

 LEFT JOIN dbo.T_BD_CURRENCY_L bbl ON bbl.FCURRENCYID=bb.FCURRENCYID 

  WHERE  1=1-- AND C.FNUMBER='W0174' AND a.FBILLNO='SKD2409100755'