Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

 

Anchor
_GoBack
_GoBack