Data Table for Distribution Adjustments
- Natalie Gesin (Deactivated)
- Pamela Totas (Deactivated)
- Kinga Huszno
- Former user (Deleted)
The following table describes the required and optional data fields for Distribution Adjustments.
Tag # – Tag Name | Required/Optional | Data Type | Value/Description of Field |
|---|---|---|---|
55 – Event Type | Required | CHAR | ADD_DIST_LOG used for add and QRY_DIST_LOG used for update, for message stream processing. |
1164 – Entity Name | CHAR (30) | Lookup on the Entity Name. Either Entity Name or Entity ID (1163) is required. Additional fields needed for processing are returned by the lookup. | |
1163 – Entity ID | CHAR (8) | Lookup on Entity ID. Either Entity ID or Entity Name (1164) is required. Additional fields needed for processing are returned by the lookup. | |
9153 – Panel MC_MODE Option | CHAR | Defaults to MC_MODE. In MC mode, several tag validation/lookups are suppressed in the panel to improve processing throughput. You must view the rule to locate each case MC mode is used to bypass lookups and validations. | |
1085 – Security Lookup Option | CHAR | Defaults to SECURITY_ID_EXACT. | |
1233 – Xref Security ID | CHAR (100) | Lookup based on Xref Type and Xref Security ID. Additional fields needed for processing are returned by the lookup. | |
1234 – Xref Security ID Type | CHAR (30) | Xref Security ID Type, that is, CUSIP, SEDOL, ISIN, and so on. Must exist in the database as a valid Security ID type. | |
34 – Share Class | VARCHAR2(10) | ||
182 – Class Event ID | CHAR | ||
36 – Accounting Date | DATE | ||
4733 – Monthly Accounting Period Date | DATE | ||
731 – Record Date | DATE | ||
65 – Ex Date | DATE | ||
1119 – Payment Date | DATE | ||
732 –Reinvestment Date | DATE | ||
781 – Income Distribution Amount | MONEYB | ||
783 – Shortterm Distribution Amount | MONEYB | ||
785 – Longterm Distribution Amount | MONEYB | ||
27 – Lot Selection Method | VARCHAR2 (5) | ||
744 – Distribution Category | CHAR |
Â