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

Columns

code

Unique contact type code.

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

name

Human-readable name for the contact type.

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

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;

Validation function

Insert trigger

Validations

column validation_function
change_reason_code ores_dq_validate_change_reason_fn

C++

Flags

Repository

Domain includes

#include <chrono>
#include <string>

Entity includes

#include <string>

Conventions

Table display

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

Qt

Detail fields

field label widget type is_key is_required placeholder
code Code codeEdit line_edit true true e.g. Legal
name Name nameEdit line_edit   true e.g. Legal Contact
description Description descriptionEdit line_edit     Short description
display_order Display Order displayOrderEdit spin_box      

Columns (Qt model)

enum_name field header type width is_badge badge_key
Code code Code string 150 true contact_type
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.3 (Org mode 9.6.15)