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

calcMasterTransactionId

 

 

 

 

 

 

TRADE.ACCT_BASIS

 

xXx

X

 

DISPOSAL_LOTS.ENTITY_ID

 

xXx

X

 

DISPOSAL_LOTS.SECURITY_ALIAS

 

xXx

X

 

DISPOSAL_LOTS.LONG_SHORT_INDICATOR

 

xXx

X

 

DISPOSAL_LOTS.CLS_OPEN_EVENT_ID

 

xX

 

 

TRADE.STAR_TAG25

 

 

xX

 

 

 

 

 

 

IncludeExtendedDetails must equal Y or ALL

 

 

 

 

Order of included elements in calcMasterTransactionId

Max Character Length

EnhanceCalcTransactionId = N

EnhanceCalcTransactionId = Y

 

 

 

 

 

 

TRADE.ACCT_BASIS

5

 

xX

 

DISPOSAL_LOTS.ENTITY_ID

8

 

xX

 

DISPOSAL_LOTS.SECURITY_ALIAS

38

 

xX

 

DISPOSAL_LOTS.LONG_SHORT_INDICATOR

1

 

xX

 

DISPOSAL_LOTS.CLS_OPEN_EVENT_ID

255

 

xX

 

 

 

0

307

 

IncludeExtendedDetails must equal Y or ALL

 

 

 

 

Order of included elements in calcMasterCloseTransactionId

 

EnhanceCalcTransactionId = N

EnhanceCalcTransactionId = Y

 

 

 

 

 

 

TRADE.ACCT_BASIS

5

 

xX

 

DISPOSAL_LOTS.ENTITY_ID

8

 

xX

 

DISPOSAL_LOTS.SECURITY_ALIAS

38

 

xX

 

DISPOSAL_LOTS.LONG_SHORT_INDICATOR

1

 

xX

 

TRADE.STAR_TAG25

255

 

xX

 

 

 

0

307