Support #8808
SCP ID :##4740##] : request script to extract all SI transaction RIB & BIB
Status: | Closed - End of life cycle | Start date: | October 09, 2018 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | RIB | Spent 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.