> ## 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.

# Global database definition

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](../fxrates) table.

## Trade Booking

The [TRADE\_MAPPING](../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](../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](../legal_entity_hierarchy) table which is indexed by **LEGAL\_ENTITY** and **AS\_OF\_DATE**.
It is built from the  table.

The [LEGAL\_ENTITY\_ATTRIBUTES](../legal_entity_attributes) table provides a description of the legal entities.