金蝶K3--采购委外单价

select case when a.fused=1 then '审核' else '未审' end as 审核,c.fname as 供应商,b.fnumber as 物料代码,b.fname as 物料名称,b.fmodel as 规格型号,case when a.fptype=1 then '采购' else '委外' end as 类型,a.fprice as 报价,d.fname as 单位,f.fqty as 即时库存,isnull(g.fname,' ') as 默认仓库,a.fquotetime as 起日期,a.fdisabledate as 止日期,a.flastmodifieddate as 更新日期,e.fname as 制单,a.fremark as 备注
from t_supplyentry a left outer join t_icitem b on a.fitemid=b.fitemid left outer join t_supplier c on a.fsupid=c.fitemid left outer join t_measureunit d on a.funitid=d.fmeasureunitid left outer join t_user e on a.flastmodifiedby=e.fuserid left outer join icinventory f on a.fitemid=f.fitemid and b.fdefaultloc=f.fstockid left outer join t_stock g on f.fstockid=g.fitemid

 

转载于:https://my.oschina.net/ansenchina/blog/3022743