TradeMapping

Store Field Key CanBeNull Type Cube Field Description
TradeId Y String [Booking].[Trades] (e.g. “IR_IRSWAP_LIBOR3M”, “EQ_12345677”, etc.) – if coming from multiple systems may need to prepend source system to the id for uniqueness.
Book String [Booking].[Books] The book to map the trade to (must match the node in the Book Hierarchy).
LegalEntity String [Organization].[Legal Entities] Legal Entity to map the trade to (must match the node in the Legal Entity Hierarchy).
TradeDate LOCALDATE[yyyy-mm-dd] [Dates].[TradeDates]
AsOfDate Y LOCALDATE[yyyy-mm-dd] Timestamp (at close of business) for the data.
search.js