unique idenfier (as alphanumeric). There is a 1:1 mapping between blotter_id and ticketref, you can use either as per your preference
date
Trade Date
date
Settlement Date
date
Special field for edge cases while generating accounting statements (e.g. to cover a scenario where the trade date and settle date straddle the accounting end period)