Data Table for Miscellaneous Cash Transactions
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Former user (Deleted)
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 number of required variables has been kept to a minimum. The following data table shows the tag/values required for processing.
To review the results of processing in the database, you can use the Position Viewer application to submit a query to view the holdings and transactions for each entity processed. 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 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. |
Â