Panels, Binds, and Stored Procedures for Cash

Conversion Trades Only

Cash Dividends

The following table lists the rules, panels, binds, and stored procedures used for processing the Open Cash Dividend transactions in the Cash default message stream.

CSV/STAR Rule	Panel	Bind	Procedure
csv- /or/ star- cashdiv.xml	eagle/star/cash/pan-dividendconv.htm	CASHDIV	QUERY_NET_AMOUNT
			INSERT_UPDATE_CASH_POSITION
			INSERT_CASH_ACTIVITY
			INSERT_CASH_ALLOCATION_LOG
			INSERT_CASH_FIN_LOG
			INS_SUB_RED_TRANSACTION
			INS_UPD_CASH_COMMENTS
			POP_DELTA_TRIG_LOG_CASH
			Q_HISTORY_CASH

Coupons

The following table lists the rules, panels, binds, and stored procedures used for processing the unsettled Coupon transactions and traded rows in the message streams.

CSV/STAR Rule	Panel	Bind	Procedure
csv- /or/ star- coupon.xml	eagle/star/cash/pan-pastdueintandreclaim_conv.htm	COUPON	QUERY_NET_AMOUNT
			INSERT_UPDATE_CASH_POSITION
			INSERT_CASH_ACTIVITY
			INSERT_CASH_ALLOCATION_LOG
			INSERT_CASH_FIN_LOG
			INS_SUB_RED_TRANSACTION
			INS_UPD_CASH_COMMENTS
			POP_DELTA_TRIG_LOG_CASH
			Q_HISTORY_CASH

Reclaims

The following table lists the rules, panels, binds, and stored procedures used for processing the unsettled Reclaim transactions and traded rows in the message streams.

CSV/STAR Rule	Panel	Bind	Procedure
csv- /or/ star- reclaim.xml	eagle/star/cash/pan-divreclaimconv.htm	RECLAIM	QUERY_NET_AMOUNT
			INSERT_UPDATE_CASH_POSITION
			INSERT_CASH_ACTIVITY
			INSERT_CASH_ALLOCATION_LOG
			INSERT_CASH_FIN_LOG
			INS_SUB_RED_TRANSACTION
			INS_UPD_CASH_COMMENTS
			POP_DELTA_TRIG_LOG_CASH
			Q_HISTORY_CASH

Miscellaneous Cash Transactions

The following table lists the rules, panels, binds, and stored procedures used for processing the Miscellaneous Cash transactions in the message streams.

CSV/STAR Rule	Panel	Bind	Procedure
csv- /or/ star- cash.xml	eagle/star/cash/pan-cashcontribution.htm	CONTRIBUTION	Q_HISTORY_CASH
			INSERT_UPDATE_CASH_POSITION
			INSERT_CASH_ACTIVITY
			POP_DELTA_TRIG_LOG_CASH
			INSERT_CASH_FIN_LOG
			INS_SUB_RED_TRANSACTION
			INS_UPD_CASH_COMMENTS
			INSERT_CASH_ALLOCATION_LOG
			QUERY_NET_AMOUNT
	eagle/star/cash/pan-miscincome.htm	MISCINC	Same as above.
	eagle/star/cash/pan-cashwithdrawal.htm	WITHDRAWAL	Q_HISTORY_CASH
			INSERT_UPDATE_CASH_POSITION
			INSERT_CASH_ACTIVITY
			POP_DELTA_TRIG_LOG_CASH
			INSERT_CASH_FIN_LOG
			INS_SUB_RED_TRANSACTION
			INS_UPD_CASH_COMMENTS
			INSERT_CASH_ALLOCATION_LOG
			QUERY_NET_AMOUNT
	eagle/star/cash/pan-miscexpense.htm	MISCEXP	INSERT_UPDATE_CASH_POSITION
			INSERT_CASH_ACTIVITY
			INSERT_CASH_ALLOCATION_LOG
			INSERT_CASH_FIN_LOG
			INS_SUB_RED_TRANSACTION
			INS_UPD_CASH_COMMENTS
			POP_DELTA_TRIG_LOG_CASH
			Q_HISTORY_CASH
			QUERY_NET_AMOUNT
			TRIGGER_POST_1DAY_ACCRUAL
			UPD_FEE_PAYMENT_RELEASE_FLAG

Miscellaneous Income/Expense – Asset Specific

The following table lists the rules, panels, binds, and stored procedures used for processing the Miscellaneous Income/Expense – Asset Specific transactions in the message streams.

CSV/STAR Rule	Panel	Bind	Procedure
csv- /or/ star- asset_specific_misc_inc_exp.xml	eagle/star/cash/pan-miscincome-issue-specific.htm	MISCINC	QUERY_NET_AMOUNT
			INSERT_UPDATE_CASH_POSITION
			INSERT_CASH_ACTIVITY
			INSERT_CASH_ALLOCATION_LOG
			INSERT_CASH_FIN_LOG
			INS_SUB_RED_TRANSACTION
			INS_UPD_CASH_COMMENTS
			POP_DELTA_TRIG_LOG_CASH
			Q_HISTORY_CASH
	eagle/star/cash/pan-miscexpense-issue-specific.htm	MISCEXP	INSERT_UPDATE_CASH_POSITION
			INSERT_CASH_ACTIVITY
			INSERT_CASH_ALLOCATION_LOG
			INSERT_CASH_FIN_LOG
			INS_SUB_RED_TRANSACTION
			INS_UPD_CASH_COMMENTS
			POP_DELTA_TRIG_LOG_CASH
			Q_HISTORY_CASH
			QUERY_NET_AMOUNT
			TRIGGER_POST_1DAY_ACCRUAL
			UPD_FEE_PAYMENT_RELEASE_FLAG

Cancel Cash Entitlements

The following table lists the rules, panels, binds, and stored procedures used for processing the Cancel Cash Entitlements transactions in the message streams.

CSV/STAR Rule	Panel	Bind	Procedure
csv- /or/ star- cancelcash.xml	eagle/star/cash/pan-cancelentitlements.htm	CANCELCASH	CANCEL_SUB_RED_TRANSACTION
			INSERT_UPDATE_CASH_POSITION
			INSERT_UPDATE_COST_POSITION
			CUSTODY_CHECK
			INSERT_CASH_ACTIVITY
			INSERT_CASH_ALLOCATION_LOG
			INSERT_CASH_FIN_LOG
			INSERT_ESTAR_VARMGN_LOG
			INSERT_FINANCIAL_EVT
			INSERT_INC_FIN_LOG
			INS_UPD_CASH_COMMENTS
			POPULATE_DELTA_TRIGGER_LOG
			POP_DELTA_TRIG_LOG_CASH
			PPA_LOG_MANUAL_SWEEP
			Q_HISTORY
			Q_HISTORY_CASH
			TRIGGER_FEE_SETT_REVERSAL
			TRIG_AUTO_FEE_CANCEL
			UPDATE_FEE_TRIGGER_STATUS
	eagle/star/cash/pan-canrecpayconv1.htm	CANCELCASH	CANCEL_SUB_RED_TRANSACTION
			INSERT_UPDATE_CASH_POSITION
			INSERT_UPDATE_COST_POSITION
			CUSTODY_CHECK
			INSERT_CASH_ACTIVITY
			INSERT_CASH_ALLOCATION_LOG
			INSERT_CASH_FIN_LOG
			INSERT_ESTAR_VARMGN_LOG
			INSERT_FINANCIAL_EVT
			INS_UPD_CASH_COMMENTS
			POPULATE_DELTA_TRIGGER_LOG
			POP_DELTA_TRIG_LOG_CASH
			PPA_LOG_MANUAL_SWEEP
			Q_HISTORY
			Q_HISTORY_CASH
			TRIGGER_FEE_SETT_REVERSAL
			TRIG_AUTO_FEE_CANCEL
			UPDATE_FEE_TRIGGER_STATUS

back to top