各公司年资金归集汇总sql
时间：2021-07-01 10:21:17
帮助过：2人阅读
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
各公司年资金归集汇总sql
标签：
