Support #12399

[SCP ID :##6002##] : IBG Logs / Report

Added by Zahir Abd Latif almost 3 years ago. Updated almost 3 years ago.

Status:Closed - End of life cycleStart date:October 13, 2021
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:MY IBGSpent 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.

Also available in: Atom PDF