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

# COUNTERPARTIES

The COUNTERPARTIES table contains data for counterparties.

<table><thead><tr><th>Column Name</th><th>Type</th><th>Not Null</th><th>Default Value<sup id="fnref:1"><a class="footnote-ref" href="#fn:1" role="doc-noteref">1</a></sup></th><th>Cube Field</th><th>Description</th><th /></tr></thead><tbody><tr><td>AS\_OF\_DATE</td><td>DATE</td><td>Y</td><td /><td /><td>Timestamp (at close of business) for the data.</td><td /></tr><tr><td>COUNTERPARTY\_ID</td><td>STRING</td><td>Y</td><td>N/A</td><td><a href="../cube/dimensions/counterparties">CounterpartyIds</a></td><td>Counterparty identifier. Used as a foreign key when counterparty is referenced.</td><td /></tr><tr><td>COUNTERPARTY\_NAME</td><td>STRING</td><td>Y</td><td>N/A</td><td><a href="../cube/dimensions/counterparties">CounterpartyNames</a></td><td>Full counterparty name.</td><td /></tr><tr><td>RATING</td><td>STRING</td><td>Y</td><td>N/A</td><td><a href="../cube/dimensions/counterparties">CounterpartyRatings</a></td><td>Rating of the counterparty.</td><td /></tr><tr><td>SECTOR</td><td>STRING</td><td>Y</td><td>N/A</td><td><a href="../cube/dimensions/counterparties">CounterpartySectors</a></td><td>Sector of the counterparty.</td><td /></tr><tr><td>COUNTRY\_OF\_ADDRESS</td><td>STRING</td><td>Y</td><td>N/A</td><td><a href="../cube/dimensions/counterparties">CounterpartyCountriesOfAddress</a></td><td>Country where the counterparty is located, in the form of a unique three-letter country identifier code.</td><td /></tr><tr><td>COUNTRY\_OF\_RISK</td><td>STRING</td><td>Y</td><td>N/A</td><td><a href="../cube/dimensions/counterparties">CounterpartyCountriesOfRisk</a></td><td>Country the risk of counterparty can be attributed to, in the form of a unique three-letter country identi</td><td>fier code.</td></tr></tbody></table>

## Unique Key

<table><thead><tr><th>Columns</th></tr></thead><tbody><tr><td>AS\_OF\_DATE</td></tr><tr><td>COUNTERPARTY\_ID</td></tr></tbody></table>

## Incoming Joins

<table><thead><tr><th>Source Table</th><th>Source Columns</th><th>Target Columns</th></tr></thead><tbody><tr><td><a href="./trade_attributes">TRADE\_ATTRIBUTES</a></td><td>AS\_OF\_DATE<br />COUNTERPARTY\_ID</td><td>AS\_OF\_DATE<br />COUNTERPARTY\_ID</td></tr></tbody></table>

## Outgoing Joins

<table><thead><tr><th>Target Table</th><th>Source Columns</th><th>Target Columns</th></tr></thead><tbody><tr><td><a href="./countries">COUNTRIES</a></td><td>AS\_OF\_DATE<br />COUNTRY\_OF\_ADDRESS</td><td>AS\_OF\_DATE<br />COUNTRY\_CODE</td></tr><tr><td><a href="./countries">COUNTRIES</a></td><td>AS\_OF\_DATE<br />COUNTRY\_OF\_RISK</td><td>AS\_OF\_DATE<br />COUNTRY\_CODE</td></tr></tbody></table>

***

1. If the default value is marked as empty, it means that the default value is 'null' for nullable fields, and that a value needs to be explicitly set for non-nullable fields.
    [↩︎](#fnref:1)