Single Line Transactions

Sample here

Field	Data Type	Description
blotter_id	integer	unique idenfier (as integer)
ticketref	text	unique idenfier (as alphanumeric). There is a 1:1 mapping between blotter_id and ticketref, you can use either as per your preference
traded_on	date	Trade Date
settled_on	date	Settlement Date
accounting_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)
ccy_account_code	text
contract_currency	text	currency of the contract e.g. USD, HKD etc.
ticker	text
security_name	text
contract_type	text
trade_type	text
nominal_amount	numeric
trade_price	numeric
effective_price	numeric
gross_amount_ccy	numeric
accrued_interest	numeric
withholding_tax	numeric
brokerage	numeric
other_expenses	numeric
settlement_amount_ccy	numeric
quantity	numeric
number_of_contracts	numeric
effective_amount_ccy	numeric
custodian_ref	text
ticket_created_at	timestamp without time zone
ticket_updated_at	timestamp without time zone
price_updated_at	timestamp without time zone
custodian_code	text
custodian_name	text
parent_username	text
child_username	text
parent_display_name	text
child_display_name	text
base_ccy	text
contract_id	integer
contract_currency_id	integer
counterparty_id	integer
parent_user_id	integer
user_id	integer
user_account_id	integer
bank_narration	text
strategy_tag_id	integer
transaction_id	integer
transaction_type_id	integer
security_id	integer
related_security_id	integer
related_security_ticker	text
related_security_name	text
related_security_isin	text
user_asset_class	text
user_geography	text
user_industry	text
canopy_asset_class	text
bb_composite_rating	text
em_dm	text
canopy_geography	text
partner_asset_class	text
partner_industry	text
partner_geography	text
day_1_notional_trade_ccy	numeric
day_1_mtm_trade_ccy	numeric
day_1_price_close	numeric
day_1_price_clean	numeric
day_1_fxrate_trade_ccy	numeric
day_1_mtm_usd	numeric
day_1_notional_usd	numeric
normalized_transaction_id	uuid
bank_transaction_type	text
bank_reference_id	text
bank_security_identifier	text
file_id	uuid
session_id	uuid
single_line_transactions_created_at	timestamp without time zone
day_1_fxrate_base_ccy	numeric
uuid_key	uuid
day_1_price_id	integer
day_1_price_source_id	integer
avg_price	double precision
realized_pnl	double precision
gross_amount_base_ccy	numeric
gross_amount_usd	numeric
settlement_amount_base_ccy	numeric
settlement_amount_usd	numeric
realized_pnl_base_ccy	double precision
realized_pnl_usd	double precision
normalized_transaction_gross_settlement_amount	numeric
taxes	numeric	This is still being implemented