Data Table for Cancel Cash Entitlements

The Cancel Cash rule is used to cancel Contribution, Withdrawal, Miscellaneous Income, Miscellaneous Expense, and Spot transactions – as well as Conversion Dividend, Interest, and Reclaim transactions. Transactions must be canceled by Event ID.

You can invoke the Cancel Cash rule from EAGLE_DEFAULT_IN_STAR/CSV_CASH. To cancel a Cash Entitlement, tag 55/F55 must be set to CANCELCASH, or CANCELCASH_CONV to cancel cash conversion transactions.

To review the results of processing in the database, you can use the Position Viewer application to submit a query to view entity positions. To access this tool from the Accounting Center window, click Reporting in the left navigation, and then double click Research, Data Viewer, and Position Viewer. The Canceled Cash Entitlements appear under the Cash folder in the respective Cancel rows.

The following table describes the required and optional data fields for Cancel Cash Entitlements.

Tag # – Tag Name	Required/Optional	Data Type	Value/Description of Field

Tag # – Tag Name	Required/Optional	Data Type	Value/Description of Field
55 – Event Type	Required – must be CANCELCASH	CHAR	Used for message stream processing.
1163 – Entity ID	Required	CHAR (8)	Lookup on Entity ID. Either Entity ID or Entity Name (1164) is required. Additional fields needed for processing are returned by lookup.
1164 – Entity Name	Required	CHAR (30)	Lookup on Entity Name. Either Entity Name or Entity ID (1163) is required. Additional fields needed for processing are returned by lookup.
21 – Accounting Basis	Optional	VARCHAR2(5)	Populated through the lookup on Entity. Can be overridden if passed in on the event.
7004 – Cancel Trade By	Required	CHAR	The identifier used to determine the cash entitlement to cancel. Options include: E – Event ID Lookup (tag 1076) T – Target Trade Ticket Number (tag 762)
15 – Long/Short Indicator	Required	CHAR	Whether the position that created the cash entitlement is long or short. Options include: L – Long S – Short
220 – Begin Date	Required	DATE	Original Trade Date for Cash Entitlement. If tag 35 is on the message and tag 220 is null, tag 35 value will be mapped to this field.
221 – End Date	Required	DATE	Original Trade Date for Cash Entitlement. If tag 35 is on the message and tag 221 is null, tag 35 value will be mapped to this field.
2283 – Message Center Switch for CXL Acct Date	Optional	CHAR	Must be set to Y to cancel a cash entitlement in a closed accounting period. This uses the next available open accounting date as the Cancel Accounting Date (tag 36).
762 – Target Trade Ticket Number	Required when tag 7004 = T	CHAR	The Trade Ticket (tag 761) number of the entitlement to be canceled.
1076 – Event ID Lookup	Required when tag 7004 = E	CHAR	The Event ID (tag 25) of the entitlement to be canceled.
1233 – Cross Reference ID	Optional	CHAR (100)	The security identifier associated with the cancel transaction.