eoy verification 2024

Credit interest verification 2024

Email report

Verification point	Source	Message
No of records in IFRS9-table	OKQ_IFRS9_EXTR	No of records: 486568
Interest capt. EOC-12/31	HK-log	Part bal fee posting prepared svcid/#/SEK: 400/0/0
Interest capt. EOC-12/31	HK-log	Credit interest posting prepared svcid/#/SEK: 411/0/0
Interest capt. EOC-12/31	HK-log	Debit interest posting prepared svcid/#/SEK: 411/0/0
Interest capt. EOC-12/31	HK-log	Part bal fee posting prepared svcid/#/SEK: 411/0/0
Interest capt. EOC-12/31	HK-log	Debit interest posting prepared svcid/#/SEK: 400/0/0
Interest capt. EOC-12/31	HK-log	Credit interest posting prepared svcid/#/SEK: 400/49726/238744.32
Interest capt. EOC-12/31	HK-log	Credit interest posting prepared svcid/#/SEK: 414/8270/20269.5
Interest capt. EOC-12/31	HK-log	Part bal fee posting prepared svcid/#/SEK: 414/0/0
Interest capt. EOC-12/31	HK-log	Debit interest posting prepared svcid/#/SEK: 414/0/0
Credit int posted to accum. acct 12/31	INT_TXS.	Posted (cnt/sum): 57995/259013.81
Credit int. tax posted 12/31	INT_TXS.	Posted (cnt/sum): 11001/1189340
Credit int. tax decimals posted 12/31.	INT_TXS.	Posted (cnt): 0
Credit int. posted to billing lvl acct 12/31	INT_TXS.	Posted (cnt/sum): 75884/5139891.43
Bonus cash redemp. posted to accum. acct 12/31	INT_TXS.	Posted (cnt/sum): 55049/3746260
Reversal of CR int. prep 12/31	INT_BATCH_CAPT	In IBC (cnt/sum): 57996/259013.82
No of clients that paid interest during the year	INT_TXS.	In IT (cnt): 49844

select client_number, account_amount_gr
from int_transactions
where institution_number = '00000051'
  and record_date = (select posting_date
                     from bw3.sys_posting_date
                     where institution_number = '00000051'
                       and station_number = '130')
  and transaction_type = '470'
  and transaction_class = '002'
  and transaction_status = '002'
  and transaction_source = '031'
  and dr_cr_indicator = '002'
  and reversal_flag = '000'
order by to_number(account_amount_gr) desc
 

Accounts with credit interest balance

 
select cca.acct_number, ccbb.current_balance
from cas_client_account cca
    inner join cas_cycle_book_balance ccbb
        on
        cca.acct_number = ccbb.acct_number
            and cca.institution_number = ccbb.institution_number
            and ccbb.processing_status = '004'
where service_contract_id in ('400','411','414')
  and account_type_id = '203'
and ccbb.current_balance > 0

Credit interest posted

select acct_number, account_amount_gr
from int_transactions
where institution_number = '00000051'
  and record_date = (select posting_date
                     from bw3.sys_posting_date
                     where institution_number = '00000051'
                       and station_number = '130')
  and transaction_type = '347'
  and transaction_class = '002'
  and transaction_status = '002'
  and reversal_flag = '000'
order by to_number(account_amount_gr) desc