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
- ores.refdata — component group overview.