Data Tables for Cost Basis Adjustments
- Natalie Gesin (Deactivated)
- Pamela Totas (Deactivated)
- Kinga Huszno
- Former user (Deleted)
This section describes the Cost Basis Adjustment and Cancel Cost Basis Adjustment data fields.
Cost Basis Adjustment Data Table
To process a Cost Basis Adjustment through the message stream, tag 55/F55 must equal INCROPEN for increases to Cost and to DECROPEN for decreases to Cost, along with other data elements shown in the data table that follows. The adjustments made by this process either add or subtract from the Current Cost Amount.
The following table describes the required and optional data fields for Cost Basis Adjustments.
Tag # – Tag Name | Required/Optional | Data Type | Value/Description of Field |
|---|---|---|---|
55 – Event Type | Required – must be INCROPEN or DECROPEN | CHAR | Used for message stream processing. |
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 the lookup. |
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 the lookup. |
21 – Accounting Basis | Required | VARCHAR2(5) | Accounting Basis for Adjustment. Note: Adjustments can only be processed against non Primary Basis for Conversion transactions. For non Conversion Adjustments, the adjustment must be processed against the primary basis, and is replicated across to the other basis. |
15 – Long/Short Indicator | Required | CHAR | Long or Short Position Indicator. Valid values: |
1234 – Xref Type | Required | CHAR (30) | Xref Security ID Type (i.e. CUSIP, SEDOL, ISIN, etc). Must exist in the database as a valid Security ID type. |
1233 – Xref Security ID | Required | CHAR (100) | Lookup based on Xref Type and Xref Security ID. Additional fields needed for processing are returned by the lookup. |
962 – Open Lot | Required | VARCHAR2 (255) | Trade Ticket Number for the open lot against which the Cost Adjustment is to be made, that is, the target lot. |
35 – Trade Date | Required | DATE | Effective date of the adjustment. A lookup is executed based on the Entity setup for the accounting date to be applied |
50 – Current Cost Adjustment Local | Required | MONEYL | Local amount to either increase or decrease the selected Open Lot Current Cost. |
87 – Local to Base FX Rates | Required | DEC | FX Rates to be used to calculate the Base Adjustment amount. |
478 – Current Cost Adjustment Base | Required | MONEYB | Base amount to either increase or decrease the selected Open Lot Current Cost. |
761 – Trade Ticket Number | Optional | VARCHAR2 (55) | A Reference Number for the Cost Adjustment event being processed. Must be a unique value. This value is used to cancel the Cost Adjustment record through message stream. |
1825 – Offset Account | Required | VARCHAR2(10) | Tag 1825 is a Code Value lookup based on the Short Description for Code Category REC_DEL_ACCTS. |
Cancel Cost Basis Adjustment Data Table
To process a Cancel Cost Basis Adjustment through the message stream, tag 55/F55 must equal CANCADJ, along with the other data elements shown in the data table that follows.
The following table describes the required and optional data fields for Cancel Cost Basis Adjustments.
Tag # – Tag Name | Required/Optional | Data Type | Value/Description of Field |
|---|---|---|---|
55 – Event Type | Required – must be CANCADJ | CHAR | Used for message stream processing. |
1164 – Entity Name | Required | 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 | Required | 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. |
21 – Accounting Basis | Required | VARCHAR2(5) | Accounting Basis for Cancel Adjustment. Note: Cancel Adjustments can only be processed against non Primary Basis for Conversion transactions. For non Conversion Adjustments, the adjustment must be processed against the primary basis, for replication across to the other basis. |
15 – Long/Short Indicator | Required | CHAR | Long or Short Position Indicator. Valid values: |
1234 – Xref Type | Required | 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. |
1233 – Xref Security ID | Required | CHAR (100) | Lookup based on Xref Type and Xref Security ID. Additional fields needed for processing are returned by the lookup. |
762 – Target Trade Ticket Number | Required | CHAR | Trade Ticket Number for the Cost Adjustment to be cancelled. |
35 – Trade Date | Optional | DATE | Used to match to the effective date of the cost adjustment. Although this tag is not required, it is recommended that this tag be included on the message to improve the speed of the lookup. |
36 | Required | DATE | Cancel accounting date. |
4733 | Required | DATE | Monthly accounting period date |
1283 | Required | VARCHAR2 (3) | Accounting period status. |
502 | Required | VARCHAR2(30) | Event type of the transaction that was canceled (BUY, SELL, etc.). |
26 | Required | CHAR | Target event identifier. |