Info |
---|
|
- Signage Logic can be applied only to extracts
- Currently available for Warehouse Trade, Traded Cash Activity, and Settled Cash Activity feeds
|
Signage logic allows to change the algorithm of getting values for certain numeric fields. This includes changes applied on the step of calculation of their value:
Expand |
---|
title | Click to expand an example of alternative calculation |
---|
|
AMOUNT field in Traded CA (if 'IncludeCurveAnalytics' = 'Y'): Code Block |
---|
| CASE WHEN ESTAR_TRADED_CASH_ACTIVITY.CASH_EVT_TYP <> 'RECPT'
THEN NVL(ESTAR_TRADED_CASH_ACTIVITY.AMOUNT,0) * -1
ELSE NVL(ESTAR_TRADED_CASH_ACTIVITY.AMOUNT,0)
END AMOUNT |
|
Signage logic is enabled with parameter 'EnableSignageLogic' set to 'Y' or by its global analog W_ENABLE_SIGNAGE_LOGIC in w_config_custom.cfg (if the value is 'N' or not specified (default), numeric fields are used presented as usualstored in database).
Field Group Number | Warehouse Trade Fields | Traded CA Fields | Settled CA Fields |
---|
1 | NET_CASH | AMOUNT | AMOUNT |
TRADE_BASE_AMOUNT | NET_AMOUNT_BASE | NET_AMOUNT_BASE |
SETTLE_AMOUNT_LOCAL | SETTLE_AMOUNT_LOCAL |
REC_PAY_AMT_B | REC_PAY_AMT_B |
REC_PAY_AMT_L | REC_PAY_AMT_L |
2 | COST_BASE | (no fields) | (no fields) |
COST_LOCAL |
ORIG_ACQ_COST_BASE |
ORIG_ACQ_COST_LOCAL |
PAR_OR_SHARES |
3 | PRINCIPAL | PRINCIPAL | PRINCIPAL |
PRINCIPAL_BASE | PRINCIPAL_AMOUNT_BASE | PRINCIPAL_AMOUNT_BASE |
4 | BASE COMMISSION AMOUNT | COMM_AMT_B | COMM_AMT_B |
LOCAL_COMMISSION_AMOUNT | COMM_AMT_L | COMM_AMT_L |
EXCHANGE_FEE | OTHER_FEE_B | OTHER_FEE_B |
EXCHANGE_FEE_BASE | OTHER_FEE_LOCAL | OTHER_FEE_LOCAL |
OTHER_FEE | RECLAIM_AMOUNT_BASE | RECLAIM_AMOUNT_BASE |
OTHER_FEE_BASE | RECLAIM_L | RECLAIM_L |
SEC_FEES | SEC_FEE | SEC_FEE |
SEC_FEES_BASE | SEC_FEE_B | SEC_FEE_B |
TAXES | STAMP_DUTY_TAX_B | STAMP_DUTY_TAX_B |
TAXES_BASE | STAMP_DUTY_TAX_L | STAMP_DUTY_TAX_L |
TAX_AMT_B | TAX_AMT_B |
TAX_AMT_L | TAX_AMT_L |
TAX_EXPENSE_BASE | TAX_EXPENSE_BASE |
WITHHOLDING_L | WITHHOLDING_L |
5 | CURRENCY_GAIN | GAIN_CURRENCY | GAIN_CURRENCY |
SECURITY_GAIN | GAIN_SWAP_B | GAIN_SWAP_B |
TOTAL_GAIN_LOCAL | GAIN_SWAP_L | GAIN_SWAP_L |
TOTAL_GAIN | (no fields) | (no fields) |
ST_GAIN_SEC_L |
ST_GAIN_SEC_B |
ST_GAIN |
ST_GAIN_CRRCY |
LT_GAIN_SEC_L |
LT_GAIN_SEC_B |
LT_GAIN |
LT_GAIN_CRRCY |
GAIN_CRRCY_988 |
6 | CURRENCY_LOSS | LOSS_CURRENCY | LOSS_CURRENCY |
SECURITY_LOSS | LOSS_SWAP_B | LOSS_SWAP_B |
TOTAL_LOSS | LOSS_SWAP_L | LOSS_SWAP_L |
TOTAL_LOSS_LOCAL | (no fields) | (no fields) |
ST_LOSS_SEC_L |
ST_LOSS_SEC_B |
ST_LOSS |
ST_LOSS_CRRCY |
LT_LOSS_SEC_L |
LT_LOSS_SEC_B |
LT_LOSS |
LT_LOSS_CRRCY (no signage logic currently) |
LOSS_CRRCY_988 (no signage logic currently) |
7 | ACCRUED_INTEREST | INCOME | INCOME |
BASEINTERESTADJ | INCOME_AMOUNT_BASE | INCOME_AMOUNT_BASE |
CLS_AMORT_LOCAL | (no fields) | (no fields) |
CLS_AMORT_BASE |
CLS_OID_L |
CLS_OID_B |
CLS_ILB_INC_LTD_LOCAL |
CLS_ILB_INC_LTD_BASE |
8 | (no fields) | UNITS | UNITS |
...