Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt

Use this file to discover all available pages before exploring further.

This section describes tables that are common to all cubes. This includes FX rates and trade booking.

FX Rates

The FX rates are stored in the FX_RATES table.

Trade Booking

The TRADE_MAPPING table maps trades/positions to books and legal entities by TRADE_ID and AS_OF_DATE. The multi-level book organizational hierarchy and desk descriptions are in the BOOK_HIERARCHY table which is indexed by BOOK and AS_OF_DATE. The multi-level legal entity organizational hierarchy is in the LEGAL_ENTITY_HIERARCHY table which is indexed by LEGAL_ENTITY and AS_OF_DATE. It is built from the table. The LEGAL_ENTITY_ATTRIBUTES table provides a description of the legal entities.