Support #6727
[SCP ID :##3437##] : Labuan Report
| Status: | Closed - End of life cycle | Start date: | October 25, 2016 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | MY BIB | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request.
There is a request from BI team to know from which table the data from BIB Labuan Fund Transfer Report is extracted from.
If possible could you please share the script used in the program to extract the data and what is the different between
column Date, Value Date and Initiated Date (in the report)
History
#1
Updated by Zahir Abd Latif almost 8 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
Done by Hafiz.
Salam Ashikin/Shahrul,
Date = Approver date/transfer date/update date
value date = Effective date
Initiated Date = date of created transaction (initiator/approver)
Sql for FTT report
select b.UPDATED_DATE,b.UPDATED_BY,a.TRNX_ID,a.TRNX_TYPE,a.DESCRIPTION,a.FROM_ACCOUNT_NO,a.SENDER_ADDRESS1,a.SENDER_ADDRESS2,a.BENEFICIARY_ADDRESS1,a.BENEFICIARY_ADDRESS2,a.TERMS,a.FROM_ACC_CRT_DT,a.FTT_COUNTRY,a.FOREX_RATE,a.TO_CURRENCY,a.FOREIGN_AMOUNT,a.FROM_CURRENCY,a.LOCAL_AMOUNT,a.SENDER_POSTCODE,a.SENDER_COUNTRY,a.SENDER_CONTACT,a.BENEFICIARY_ACC_NO,a.BENEFICIARY_NAME,a.BENEFICIARY_ID,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.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 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('20161025','yyyymmdd') and to_date ('20161026','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.