| | |
|---|
| | | ,case when isnull(q.FCHECKINCOMING,0)='1' then 1 else 0 end as HCHECKINCOMING,isnull(s.FEXPUNIT,'') as HEXPUNIT,isnull(s.FEXPPERIOD,0) as HEXPPERIOD |
|---|
| | | ,isnull(b.FBASEUNITID,0) as HBASEUNITID,isnull(ms.FSALEUNITID,0) as HSALEUNITID,isnull(ms.FSALEPRICEUNITID,0) HSALEPRICEUNITID |
|---|
| | | ,isnull(mp.FPERUNITSTANDHOUR,0) as HPERUNITSTANDHOUR,isnull(mp.FSTDLABORPREPARETIME,0) as HSTDLABORPREPARETIME,isnull(mp.FSTDMACHINEPREPARETIME,0) as HSTDMACHINEPREPARETIME |
|---|
| | | ,isnull(a.FMASTERID,0) as HMASTERID,0 HMoneyDec |
|---|
| | | ,isnull(a.FMASTERID,0) as HMASTERID,0 HMoneyDec,a.F_XG HMinPOQty |
|---|
| | | from T_BD_MATERIAL a with(nolock) |
|---|
| | | inner join T_BD_MATERIAL_L l with(nolock) on a.FMATERIALID=l.FMATERIALID |
|---|
| | | inner join T_BD_MATERIALBASE b with(nolock) on a.FMATERIALID=b.FMATERIALID |
|---|
