Versions Compared

Key

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

Anchor
_GoBack
_GoBack
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