Warehouse Disposal 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

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

 

Â