各公司年资金归集汇总sql
标签：
各公司年资金归集汇总sql
bd_accid.accidcode,
bd_accid.accidname,
-- fts_voucher_b.interestdate,
-- fts_voucher_b.summary,
--fts_voucher_b.debitamount,
-- fts_voucher_b.creditamount,
sum(fts_voucher_b.creditamount)年归集
from fts_voucher_b, bd_accid
where fts_voucher_b.dr = ‘0‘
and fts_voucher_b.pk_corp = ‘1162‘
and fts_voucher_b.pk_account = bd_accid.pk_accid
-- and bd_accid.accidcode = ‘011501‘ --公司
and fts_voucher_b.creditamount <> 0
and substr(fts_voucher_b.interestdate, 1, 4) = ‘2014‘ --年份
and fts_voucher_b.pk_ass not in
(select freevalueid from gl_freevalue where valuecode = ‘777777‘)
group by bd_accid.accidcode,
bd_accid.accidname
order by bd_accid.accidcode