Cash processing is set up for MISCINC/MISCEXP, MISCINCADJ/MISCEXPADJ, and CONTRIBUTION/WITHDRAWAL processing against a specific currency, that is, USD, GBP, CAD, and so on. Asset specific cash processing has not been defined through the message stream. Through the message stream, the Receivable/Payable event (tag 1827) does not have to be defined. If you wish to make a manual entry of the same Receivable/Payable event, the event must be defined.
...
The following table describes the required and optional data fields for Miscellaneous Cash Transactions.
Tag # – Tag Name | Required/Optional | Date Type | Value/Description of Field |
|---|---|---|---|
55– Event Type | Required | CHAR | Defaults on panel. Used by message stream for identification of event. Used for STAR processing. Must be one of the following: |
1163 – Entity ID | Required – either tag 1163 or tag 1164 must be sent in | CHAR (8) | The entity identification code. |
1164 – Entity Name | Required | CHAR (30) | The name of the portfolio/composite. |
35 – Trade Date | Required | DATE | Trade date the cash event is to be posted/processed. |
62 – Cash Category | Required – used in reporting | CHAR | Classification of cash. Must be one of the following: |
13 – Cash Symbol | Required | CHAR (100) | Currency the event is to be processed against. Must be a valid STAR 3 character currency code. |
1827 – Rec Pay Event Type | Required – used in reporting | CHAR | Reason for the cash event. Examples include Miscellaneous Interest Income, Current Capital Subscriptions, Accounting Fees, Legal Fees, and so on. |
40 – Local Net Amount | Required | NUMBER(38,12) | Local amount of the event. |
87 – FX Rates | Required | DEC | Exchange rate being used on the traded event. |
478 – Base Net Amount | Required | MONEYB | Base amount of the event. |
37 – Settlement Date | Required | DATE | Date that the cash event is to settle. |
53 – Cash Event Type | Required | CHAR | Used by STAR cash processing. This tag is the key to defining if the event is an increase or decrease of cash: |
58 – Settle Trade Indicator | Optional | VARCHAR2 (2) | Valid Values: |
761 – Original Trade Ticket Number | Optional | VARCHAR2 (55) | Original trade ticket number |
56– Transaction Notes | Optional | VARCHAR2(255) | Transaction notes |
25 – Event ID | Optional | VARCHAR2(55) | If null, message stream assigns a unique event ID. Used in cancel processing. |
1828 – Offset to Cost Account Description | Optional | CHAR | Cost offset ledger account description |
3695 – Pending Trade Flag | Optional | CHAR | Pending trade flag |
5032 – Target Original Event ID | Optional | CHAR | Target original event ID |
12392 – Performance Effective Date |
DATE | Performance effective date of cash flows. |