Support #7502
[Request ID :##3887##] : BIB Labuan Fund Transfer Report from March to May 2017
| Status: | Closed - End of life cycle | Start date: | June 13, 2017 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
Hi Hafiz,
Kindly attend below request.
Kindly help to provide SQL script to generate BIB Labuan FTT Report from March to May 2017
Thank you.
History
#1
Updated by Zahir Abd Latif about 7 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
Jeng Wei, Jun 13, 2017 11:38 AM:-
Hi Shahrul,
Sql Showing below.
select b.UPDATED_DATE,b.UPDATED_BY,a.TRNX_ID,
a.TRNX_TYPE,a.FROM_ACCOUNT_NO,a.FROM_ACC_CRT_DT,
a.FTT_COUNTRY,a.FOREX_RATE,a.TO_CURRENCY,a.FOREIGN_AMOUNT,
a.FROM_CURRENCY,a.LOCAL_AMOUNT,a.ESTIMATED_DEBIT_AMOUNT,
a.SENDER_ADDRESS1,a.SENDER_ADDRESS2,a.SENDER_POSTCODE,
a.SENDER_COUNTRY,a.SENDER_CONTACT,a.DESCRIPTION,
a.TRNX_DESC_2,a.TRNX_DESC_3,a.TRNX_DESC_4,
a.BENEFICIARY_ACC_NO,a.BENEFICIARY_NAME,
a.BENEFICIARY_ID,a.BENEFICIARY_ADDRESS1,
a.BENEFICIARY_ADDRESS2,a.BENEFICIARY_COUNTRY,a.BENEFICIARY_CONTACT,
a.BENEFICIARY_EMAIL,a.BENEFICIARY_BANK,a.BENEFICIARY_BRANCH,
a.CURR_CONDITION_TYPE,a.BENEFICIARY_CITY,a.CURR_CONDITION_NO,a.PHX_REFERENCE_NO,
a.TERMS,a.CHARGES,a.PHXCHAR_REF_NO,a.PHXCHARREV_REF_NO,a.EFFECTIVE_DATE,a.STATUS,
a.REMOTE_IP,a.REFERENCE,a.BRANCH_NAME,a.CHARGE_ACC_NO,a.NOSTRO_ACC_NO,a.OTHER1,
a.OTHER2,a.REASON,a.ACTUAL_STATUS,a.TRNX_DATE,a.USER_ID,a.INTERMEDIARY_BANK,
a.INTERMEDIARY_BANK_BRANCH,a.INTERMEDIARY_BANK_CODE,a.COMPANY_REG_NO,a.REG_NAME,
a.ADD_1,a.ADD_2,a.COUNTRY_OF_ORIGIN,a.SENDER_SWIFT_CODE,a.INSTRUCTED_AMOUNT,
a.FED_WIRE from BIB_FTT_TRANSFER a inner join BIB_COMPANY_TRANSACTION b on a.TRNX_ID = b.TRNX_ID
where a.trnx_id in (select distinct(trnx_id) from bib_company_transaction where trnx_code ='ftt'
and UPDATED_DATE between to_date('20170301','yyyymmdd') and to_date ('20170531','yyyymmdd')
and TRNX_STATUS in ('Unsuccessful','Successful','Accepted')) and (a.SI_INDICATOR is null or a.SI_INDICATOR = '1')
order by TRNX_DATE
Issue closed in SCP.