...
Utilized Fields for EML Calculated ID Logic |
|
|
|
| |
|
| Universal ID for transaction record | ID on a cancel trade that will link back to the calcTransactionId | ID that links the transaction record together including during rollback and replay |
|
| Occurs once in a database | Occurs once in a database | Can occur many times in database |
|
|
calcTransactionId | calcCancelTransactionId | calcMasterTransactionId | ||
|
|
|
|
|
TRADE.ACCT_BASIS |
|
X |
X |
x
X |
TRADE.ENTITY_ID |
|
X |
X |
X |
TRADE.EVENT_SEQUENCE |
|
X |
x
X |
|
TRADE.RECORD_TYPE |
|
X |
x
X |
|
TRADE.SECURITY_ALIAS |
|
X |
X |
X |
TRADE.STAR_TAG25 |
|
X |
x
x
X | X |
TRADE.STAR_TAG26 |
|
X |
X |
|
TRADE.TO_ACCOUNT |
|
X |
X |
|
TRADE.TO_LONG_SHORT_INDICATOR |
|
X |
x
x
X | X |
TRADE.TO_SECURITY_ALIAS |
|
x
x
X | X |
|
TRADE.TRANS_CODE |
|
x
x
X | X |
|
TRADE_DETAIL.LONG_SHORT_INDICATOR |
|
x
x
X | X |
| ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
IncludeExtendedDetails must equal Y or ALL to get |
|
|
|
|
record_type 350 and 450 indicate open and close adjustments for corporate actions |
|
|
|
| |
Order of included elements in calcTransactionId | Max Character Length | calcTransactionId | calcTransactionId | calcTransactionId |
|
|
EnhanceCalcTransactionId = N | EnhanceCalcTransactionId = Y, record_type = 350 or 450 | EnhanceCalcTransactionId = Y, record_type != 350 or 450 |
TRADE.ACCT_BASIS | 5 |
X |
X |
X |
TRADE.ENTITY_ID | 8 |
X |
X |
X |
TRADE.SECURITY_ALIAS | 38 |
X |
X |
X |
TRADE_DETAIL.LONG_SHORT_INDICATOR | 1 |
X |
x
x
X | X |
TRADE.STAR_TAG25 | 255 |
X |
x
x
X | X | |
TRADE.STAR_TAG26 | 255 |
|
x
X |
|
TRADE.EVENT_SEQUENCE | 38 |
X |
X |
x
X |
TRADE.TO_ACCOUNT | 8 |
X |
x
x
X | X |
TRADE.TO_SECURITY_ALIAS | 38 |
X |
X |
X |
TRADE.TO_LONG_SHORT_INDICATOR | 1 |
X |
X |
x
X |
Static Value - #C | 2 |
X |
X |
X | |
|
|
394 | 649 | 394 |
Order of included elements in calcCancelTransactionId |
| calcCancelTransactionId | calcCancelTransactionId | calcCancelTransactionId |
|
|
EnhanceCalcTransactionId = N | EnhanceCalcTransactionId = Y, record_type = 350 or 450 | EnhanceCalcTransactionId = Y, record_type != 350 or 450 |
TRADE.ACCT_BASIS | 5 |
X |
x
x
X | X |
TRADE.ENTITY_ID | 8 |
X |
X |
X |
TRADE.SECURITY_ALIAS | 38 |
X |
x
x
X | X |
TRADE_DETAIL.LONG_SHORT_INDICATOR | 1 |
X |
x
x
X | X |
TRADE.STAR_TAG25 | 255 |
X |
X |
x
X |
TRADE.STAR_TAG26 | 255 |
|
x
X |
|
TRADE.EVENT_SEQUENCE | 38 |
X |
X |
x
X |
TRADE.TO_ACCOUNT | 8 |
X |
x
x
X | X |
TRADE.TO_SECURITY_ALIAS | 38 |
X |
x
x
X | X |
TRADE.TO_LONG_SHORT_INDICATOR | 1 |
X |
X |
X | |
|
|
392 | 647 | 392 |
Order of included elements in calcMasterTransactionId |
| calcMasterTransactionId | calcMasterTransactionId | calcMasterTransactionId |
|
|
EnhanceCalcTransactionId = N | EnhanceCalcTransactionId = Y, record_type = 350 or 450 | EnhanceCalcTransactionId = Y, record_type != 350 or 450 |
TRADE.ACCT_BASIS | 5 |
|
X |
X |
TRADE.ENTITY_ID | 8 |
|
x
x
X | X | |
TRADE.SECURITY_ALIAS | 38 |
|
x
x
X | X | |
TRADE_DETAIL.LONG_SHORT_INDICATOR | 1 |
|
x
x
X | X |
TRADE.STAR_TAG25 | 255 |
X |
X |
x
X | |
|
|
255 | 307 | 307 |
...