Support #12399
[SCP ID :##6002##] : IBG Logs / Report
Status: | Closed - End of life cycle | Start date: | October 13, 2021 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | MY IBG | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:-
Kindly help to provide the report name / db table / log where below details can be retrieved, it is requested by Operation team for the reconciliation.
1) IBG_Transaction_Number
2) Trace Number
3) Beneficiary Customer Name
4) Beneficiary Bank Name
History
#1 Updated by Zahir Abd Latif almost 3 years ago
- Status changed from New - Begin Life Cycle to Closed - End of life cycle
- Assignee changed from Hafizudin MD to Zahir Abd Latif
- % Done changed from 0 to 100
Hafiz, Oct 15, 2021:-
Please execute sql below to get the result. Schema IBG Normal RFI select RECEIVE_TRNX_ID as trnxId, RFI_TRACE_NO as traceNo, ORIGINATOR_NAME as custName from IBG_RFI; Return RFI select IBG_RFI.RECEIVE_TRNX_ID as returntrnxId, IBG_ENTRY.TRNX_ID as trnxIdofi, IBG_RFI.ORIGIN_TRACE_NO as traceNo , ORIGINATOR_NAME as custName , IBG_ENTRY.BENE_BANK_NAME as bankName from IBG_RFI , IBG_OFI , IBG_ENTRY where IBG_RFI.ORIGIN_TRACE_NO = IBG_OFI.TRACE_NO and IBG_OFI.IBG_TRNX_ID = IBG_ENTRY.IBG_TRNX_ID; OFI select IBG_ENTRY.IBG_TRNX_ID as ibgTrnxIdOfi, IBG_ENTRY.TRNX_ID as trnxIdofi, IBG_OFI.TRACE_NO as traceNo, IBG_ENTRY.TO_ACCOUNT_NAME as custName , IBG_ENTRY.BENE_BANK_NAME as bankName from IBG_OFI , IBG_ENTRY where IBG_OFI.IBG_TRNX_ID = IBG_ENTRY.IBG_TRNX_ID;
Issue closed in SCP.