hr.expense_reimbursement_types
Schema: hr
English table: hr.expense_reimbursement_types
Italian original table: hr.in_notaspese_rimborsi
Description: Expense reimbursement types/configuration (multi-tenant). Defines rules, limits and accounting code for expense reimbursements.
Overview
- Columns: 11
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 3
- Indexes: 2
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
ert_id | nsr_id | integer | NO | Logical reimbursement type identifier (unique per tenant). | |
ert_description | nsr_description | character varying(100) | NO | Reimbursement type description. | |
ert_is_enabled | nsr_enabled | boolean | NO | Whether the reimbursement type is enabled/active. | |
ert_max_unit_amount | nsr_max_value_unit | numeric(8,2) | NO | Maximum reimbursable amount per unit (business-defined unit). | |
ert_can_pay_others | nsr_pay_others | boolean | NO | If true, reimbursement can be paid for other people (business rule). | |
ert_requires_company_car_info | nsr_ask_company_car | boolean | NO | If true, requires company car information (business rule). | |
ert_account_code | nsr_account_code | character varying(15) | NO | Accounting code for payroll/accounting integration. | |
tenant_id | tenant_id | integer | YES | Tenant identifier for data isolation. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom fields (JSON). |
_deleted | _deleted | boolean | YES | false | Technical soft-delete flag. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_ert_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
| From table | Foreign key | Source columns | Target columns |
|---|---|---|---|
hr.expense_note_lines | fk_enl_reimbursement_type_id | enl_reimbursement_type_id, tenant_id | ert_id, tenant_id |
hr.expense_reimbursement_type_account_links | fk_ertac_reimbursement_type | ertac_ert_id, tenant_id | ert_id, tenant_id |
hr.expense_reimbursement_type_custom_fields | fk_ertcf_reimbursement_type | ertcf_ert_id, tenant_id | ert_id, tenant_id |
Constraints
- Primary key:
pk_expense_reimbursement_types→id - Unique:
uk_ert_id_tenant→ert_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_expense_reimbursement_types_ert_id_tenant | NO | btree | tenant_id, ert_id) WHERE (_deleted = false |
idx_expense_reimbursement_types_tenant | NO | btree | tenant_id |
Navigation
- Back to main index
- [Back to
hrindex]../)