Note
- 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 for certain numeric field values extracted. This includes changes applied on the step of calculation of their value:
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).
Signage logic for Trade SETTLEMENT_AMOUT and SETTLE_AMOUNT_BASE is enabled with the additional parameter 'SettlementSignageFlag' set to Y.
Field Group Number | Warehouse Trade Fields | Traded CA Fields | Settled CA Fields |
---|---|---|---|
1 | NET_CASH EagleML/WarehouseTransaction/warehouseTrade/netAmountLocal | AMOUNT EagleML/AccountingTransaction/tradedCashActivity/amount | AMOUNT EagleML/AccountingTransaction/settledCashActivity/amount |
TRADE_BASE_AMOUNT | NET_AMOUNT_BASE EagleML/AccountingTransaction/tradedCashActivity/netAmountBase | NET_AMOUNT_BASE EagleML/AccountingTransaction/settledCashActivity/netAmountBase | |
SETTLEMENT_AMOUNT EagleML/WarehouseTransaction/warehouseTrade/settlementAmount | SETTLE_AMOUNT_LOCAL EagleML/AccountingTransaction/tradedCashActivity/settleAmountLocal | SETTLE_AMOUNT_LOCAL EagleML/AccountingTransaction/settledCashActivity/settleAmountLocal | |
REC_PAY_AMT_B EagleML/AccountingTransaction/tradedCashActivity/recPayAmountBase | REC_PAY_AMT_B EagleML/AccountingTransaction/settledCashActivity/recPayAmountBase | ||
REC_PAY_AMT_L EagleML/AccountingTransaction/tradedCashActivity/recPayAmountLocal | REC_PAY_AMT_L EagleML/AccountingTransaction/settledCashActivity/recPayAmountLocal | ||
2 | COST_BASE EagleML/WarehouseTransaction/warehouseTrade/costBase | (no fields) | (no fields) |
COST_LOCAL EagleML/WarehouseTransaction/warehouseTrade/costLocal | |||
ORIG_ACQ_COST_BASE | |||
ORIG_ACQ_COST_LOCAL EagleML/WarehouseTransaction/warehouseTrade/originalAcquisitionCostLocal | |||
PAR_OR_SHARES EagleML/WarehouseTransaction/warehouseTrade/originalQuantity | |||
3 | PRINCIPAL EagleML/WarehouseTransaction/warehouseTrade/principal | PRINCIPAL EagleML/AccountingTransaction/tradedCashActivity/principal | PRINCIPAL EagleML/AccountingTransaction/settledCashActivity/principal |
PRINCIPAL_BASE EagleML/WarehouseTransaction/warehouseTrade/principalB | PRINCIPAL_AMOUNT_BASE EagleML/AccountingTransaction/tradedCashActivity/principalAmountBase | PRINCIPAL_AMOUNT_BASE EagleML/AccountingTransaction/settledCashActivity/principalAmountBase | |
DIRTY_PRINCIPAL EagleML/WarehouseTransaction/warehouseTrade/dirtyPrincipalLocal | |||
DIRTY_PRINCIPAL_BASE | |||
4 | BASE COMMISSION AMOUNT EagleML/WarehouseTransaction/warehouseTrade/baseCommissionAmount | COMM_AMT_B EagleML/AccountingTransaction/tradedCashActivity/commAmountBase | COMM_AMT_B EagleML/AccountingTransaction/settledCashActivity/commAmountBase |
LOCAL_COMMISSION_AMOUNT EagleML/WarehouseTransaction/warehouseTrade/localCommissionAmount | COMM_AMT_L EagleML/AccountingTransaction/tradedCashActivity/commAmountLocal | COMM_AMT_L EagleML/AccountingTransaction/settledCashActivity/commAmountLocal | |
EXCHANGE_FEE EagleML/WarehouseTransaction/warehouseTrade/exchangeFee | OTHER_FEE_B EagleML/AccountingTransaction/tradedCashActivity/otherFeeBase | OTHER_FEE_B EagleML/AccountingTransaction/settledCashActivity/otherFeeBase | |
EXCHANGE_FEE_BASE EagleML/WarehouseTransaction/warehouseTrade/exchangeFeeBase | OTHER_FEE_LOCAL EagleML/AccountingTransaction/tradedCashActivity/otherFeeLocal | OTHER_FEE_LOCAL EagleML/AccountingTransaction/settledCashActivity/otherFeeLocal | |
OTHER_FEE EagleML/WarehouseTransaction/warehouseTrade/otherFee | RECLAIM_AMOUNT_BASE EagleML/AccountingTransaction/tradedCashActivity/reclaimAmountBase | RECLAIM_AMOUNT_BASE EagleML/AccountingTransaction/settledCashActivity/reclaimAmountBase | |
OTHER_FEE_BASE EagleML/WarehouseTransaction/warehouseTrade/otherFeeBase | RECLAIM_L EagleML/AccountingTransaction/tradedCashActivity/reclaimLocal | RECLAIM_L EagleML/AccountingTransaction/settledCashActivity/reclaimLocal | |
SEC_FEES EagleML/WarehouseTransaction/warehouseTrade/secFee | SEC_FEE EagleML/AccountingTransaction/tradedCashActivity/secFee | SEC_FEE EagleML/AccountingTransaction/settledCashActivity/secFee | |
SEC_FEES_BASE EagleML/WarehouseTransaction/warehouseTrade/secFeesBase | SEC_FEE_B EagleML/AccountingTransaction/tradedCashActivity/secFeeBase | SEC_FEE_B EagleML/AccountingTransaction/settledCashActivity/secFeeBase | |
TAXES EagleML/WarehouseTransaction/warehouseTrade/taxAmountLocal | STAMP_DUTY_TAX_B EagleML/AccountingTransaction/tradedCashActivity/stampDutyTaxBase | STAMP_DUTY_TAX_B EagleML/AccountingTransaction/settledCashActivity/stampDutyTaxBase | |
TAXES_BASE EagleML/WarehouseTransaction/warehouseTrade/taxesBase | STAMP_DUTY_TAX_L EagleML/AccountingTransaction/tradedCashActivity/stampDutyTaxLocal | STAMP_DUTY_TAX_L EagleML/AccountingTransaction/settledCashActivity/stampDutyTaxLocal | |
TAX_AMT_B EagleML/AccountingTransaction/tradedCashActivity/taxAmountBase | TAX_AMT_B EagleML/AccountingTransaction/settledCashActivity/taxAmountBase | ||
TAX_AMT_L EagleML/AccountingTransaction/tradedCashActivity/taxAmountLocal | TAX_AMT_L EagleML/AccountingTransaction/settledCashActivity/taxAmountLocal | ||
TAX_EXPENSE_BASE EagleML/AccountingTransaction/tradedCashActivity/taxExpenseBase | TAX_EXPENSE_BASE EagleML/AccountingTransaction/settledCashActivity/taxExpenseBase | ||
WITHHOLDING_L EagleML/AccountingTransaction/tradedCashActivity/withholdingLocal | WITHHOLDING_L EagleML/AccountingTransaction/settledCashActivity/withholdingLocal | ||
5 | CURRENCY_GAIN | GAIN_CURRENCY EagleML/AccountingTransaction/tradedCashActivity/currencyGain | GAIN_CURRENCY EagleML/AccountingTransaction/settledCashActivity/currencyGain |
SECURITY_GAIN | GAIN_SWAP_B EagleML/AccountingTransaction/tradedCashActivity/gainSwapBase | GAIN_SWAP_B EagleML/AccountingTransaction/settledCashActivity/gainSwapBase | |
TOTAL_GAIN_LOCAL EagleML/WarehouseTransaction/warehouseTrade/totalGainLocal | GAIN_SWAP_L EagleML/AccountingTransaction/tradedCashActivity/gainSwapLocal | GAIN_SWAP_L EagleML/AccountingTransaction/settledCashActivity/gainSwapLocal | |
TOTAL_GAIN EagleML/WarehouseTransaction/warehouseTrade/totalGain | (no fields) | (no fields) | |
ST_GAIN_SEC_L | |||
ST_GAIN_SEC_B | |||
ST_GAIN EagleML/WarehouseTransaction/warehouseTrade/stGain | |||
ST_GAIN_CRRCY EagleML/WarehouseTransaction/warehouseTrade/stGainCurrency | |||
LT_GAIN_SEC_L EagleML/WarehouseTransaction/warehouseTrade/ltLossSecLocal | |||
LT_GAIN_SEC_B EagleML/WarehouseTransaction/warehouseTrade/ltLossSecBase | |||
LT_GAIN EagleML/WarehouseTransaction/warehouseTrade/ltGain | |||
LT_GAIN_CRRCY EagleML/WarehouseTransaction/warehouseTrade/ltGainCurrency | |||
GAIN_CRRCY_988 EagleML/WarehouseTransaction/warehouseTrade/gainCurrency988 | |||
6 | CURRENCY_LOSS EagleML/WarehouseTransaction/warehouseTrade/lossCurrency | LOSS_CURRENCY EagleML/AccountingTransaction/tradedCashActivity/currencyLoss | LOSS_CURRENCY EagleML/AccountingTransaction/settledCashActivity/currencyLoss |
SECURITY_LOSS | LOSS_SWAP_B EagleML/AccountingTransaction/tradedCashActivity/lossSwapBase | LOSS_SWAP_B EagleML/AccountingTransaction/settledCashActivity/gainSwapBase | |
TOTAL_LOSS EagleML/WarehouseTransaction/warehouseTrade/totalLoss | LOSS_SWAP_L EagleML/AccountingTransaction/tradedCashActivity/lossSwapLocal | LOSS_SWAP_L EagleML/AccountingTransaction/settledCashActivity/lossSwapLocal | |
TOTAL_LOSS_LOCAL EagleML/WarehouseTransaction/warehouseTrade/totalLossLocal | (no fields) | (no fields) | |
ST_LOSS_SEC_L EagleML/WarehouseTransaction/warehouseTrade/stLossSecLocal | |||
ST_LOSS_SEC_B EagleML/WarehouseTransaction/warehouseTrade/stLossSecBase | |||
ST_LOSS EagleML/WarehouseTransaction/warehouseTrade/stLoss | |||
ST_LOSS_CRRCY EagleML/WarehouseTransaction/warehouseTrade/stLossCurrency | |||
LT_LOSS_SEC_L EagleML/WarehouseTransaction/warehouseTrade/ltLossSecLocal | |||
LT_LOSS_SEC_B EagleML/WarehouseTransaction/warehouseTrade/ltLossSecBase | |||
LT_LOSS EagleML/WarehouseTransaction/warehouseTrade/ltLoss | |||
LT_LOSS_CRRCY (no signage logic currently) EagleML/WarehouseTransaction/warehouseTrade/ltLossCurrency | |||
LOSS_CRRCY_988 (no signage logic currently) | |||
7 | ACCRUED_INTEREST EagleML/WarehouseTransaction/warehouseTrade/accruedInterest | INCOME EagleML/AccountingTransaction/tradedCashActivity/income | INCOME EagleML/AccountingTransaction/settledCashActivity/income |
BASEINTERESTADJ EagleML/WarehouseTransaction/warehouseTrade/interestAdjBase | INCOME_AMOUNT_BASE EagleML/AccountingTransaction/tradedCashActivity/incomeAmountBase | INCOME_AMOUNT_BASE EagleML/AccountingTransaction/settledCashActivity/incomeAmountBase | |
CLS_AMORT_LOCAL EagleML/WarehouseTransaction/warehouseTrade/clsAmortLocal | (no fields) | (no fields) | |
CLS_AMORT_BASE EagleML/WarehouseTransaction/warehouseTrade/clsAmortBase | |||
CLS_OID_L EagleML/WarehouseTransaction/warehouseTrade/clsOidLoca | |||
CLS_OID_B EagleML/WarehouseTransaction/warehouseTrade/clsOidBase | |||
CLS_ILB_INC_LTD_LOCAL | |||
CLS_ILB_INC_LTD_BASE EagleML/WarehouseTransaction/warehouseTrade/clsIlbIncLtdBase | |||
8 | (no fields) | UNITS EagleML/AccountingTransaction/tradedCashActivity/units | UNITS EagleML/AccountingTransaction/settledCashActivity/units |
9 | TRADE_AMOUNT EagleML/WarehouseTransaction/warehouseTrade/tradeAmount | (no fields) | (no fields) |
NETSETTLEAMT EagleML/WarehouseTransaction/warehouseTrade/netsettleamt | |||
TOTAL_AMORT_LOCAL, EagleML/WarehouseTransaction/warehouseTrade/totalAmortLocal | |||
TOTAL_AMORT_BASE EagleML/WarehouseTransaction/warehouseTrade/totalAmortBase |