Utilized Fields for EML Calculated ID Logic |
|
|
|
|
|
|
ID that links the transaction record together including during rollback and replay |
|
|
|
|
Can occur many times in database |
|
|
|
|
calcMasterTransactionId |
calcMasterTransactionId |
|
|
|
|
|
|
TRADE.ACCT_BASIS |
|
x |
x |
|
DISPOSAL_LOTS.ENTITY_ID |
|
x |
x |
|
DISPOSAL_LOTS.SECURITY_ALIAS |
|
x |
x |
|
DISPOSAL_LOTS.LONG_SHORT_INDICATOR |
|
x |
x |
|
DISPOSAL_LOTS.CLS_OPEN_EVENT_ID |
|
x |
|
|
TRADE.STAR_TAG25 |
|
|
x |
|
|
|
|
|
|
IncludeExtendedDetails must equal Y or ALL |
|
|
|
|
Order of included elements in calcMasterTransactionId |
Max Character Length |
EnhanceCalcTransactionId = N |
EnhanceCalcTransactionId = Y |
|
|
|
|
|
|
TRADE.ACCT_BASIS |
5 |
|
x |
|
DISPOSAL_LOTS.ENTITY_ID |
8 |
|
x |
|
DISPOSAL_LOTS.SECURITY_ALIAS |
38 |
|
x |
|
DISPOSAL_LOTS.LONG_SHORT_INDICATOR |
1 |
|
x |
|
DISPOSAL_LOTS.CLS_OPEN_EVENT_ID |
255 |
|
x |
|
|
|
0 |
307 |
|
IncludeExtendedDetails must equal Y or ALL |
|
|
|
|
Order of included elements in calcMasterCloseTransactionId |
|
EnhanceCalcTransactionId = N |
EnhanceCalcTransactionId = Y |
|
|
|
|
|
|
TRADE.ACCT_BASIS |
5 |
|
x |
|
DISPOSAL_LOTS.ENTITY_ID |
8 |
|
x |
|
DISPOSAL_LOTS.SECURITY_ALIAS |
38 |
|
x |
|
DISPOSAL_LOTS.LONG_SHORT_INDICATOR |
1 |
|
x |
|
TRADE.STAR_TAG25 |
255 |
|
x |
|
|
|
0 |
307 |
|
Manage space
Manage content
Integrations