Support #13228
[SCP ID :##6432##] : Different of Consolidate Memberstatement & Memberstatement Window 10-12 Report
Status: | Closed - End of life cycle | Start date: | September 16, 2022 | |
---|---|---|---|---|
Priority: | High | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:-
There are the difference between of Consolidate Memberstatement & Memberstatement Window 10-12 Report. The different is in the credit total and the total of transaction.
*This issue happen to Maybank.
History
#1 Updated by Bramantyo Pujo Wiyono about 2 years ago
- Status changed from New - Begin Life Cycle to Investigation
#2 Updated by Bramantyo Pujo Wiyono about 2 years ago
- % Done changed from 0 to 10
Asked them to regenerate the report
Already Requesting back to check by this query:
--Query to get DEBIT total amount and volume transaction
select OFI_CODE, SUM AS AMT_DBT, COUNT FROM rpp_trnx_log_data where
OFI_CODE = 'IBBKIDJA' AND
COMPLETED_DATE >= TO_DATE('08092022 170000', 'DDMMYYYY HH24MISS') AND
COMPLETED_DATE < TO_DATE('08092022 180000', 'DDMMYYYY HH24MISS') AND
(TRNX_STATUS='ACTC' OR TRNX_STATUS='ACSP') AND SERVICE in ('010','011','019','110')
GROUP BY OFI_CODE;
--Query to get CREDIT total amount and volume transaction
select RFI_CODE, SUM AS AMT_DBT, COUNT FROM rpp_trnx_log_data where
RFI_CODE = 'IBBKIDJA' AND
COMPLETED_DATE >= TO_DATE('08092022 170000', 'DDMMYYYY HH24MISS') AND
COMPLETED_DATE < TO_DATE('08092022 180000', 'DDMMYYYY HH24MISS') AND
(TRNX_STATUS='ACTC' OR TRNX_STATUS='ACSP') AND SERVICE in ('010','011','019','110')
GROUP BY RFI_CODE;
--NOTE: Please change COMPLETED_DATE FILTER VALUE BASED ON WINDOW TIME FRAME WINDOW 10, 11 AND 12
waiting for response...
#3 Updated by Zahir Abd Latif almost 2 years ago
- Status changed from Investigation to Development / Work In Progress
- Assignee changed from Bramantyo Pujo Wiyono to Zahir Abd Latif
- % Done changed from 10 to 100
Wahyu Dwianto, Oct 5, 2022:-
For following ticket, you can close it due no issue from application. The difference between those reports due : there is in-house transaction for those participant.
Issue closed in SCP.
#4 Updated by Zahir Abd Latif almost 2 years ago
- Status changed from Development / Work In Progress to Closed - End of life cycle