Fields Affected by Signage Logic

  • Signage Logic can be applied only to extracts

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

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 Number

Warehouse Trade Fields

Traded CA Fields

Settled CA Fields

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
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

2

COST_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

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

 

 

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
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

6

CURRENCY_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

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
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

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

Â