Warehouse Disposal Lots: Calculated IDs
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 |  |
Â