ores.refdata.counterparty_identifier
Table of Contents
External identifiers for counterparties, such as LEI codes, BIC/SWIFT codes, national registration numbers, and tax identifiers. Each counterparty can have multiple identifiers across different schemes.
Flags
Primary key
UUID uniquely identifying this counterparty identifier.
Surrogate key for the counterparty identifier record.
Natural keys
counterparty_id
The counterparty this identifier belongs to.
References the parent counterparty record.
uuid_gen()
id_scheme
The identification scheme for this identifier.
References the party_id_scheme lookup table (e.g. LEI, BIC).
std::string("LEI")
Columns
id_value
The identifier value.
The actual identifier string within the scheme.
std::string(faker::string::alphanumeric(20))
description
Optional description of this identifier.
Free text description providing additional context.
std::string("Test identifier")
SQL
Flags
C++
Flags
Repository
Domain includes
#include <chrono> #include <string> #include <boost/uuid/uuid.hpp>
Entity includes
#include <string> #include "sqlgen/Timestamp.hpp" #include "sqlgen/PrimaryKey.hpp"
Conventions
Table display
| column | header |
|---|---|
| counterparty_id | Counterparty |
| id_scheme | Scheme |
| id_value | Value |
| description | Description |
| modified_by | Modified By |
| version | Version |
Custom repository methods
See also
- ores.refdata — component group overview.