| 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 fieldsfield values extracted. 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.inc (if the value is 'N' or not specified (default), numeric fields are presented as stored 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 |
...