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

Download sample file: [Counterparties.csv](../assets/csv/Counterparties.csv)

This Counterparties file type is identified using the pattern: **\*\*Counterparties\*.csv** (as specified by `mr.common.file-patterns.counterparties`).
This file is loaded using the **Counterparties** topic. See the [Topic Aliases table](../dev/dev-mr-application/dev-dlc/dlc-mr-config#topic-aliases) for an understanding of the topic aliases associated with each topic.

For information on the glob patterns used and how to customize them, see note on [File name patterns](.#file-name-patterns)

<table><tr><th>Field</th><th>Key</th><th>Null</th><th>FieldType</th><th>Description</th><th>Example</th></tr><tr><td>AsOfDate</td><td>Y</td><td>N</td><td>String with format ‘YYYY-MM-DD’</td><td>Indicates the date of the file. See <a href=".">Note on AsOfDate</a>.</td><td /></tr><tr><td>CounterpartyId</td><td>Y</td><td>N</td><td>String</td><td>Counterparty identifier. Used as a foreign key when counterparty is referenced.</td><td>“HSBC Group”, “EBRD”</td></tr><tr><td>CounterpartyName</td><td>N</td><td>Y</td><td>String</td><td>Full counterparty name.</td><td>“HSBC Holdings PLC”, “European Bank for Reconstruction and Development”</td></tr><tr><td>Rating</td><td>N</td><td>Y</td><td>String</td><td>Rating of the counterparty.</td><td>“AAA”, “BB”</td></tr><tr><td>Sector</td><td>N</td><td>Y</td><td>String</td><td>Sector of the counterparty.</td><td /></tr><tr><td>CountryOfAddress</td><td>N</td><td>Y</td><td>String</td><td>Country where the counterparty is located, in the form of a unique three-letter country identifier code.</td><td /></tr><tr><td>CountryOfRisk</td><td>N</td><td>Y</td><td>String</td><td>Country the risk of counterparty can be attributed to, in the form of a unique three-letter country identifier code.</td><td /></tr></table>