Warehouse Disposal Lots: Calculated IDs
- Nancy Cohn (Deactivated)
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 |
|