ores.refdata.contact_type

Table of Contents

Reference data table defining valid contact type classifications. Examples: 'Legal', 'Operations', 'Settlement', 'Billing'.

Contact types are managed by the system tenant and are used to categorise contact information records for parties and counterparties.

Flags

Primary key

Unique contact type code.

Examples: 'Legal', 'Operations', 'Settlement'.

Natural keys

name

Human-readable name for the contact type.

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

Columns

description

Detailed description of the contact type.

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

display_order

Order for UI display purposes.

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

SQL

Flags

Extra drops

drop function if exists ores_refdata_validate_contact_type_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
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
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)