Fields Affected by Signage Logic

Owned by Natalie Gesin (Deactivated)
Last updated: Mar 21, 2022 by Larry Ackerman
1 min read

Note

  • Signage Logic can be applied only to extracts

  • Currently available for Warehouse Trade (WRHSTRADEEXTRACT), Traded Cash Activity (TRADEDCAEXTRACT), and Settled Cash Activity (SETTLEDCAEXTRACT) 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:

 Click to expand an example of alternative calculation

AMOUNT field in Traded CA (if 'EnableSignageLogic' = 'Y'):

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).
Signage logic for Trade SETTLEMENT_AMOUT and SETTLE_AMOUNT_BASE is enabled with the additional parameter 'SettlementSignageFlag' set to Y.

Field Group NumberWarehouse Trade FieldsTraded CA FieldsSettled CA Fields
1NET_CASH 
EagleML/WarehouseTransaction/warehouseTrade/netAmountLocal		AMOUNT
EagleML/AccountingTransaction/tradedCashActivity/amount		AMOUNT
EagleML/AccountingTransaction/settledCashActivity/amount

TRADE_BASE_AMOUNT
EagleML/WarehouseTransaction/warehouseTrade/netAmountBase

NET_AMOUNT_BASE
EagleML/AccountingTransaction/tradedCashActivity/netAmountBase		NET_AMOUNT_BASE
EagleML/AccountingTransaction/settledCashActivity/netAmountBase
SETTLE_AMOUNT_BASE
EagleML/WarehouseTransaction/warehouseTrade/settleAmountBase

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
2COST_BASE
EagleML/WarehouseTransaction/warehouseTrade/costBase		(no fields)(no fields)
COST_LOCAL
EagleML/WarehouseTransaction/warehouseTrade/costLocal

ORIG_ACQ_COST_BASE
EagleML/WarehouseTransaction/warehouseTrade/originalAcquisitionCostBase

ORIG_ACQ_COST_LOCAL
EagleML/WarehouseTransaction/warehouseTrade/originalAcquisitionCostLocal
PAR_OR_SHARES
EagleML/WarehouseTransaction/warehouseTrade/originalQuantity
3PRINCIPAL
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
EagleML/WarehouseTransaction/warehouseTrade/dirtyPrincipalBase



4BASE 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
EagleML/WarehouseTransaction/warehouseTrade/gainCurrency

GAIN_CURRENCY
EagleML/AccountingTransaction/tradedCashActivity/currencyGain		GAIN_CURRENCY
EagleML/AccountingTransaction/settledCashActivity/currencyGain

SECURITY_GAIN
EagleML/WarehouseTransaction/warehouseTrade/gainSecurityLocal

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
EagleML/WarehouseTransaction/warehouseTrade/stGainSecLocal

ST_GAIN_SEC_B
EagleML/WarehouseTransaction/warehouseTrade/stGainSecBase

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
6CURRENCY_LOSS
EagleML/WarehouseTransaction/warehouseTrade/lossCurrency		LOSS_CURRENCY
EagleML/AccountingTransaction/tradedCashActivity/currencyLoss		LOSS_CURRENCY
EagleML/AccountingTransaction/settledCashActivity/currencyLoss

SECURITY_LOSS
EagleML/WarehouseTransaction/warehouseTrade/lossSecurityLocal

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)
EagleML/WarehouseTransaction/warehouseTrade/lossCurrency988

7ACCRUED_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
EagleML/WarehouseTransaction/warehouseTrade/clsIlbIncLtdLocal

CLS_ILB_INC_LTD_BASE
EagleML/WarehouseTransaction/warehouseTrade/clsIlbIncLtdBase
8(no fields)UNITS
EagleML/AccountingTransaction/tradedCashActivity/units		UNITS
EagleML/AccountingTransaction/settledCashActivity/units
9TRADE_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