Single Line Transactions

Single Line Transactions

Sample here

FieldData TypeDescription
blotter_idintegerunique idenfier (as integer)
ticketreftextunique idenfier (as alphanumeric). There is a 1:1 mapping between blotter_id and ticketref, you can use either as per your preference
traded_ondateTrade Date
settled_ondateSettlement Date
accounting_datedateSpecial 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)
ccy_account_codetext
contract_currencytextcurrency of the contract e.g. USD, HKD etc.
tickertext
security_nametext
contract_typetext
trade_typetext
nominal_amountnumeric
trade_pricenumeric
effective_pricenumeric
gross_amount_ccynumeric
accrued_interestnumeric
withholding_taxnumeric
brokeragenumeric
other_expensesnumeric
settlement_amount_ccynumeric
quantitynumeric
number_of_contractsnumeric
effective_amount_ccynumeric
custodian_reftext
ticket_created_attimestamp without time zone
ticket_updated_attimestamp without time zone
price_updated_attimestamp without time zone
custodian_codetext
custodian_nametext
parent_usernametext
child_usernametext
parent_display_nametext
child_display_nametext
base_ccytext
contract_idinteger
contract_currency_idinteger
counterparty_idinteger
parent_user_idinteger
user_idinteger
user_account_idinteger
bank_narrationtext
strategy_tag_idinteger
transaction_idinteger
transaction_type_idinteger
security_idinteger
related_security_idinteger
related_security_tickertext
related_security_nametext
related_security_isintext
user_asset_classtext
user_geographytext
user_industrytext
canopy_asset_classtext
bb_composite_ratingtext
em_dmtext
canopy_geographytext
partner_asset_classtext
partner_industrytext
partner_geographytext
day_1_notional_trade_ccynumeric
day_1_mtm_trade_ccynumeric
day_1_price_closenumeric
day_1_price_cleannumeric
day_1_fxrate_trade_ccynumeric
day_1_mtm_usdnumeric
day_1_notional_usdnumeric
normalized_transaction_iduuid
bank_transaction_typetext
bank_reference_idtext
bank_security_identifiertext
file_iduuid
session_iduuid
single_line_transactions_created_attimestamp without time zone
day_1_fxrate_base_ccynumeric
uuid_keyuuid
day_1_price_idinteger
day_1_price_source_idinteger
avg_pricedouble precision
realized_pnldouble precision
gross_amount_base_ccynumeric
gross_amount_usdnumeric
settlement_amount_base_ccynumeric
settlement_amount_usdnumeric
realized_pnl_base_ccydouble precision
realized_pnl_usddouble precision
normalized_transaction_gross_settlement_amountnumeric
taxesnumericThis is still being implemented