资金归集:将所有下属公司指定账户上的资金归集到总公司账户
发布网友
发布时间：2022-04-08 06:39
我来回答
共1个回答
懂视网
时间：2022-04-08 11:00
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
标签：
