-- 物料清单查询
select b.code 物料分类编码,b.name 物料分类名称,a.code 物料编码,a.name 物料名称,a.MATERIALSPEC 规格,a.MATERIALTYPE 型号,e.name 主计量单位,c.MEASRATE 换算率,d.NAME 辅计量单位,f.MATTAXESCODE 物料税类编码,f.MATTAXESNAME 物料税类名称
from BD_MATERIAL a
left join bd_marbasclass b on a.PK_MARBASCLASS=b.PK_MARBASCLASS
left join BD_MATERIALCONVERT c on a.PK_MATERIAL=c.PK_MATERIAL
left join BD_MEASDOC d on d.PK_MEASDOC=c.PK_MEASDOC
left join BD_MEASDOC e on a.PK_MEASDOC=e.PK_MEASDOC
left join BD_MATTAXES f on a.PK_MATTAXES=f.PK_MATTAXES
where a.ENABLESTATE=2
order by b.code,a.code