...
Tag # – Tag Name | Required/ Optional | Data Type | Field Name | Table Name | |
|---|---|---|---|---|---|
2504 – Aggregate bond – 1st level | Optional | VARCHAR2(60) | AGG_BOND_L1 | SECMASTER_DETAIL_EXT | |
2505 – Aggregate bond – 2nd level | Optional | CHAR | AGG_BOND_L2 | SECMASTER_DETAIL_EXT | |
2506 – Aggregate bond – 3rd level | Optional | CHAR | AGG_BOND_L3 | SECMASTER_DETAIL_EXT | |
2507 – Aggregate bond – 4th level | Optional | CHAR | AGG_BOND_L4 | SECMASTER_DETAIL_EXT | |
12374 – Industry Classification Benchmark (ICB) sector – 3rd level | Optional | VARCHAR2 (12) | ICB_SECTOR | SECMASTER_DETAIL_EXT | |
12376 – ICB subsector – lowest level | Optional | VARCHAR2 (12) | ICB_SUBSECTOR | SECMASTER_DETAIL_EXT | |
12378 – ICB supersector – 2nd level | Optional | VARCHAR2 (12) | ICB_SUPERSECTOR | SECMASTER_DETAIL_EXT | |
12380 – ICB industry – highest level | Optional | CHAR | ICB_INDUSTRY | SECMASTER_DETAIL_EXT | |
1896 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR1 | SECURITY_MASTER | |
1433 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR2 | SECURITY_MASTER | |
1804 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR3 | SECURITY_MASTER | |
1427 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR4 | SECURITY_MASTER | |
1429 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR5 | SECURITY_MASTER | |
1805 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR6 | SECURITY_MASTER | |
1434 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR7 | SECURITY_MASTER | |
1430 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR8 | SECURITY_MASTER | |
1431 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR9 | SECURITY_MASTER | |
1435 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR10 | SECURITY_MASTER | |
1436 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR11 | SECURITY_MASTER | |
1437 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR12 | SECURITY_MASTER | |
1438 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR13 | SECURITY_MASTER | |
1424 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR14 | SECURITY_MASTER | |
1425 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR15 | SECURITY_MASTER | |
1505 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR1 | SECURITY_MASTER_DETAIL | |
1506 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR2 | SECURITY_MASTER_DETAIL | |
1507 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR3 | SECURITY_MASTER_DETAIL | |
1508 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR4 | SECURITY_MASTER_DETAIL | |
1509 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR5 | SECURITY_MASTER_DETAIL | |
1510 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR6 | SECURITY_MASTER_DETAIL | |
1511 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR7 | SECURITY_MASTER_DETAIL | |
1512 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR8 | SECURITY_MASTER_DETAIL | |
1513 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR9 | SECURITY_MASTER_DETAIL | |
1514 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR10 | SECURITY_MASTER_DETAIL | |
1824 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR11 | SECURITY_MASTER_DETAIL | |
3462 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR12 | SECURITY_MASTER_DETAIL | |
3463 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR13 | SECURITY_MASTER_DETAIL | |
3464 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR14 | SECURITY_MASTER_DETAIL | |
3465 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR15 | SECURITY_MASTER_DETAIL | |
3466 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR16 | SECURITY_MASTER_DETAIL | |
3467 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR17 | SECURITY_MASTER_DETAIL | |
3468 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR18 | SECURITY_MASTER_DETAIL | |
3469 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR19 | SECURITY_MASTER_DETAIL | |
3470 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR20 | SECURITY_MASTER_DETAIL | |
3471 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR21 | SECURITY_MASTER_DETAIL | |
3472 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR22 | SECURITY_MASTER_DETAIL | |
3473 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR23 | SECURITY_MASTER_DETAIL | |
3474 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR24 | SECURITY_MASTER_DETAIL | |
| 1250 – Ex-interest Schedule | CHAR | SCHEDULE_SUB_TYPE | |||
| 3669 – Ex-interest Date | DATE (99) | Ex-interest date. | |||
| 16311 – Ex-interest Processing Flag Interest Coupon Recognition Date | CHAR | EX_INTEREST_COUPON_PROCESSINGRECOGNITION_FLAG DATE | |||
| 3941 – Misc. | INTEGER | EX_DAYS | |||
| 12875 – Non-Deliverable Forward Indicator | CHAR | NDF_INDICATOR | |||
| 16726 - Variable Rate Source | MONEYL (2) | MINIMUM_BALANCE | |||
| 16727 - Variable Rate Flag | CHAR | FLOATING_PRICE_INSTRUMENT |
...