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

 

 

 

 

 

 

 

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

 

Â