Support #8808

SCP ID :##4740##] : request script to extract all SI transaction RIB & BIB

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

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

100%

Category:RIBSpent time:-
Target version:-

Description

Hi,
Kindly attend below request:

Please help to provide sql script to extract all SI transaction performed by customer. We need this info for refund purpose.

Thank You.

History

#1 Updated by Stephanie Sufrapto almost 6 years ago

  • Status changed from New - Begin Life Cycle to Pending Customer Feedback
  • Assignee changed from Yap Kah Yan to Zahir Abd Latif
  • % Done changed from 0 to 100

Providing query as user requested

BIB
select distinct(sihist.oid), si.si_id, si.TRANSACTION_DESC, si.PAYMENT_MODE, si.AMOUNT,
si.TOTAL_CHARGE_AMOUNT, hist.AMOUNT, hist.CUSTOMER_CHARGES,hist.GST_CHARGES, hist.TOTAL_CHG_AMOUNT, hist.TRNX_ID,
hist.TRNX_TYPE, hist.TRNX_STATUS, com.COMPANY_NAME from SI_HISTORY sihist join SI_MAIN si on sihist.SI_ID = si.SI_ID join
BIB_TRNX_HISTORY hist on hist.SI_ID = si.SI_ID join bib_company com on hist.company_id = com.COMPANY_ID
where si.CHANNEL = 'BIB' and sihist.STATUS='S'
order by sihist.oid asc;

RIB
select distinct(sihist.oid), si.si_id, si.TRANSACTION_DESC, si.PAYMENT_MODE, si.AMOUNT, si.TOTAL_CHARGE_AMOUNT,
hist.AMOUNT, hist.GST_CHARGES, hist.TOTAL_CHARGE_AMOUNT, hist.TRANSACTION_ID, hist.TRANSACTION_TYPE, hist.STATUS,
com.USER_ALIAS from SI_MAIN si join
IB_USER_TRANSACTION_HISTORY hist on hist.SI_ID = si.SI_ID join IB_USER com on hist.USER_ID = com.USER_ID
join SI_HISTORY sihist on si.SI_ID = sihist.SI_ID
where si.CHANNEL = 'RIB' and sihist.STATUS='S'
order by sihist.oid asc;

#2 Updated by Zahir Abd Latif almost 6 years ago

  • Status changed from Pending Customer Feedback to Closed - End of life cycle

Issue closed in SCP.

Also available in: Atom PDF