A EDE SQL Expression
Section Title
The EDE value is derived using a SQL query on Oracle FLEXCUBE database, which returns a single value.
The below table describes the EDE Code and the EDE SQL Expression to use in Treasury External Data Element.
Table A-1 EDE SQL Expressions
EDE Code | EDE Description | EDE Data Type | Module ID | EDE Expression |
---|---|---|---|---|
SDE_SOLD_AMOUNT |
Sold Amount |
Numeric |
FX |
SELECT sold_amount FROM fxtb_contract_master WHERE contract_ref_no = '__CONTREFNO__' and event_seq_no = (SELECT MAX(event_seq_no) FROM fxtb_contract_master WHERE contract_ref_no = '__CONTREFNO__') |
SDE_SOLD_CCY |
Sold Currency |
String |
FX |
SELECT SOLD_CCY FROM fxtb_contract_master WHERE contract_ref_no = '__CONTREFNO__' and event_seq_no = (SELECT MAX(event_seq_no) FROM fxtb_contract_master WHERE contract_ref_no = '__CONTREFNO__') |
SDE_BOT_AMOUNT |
Bought Amount |
Numeric |
FX |
SELECT bot_amount FROM fxtb_contract_master WHERE contract_ref_no = '__CONTREFNO__' and event_seq_no = (SELECT MAX(event_seq_no) FROM fxtb_contract_master WHERE contract_ref_no = '__CONTREFNO__') |
SDE_BOT_CCY |
Bought Currency |
String |
FX |
SELECT BOT_CCY FROM fxtb_contract_master WHERE contract_ref_no = '__CONTREFNO__' and event_seq_no = (SELECT MAX(event_seq_no) FROM fxtb_contract_master WHERE contract_ref_no = '__CONTREFNO__') |
SDE_AMOUNT |
Amount |
Numeric |
MM |
SELECT amount FROM ldtb_tr_contract_master WHERE contract_ref_no = '__CONTREFNO__' an@ d version_no = (SELECT MAX(version_no) FROM LDTB_TR_CONTRACT_MASTER WHERE contract_ref_no = '__CONTREFNO__') |
SDE_BK_DATE |
Booking Date |
Date |
MM |
SELECT bookin_date FROM ldtb_tr_contract_master WHERE contract_ref_no = '__CONTREFNO__' and version_no = (SELECT MAX(version_no) FROM LDTB_TR_CONTRACT_MASTER WHERE contract_ref_no = '__CONTREFNO__') |
SDE_CUSTOMER |
Customer |
String |
MM |
SELECT counterparty FROM ldtb_tr_contract_master WHERE contract_ref_no = '__CONTREFNO__' and version_no = (SELECT MAX(version_no) FROM LDTB_TR_CONTRACT_MASTER WHERE contract_ref_no = '__CONTREFNO__') |
SDE_CURRENCY |
Currency |
String |
MM |
SELECT Currency FROM ldtb_tr_contract_master WHERE contract_ref_no = '__CONTREFNO__' and version_no = (SELECT MAX(version_no) FROM LDTB_TR_CONTRACT_MASTER WHERE contract_ref_no = '__CONTREFNO__') |
SDE_VAL_DATE |
Value Date |
Date |
MM |
SELECT Value_Date FROM ldtb_tr_contract_master WHERE contract_ref_no = '__CONTREFNO__' and version_no = (SELECT MAX(version_no) FROM LDTB_TR_CONTRACT_MASTER WHERE contract_ref_no = '__CONTREFNO__') |
SDE_PRODUCT |
Product |
String |
MM |
SELECT Product FROM ldtb_tr_contract_master WHERE contract_ref_no = '__CONTREFNO__' and version_no = (SELECT MAX(version_no) FROM LDTB_TR_CONTRACT_MASTER WHERE contract_ref_no = '__CONTREFNO__') |
SDE_CUSTOMER1 |
Customer |
String |
DV |
SELECT counterparty FROM dvtbs_contract_master WHERE contract_ref_no = '__CONTREFNO__' and version_no = (SELECT MAX(version_no) FROM dvtbs_contract_master WHERE contract_ref_no = '__CONTREFNO__') |
SDE_INLEGAMT |
IN LEG Amount |
Numeric |
DV |
SELECT IN_PRN_AMOUNT FROM DVTB_CONTRACT_MASTER WHERE contract_ref_no = '__CONTREFNO__' and version_no = (SELECT MAX(version_no) FROM DVTB_CONTRACT_MASTER WHERE contract_ref_no = '__CONTREFNO__') |
SDE_OUTLEGAMT |
OUT LEG Amount |
Numeric |
DV |
SELECT OUT_PRN_AMOUNT FROM DVTB_CONTRACT_MASTER WHERE contract_ref_no = '__CONTREFNO__' and version_no = (SELECT MAX(version_no) FROM DVTB_CONTRACT_MASTER WHERE contract_ref_no = '__CONTREFNO__') |
SDE_CUST_OT |
Customer |
String |
OT |
SELECT counterparty FROM Ottbs_Contract_Master WHERE contract_ref_no = '__CONTREFNO__' and version_no = (SELECT MAX(version_no) FROM Ottbs_Contract_Master WHERE contract_ref_no = '__CONTREFNO__') |