...
The following table describes the required and optional data fields for SMF Forward Contracts.
Tag # – Tag Name | Required/ Optional | Data Type | Value/Description of Field |
|---|---|---|---|
1076 – Update Indicator | Required | CHAR | Y/N indicator used within message stream process. N = NEW ASSET is the only valid value for forwards. |
55 – Event Type | Required – must be ADDSECMASTER | CHAR | Used by message stream processing. |
1257 – Transaction Type | Optional | CHAR (30) | Switch used restrict database updates. Options include: |
1432 – Primary Asset ID Type | Required | CHAR (30) | Security identifier type (CUSIP, ISIN, SEDOL) |
14 – Primary Asset ID | Required | CHAR (100) | Security identifier. |
11 – Investment Type | Optional | CHAR (4) | Required – defaults at panel level to FWD |
3931 – Processing Security Type | Required – defaults at panel level | VARCHAR2 (15) | Valid values: FWXXXX = Forward Contract |
363 – Sell Currency | Required | CHAR | 3 character currency code value. |
313 – Buy Currency | Required | CHAR | 3 character currency code value. |
12 – Quantity Type | Required | CHAR (12) | Defaults at panel level to CURRENCY. |
18 – Price Multiplier | Required | NUMBER (28,12) | Defaults at panel level to 1. Used by STAR processing. |
19 – Quantity Scale | Required | NUMBER (28,12) | Defaults at panel level to 1. Used by STAR processing. |
82 – Security Type | Optional | CHAR (15) | Used for reporting – Code Value. |
1464 – Sub Security Type | Optional | CHAR (15) | Used for reporting – Code Value. |
1186 – Price Currency | Required | CHAR (3) | 3 character currency Code Value. |
38 – Maturity Date | Required | DATE | Date on which the contract matures. |
3913 – Match Broker Indicator | Required | VARCHAR2 (3) | Valid values: Y = Yes, contract is unique by broker, N = No, contract is not unique by broker |
676 – Forward Broker Code | Conditionally Required | CHAR (15) | Required if tag 3913 = Y. Broker Code Value. |
11043 – Inactive Flag | Optional | VARCHAR2 (255) | Valid values: Y = Yes, N = No |
2817 – Cost Basis Rule Type | Optional | VARCHAR2(20) | Used by STAR processing. |
3998 – Maturity Delay Days Type | Optional | VARCHAR2 (1) | Maturity Delay Days Type |
3999 – Coupon Delay Days Type | Optional | VARCHAR2 (1) | Coupon Delay Days Type |
5076 – Last Trade Date | Optional | DATE | Last Trade Date |
5089 – Legal Entity Indicator (LEI) | Optional | VARCHAR2 (20) | Alphameric LEI assignment for this security. |
8501 – Point Size | Optional | NUMBER (38,12) | Value of the one (1) point movement in a future position published by the exchange; used for Insurance regulatory reporting. |