ores.refdata.party_id_scheme

Table of Contents

Reference data table defining valid party identifier scheme types. Examples: 'LEI', 'BIC', 'MIC', 'DUNS'.

Party ID schemes are managed by the system tenant. The optional coding_scheme_code field cross-references the DQ coding scheme table.

Flags

Primary key

Unique scheme code.

Examples: 'LEI', 'BIC', 'MIC'.

Natural keys

name

Human-readable name for the identifier scheme. 

std::string(faker::word::adjective()) + " Scheme"

Columns

description

Detailed description of the identifier scheme. 

std::string(faker::lorem::sentence())

coding_scheme_code

Cross-reference to DQ coding scheme table.

Optional link to ores_dq_coding_schemes_tbl for validation. 

std::string(faker::word::noun())

display_order

Order for UI display purposes. 

faker::number::integer(1, 100)

SQL

Flags

Extra drops

drop function if exists ores_refdata_validate_party_id_scheme_fn;
drop function if exists ores_refdata_validate_party_id_scheme_coding_scheme_fn;

C++

Flags

Repository

Domain includes

#include <chrono>
#include <string>

Entity includes

#include <string>
#include "sqlgen/Timestamp.hpp"

Conventions

Table display

column header
code Code
name Name
description Description
coding_scheme_code Coding Scheme
display_order Order
modified_by Modified By
version Version

Qt

Columns (Qt model)

enum_name field header type width
Code code Code string 150
Name name Name string 200
Description description Description string 300
CodingSchemeCode coding_scheme_code Coding Scheme string 150
DisplayOrder display_order Order int 80
Version version Version int 80
ModifiedBy modified_by Modified By string 120
RecordedAt recorded_at Recorded At timestamp 150

Custom repository methods

See also

Emacs 29.1 (Org mode 9.6.6)