Anchor | ||||
---|---|---|---|---|
|
NOTE:
Info | ||
---|---|---|
| ||
For futures and option contracts, the creation of the synthetic security is suppressed when tag 1081 is NONE. |
For change processing which bypasses the Eagle Accounting core validations, such as records loaded for use with Performance Measurement, you must add tag 1081 to the record with the value NONE. The following fields are the only required fields when using this option:
...
The following table describes the optional data fields for SMF related information.
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 |