金蝶K3--委外加工订单--列表

select d.fsourcebillno as 销售订单,f.fnumber as 成本对象,f.fmodel as 成本对象规格,c.fname as 供应商,convert(varchar(10),a.fdate,120) as 订单日期,case when a.fstatus=0 then ' ' else '审核' end as 审核,case when a.fclosed=0 then ' ' else '关闭' end as 关闭,case when a.fcancellation=0 then ' ' else '作废' end as 作废,a.fbillno as 订单编号,b.fentryid as 行号,b1.fnumber as 物料代码,b1.fname as 物料名称,b1.fmodel as 规格型号,b11.fname as 单位,g.fauxnobatchqty as 净需求,g.fauxplanqty as 计划量,d.fauxqty as 申请量,b.fauxqty as 订单量,b.fauxcommitqty as 关联量,b.fauxstockqty as 入库量,b.fauxqtyinvoice as 发票量,b.ftaxrate as 税率,b.fauxprice as 不含税,b.fauxtaxprice as 含税价,b.ftaxamount as 税额,b.famount as 金额,b.fallamount as 价税合计,b.ffetchdate as 订单交期,b.fnote as 行备注,h.fname as 制单,k.fname as 审核人
from icsubcontract a
inner join icsubcontractentry b on a.finterid=b.finterid
left outer join t_icitem b1 on b.fitemid=b1.fitemid
left outer