Warehouse Open 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 |  |  |
 |  |  |  |  |
POSITION.ACCT_BASIS | Â | X | Â | Â |
POSITION.ENTITY_ID | Â | X | Â | Â |
LOT_LEVEL_POSITION.SECURITY_ALIAS | Â | X | Â | Â |
LOT_LEVEL_POSITION.LONG_SHORT_IND | Â | X | Â | Â |
LOT_LEVEL_POSITION.ORIG_LOT_NUMBER | Â | X | Â | Â |
 |  |  |  |  |
 |  |  |  |  |
IncludeExtendedDetails must equal Y or ALL | Â | Â | Â | Â |
Order of included elements in calcMasterTransactionId | Max Character Length | EnhanceCalcTransactionId = N | EnhanceCalcTransactionId = Y | Â |
 |  |  |  |  |
POSITION.ACCT_BASIS | 5 | Â | X | Â |
POSITION.ENTITY_ID | 8 | Â | X | Â |
LOT_LEVEL_POSITION.SECURITY_ALIAS | 38 | Â | X | Â |
LOT_LEVEL_POSITION.LONG_SHORT_IND | 1 | Â | X | Â |
LOT_LEVEL_POSITION.ORIG_LOT_NUMBER | 255 | Â | X | Â |
 |  | 0 | 307 |  |
Â