The COUNTERPARTIES table contains data for counterparties.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.
| Column Name | Type | Not Null | Default Value1 | Cube Field | Description | |
|---|---|---|---|---|---|---|
| AS_OF_DATE | DATE | Y | Timestamp (at close of business) for the data. | |||
| COUNTERPARTY_ID | STRING | Y | N/A | CounterpartyIds | Counterparty identifier. Used as a foreign key when counterparty is referenced. | |
| COUNTERPARTY_NAME | STRING | Y | N/A | CounterpartyNames | Full counterparty name. | |
| RATING | STRING | Y | N/A | CounterpartyRatings | Rating of the counterparty. | |
| SECTOR | STRING | Y | N/A | CounterpartySectors | Sector of the counterparty. | |
| COUNTRY_OF_ADDRESS | STRING | Y | N/A | CounterpartyCountriesOfAddress | Country where the counterparty is located, in the form of a unique three-letter country identifier code. | |
| COUNTRY_OF_RISK | STRING | Y | N/A | CounterpartyCountriesOfRisk | Country the risk of counterparty can be attributed to, in the form of a unique three-letter country identi | fier code. |
Unique Key
| Columns |
|---|
| AS_OF_DATE |
| COUNTERPARTY_ID |
Incoming Joins
| Source Table | Source Columns | Target Columns |
|---|---|---|
| TRADE_ATTRIBUTES | AS_OF_DATE COUNTERPARTY_ID | AS_OF_DATE COUNTERPARTY_ID |
Outgoing Joins
| Target Table | Source Columns | Target Columns |
|---|---|---|
| COUNTRIES | AS_OF_DATE COUNTRY_OF_ADDRESS | AS_OF_DATE COUNTRY_CODE |
| COUNTRIES | AS_OF_DATE COUNTRY_OF_RISK | AS_OF_DATE COUNTRY_CODE |
- 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. ↩︎