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 |
|---|---|---|---|
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. |
1233 – Xref Security ID |
Optional |
CHAR (100) |
The security identifier associated with the cancel transaction. |
220 – Begin Period |
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 – Switch accounting date |
Optional – For setting cxl accounting date |
CHAR |
Y/N To override cancel accounting date |
1076 – Entitlement Event ID |
Required when tag 7004 = E |
CHAR |
The Event ID of the entitlement to be canceled. |
762 – Target Trade Ticket Number |
Required when tag 7004 = T |
CHAR |
The Trade Ticket number of the entitlement to be canceled |
7004 – Cancel Trade By |
Required |
CHAR |
The identifier used to determine the cash entitlement to cancel. Options include: |
Add Comment