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.
1. Flags
2. Columns
2.1. code
Unique contact type code.
Examples: 'Legal', 'Operations', 'Settlement'.
2.2. name
Human-readable name for the contact type.
std::string(faker::word::adjective()) + " Contact"
2.3. description
Detailed description of the contact type.
std::string(faker::lorem::sentence())
2.4. display_order
Order for UI display purposes.
faker::number::integer(1, 100)
3. SQL
3.1. Flags
3.2. Extra drops
drop function if exists ores_refdata_validate_contact_type_fn;
4. Validation function
5. Insert trigger
5.1. Validations
| column | validation_function |
|---|---|
| change_reason_code | ores_dq_validate_change_reason_fn |
6. C++
6.1. Flags
6.2. Repository
6.3. Domain includes
#include <chrono> #include <string>
6.4. Entity includes
#include <string>
6.5. Conventions
6.6. Table display
| column | header |
|---|---|
| code | Code |
| name | Name |
| description | Description |
| display_order | Order |
| modified_by | Modified By |
| version | Version |
6.7. Presentation
6.7.1. 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 |
6.7.2. Columns
| 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 |
6.8. Custom repository methods
7. See also
- ores.refdata — component group overview.