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

X

 

 

POSITION.ENTITY_ID

 

x

X

 

 

LOT_LEVEL_POSITION.SECURITY_ALIAS

 

x

X

 

 

LOT_LEVEL_POSITION.LONG_SHORT_IND

 

x

X

 

 

LOT_LEVEL_POSITION.ORIG_LOT_NUMBER

 

x

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

X

 

POSITION.ENTITY_ID

8

 

x

X

 

LOT_LEVEL_POSITION.SECURITY_ALIAS

38

 

x

X

 

LOT_LEVEL_POSITION.LONG_SHORT_IND

1

 

x

X

 

LOT_LEVEL_POSITION.ORIG_LOT_NUMBER

255

 

x

X

 

 

 

0

307

 

...