Navigation :
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. |