cas-资金对账汇总表对账单期初取数逻辑

问题:9期对账单期初不等于9期资金对账汇总表对账单期初

分析过程:
--银行对账单9期期初取数逻辑
select
fdebit,
fcredit,
fbalance ,
forder
from
( select
sum(FDebitStartAmt) FDebit,
sum(FCreditStartAmt) FCredit,
sum(FMonthStartAmt) FBalance ,
0 as forder
from
t_cas_journalBalance
where
FType = 3
and FIsInit = 1
and FAccountBankId in (
'c6oAAAFiHLv7Mm5e', 'c6oAAAFjCrj7Mm5e'
)
and FCurrencyId ='dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC'
union
all select
sum(FDebitAmount) FDebit,
sum(FCreditAmount) FCredit,
0 FBalance ,
1 as forder
from
t_cas_bankstatement
where
FCompanyId ='c6oAAAEqVwfM567U'
and FAccountBankId ='c6oAAAFiHLv7Mm5e'
and FCurrencyId = 'dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC'
and FPeriodId IS NOT NULL
and FCreateDate < {2018-08-31}
) b
order by
forder
--资金对账汇总表中9期银行对账单期初取数逻辑:初始化余额+借减贷差额
select
sum(SubResult) Result
from
( select
FMonthStartAmt SubResult
from
T_CAS_JournalBalance
where
FIsInit =0
and FCurrencyId ='dfd38d11-00fd-1000-e000-1ebdc
cas-资金对账汇总表对账单期初取数逻辑
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。



