ores.refdata.party_status

1. Flags
2. Columns
3. SQL
- 3.1. Flags
- 3.2. Extra drops
4. Validation function
5. Insert trigger
- 5.1. Validations
6. C++
7. See also

Reference data table defining valid party status values. Examples: 'Active', 'Inactive', 'Suspended'.

Party statuses are managed by the system tenant and are used to track the lifecycle of party and counterparty records.

1. Flags

2. Columns

2.1. code

Unique status code.

Examples: 'Active', 'Inactive', 'Suspended'.

2.2. name

Human-readable name for the status.

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

2.3. description

Detailed description of the party status.

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_party_status_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>
#include "sqlgen/Timestamp.hpp"

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	Enter status code
name	Name	nameEdit	line_edit		true	Enter status name
description	Description	descriptionEdit	text_edit		true	Enter a description
display_order	Display Order	displayOrderEdit	spin_box

6.7.2. Columns

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

6.8. Custom repository methods

7. See also

ores.refdata — component group overview.