id | id | integer | NO | | Identifier of the related record. |
acd_counter_id | cnt_id | integer | NO | | Unique internal identifier for the counter. |
tenant_id | tenant_id | integer | NO | | Identifier of the related tenant. |
acd_group_id | cnt_grp_id | integer | NO | 0 | Reference to the counter group (counter_groups). |
acd_name | cnt_nome | character(20) | NO | ''::bpchar | Mnemonic name/code of the counter. |
acd_description | cnt_descrizione | text | NO | ''::text | Description of acd description. |
acd_initial_value_type | cnt_val_ini_tipo | numeric(1,0) | NO | 0 | Value of acd initial value type. |
acd_initial_value | cnt_val_ini | numeric(9,2) | NO | 0 | Value of acd initial value. |
acd_reset_initial_value_on_period | cnt_val_ini_reimposta | boolean | NO | false | Boolean flag for acd reset initial value on period. |
acd_valid_from | cnt_dal | date | NO | | Value of acd valid from. |
acd_valid_to | cnt_al | date | NO | | Value of acd valid to. |
acd_update_mode | cnt_tipo_agg | numeric(1,0) | NO | 0 | Date associated with acd update mode. |
acd_unit_of_measure | cnt_udm | numeric(1,0) | NO | 0 | Value of acd unit of measure. |
acd_is_periodic | cnt_periodico | boolean | NO | false | If true, the counter resets or accrues based on a time period. |
acd_period_reference_date | cnt_periodo_data_partenza | date | NO | | Date associated with acd period reference date. |
acd_period_duration | cnt_periodo | numeric(2,0) | NO | 0 | Value of acd period duration. |
acd_period_start_mode | cnt_periodo_partenza | numeric(1,0) | NO | 0 | Value of acd period start mode. |
acd_frequency_value | cnt_per_ogni | numeric(4,0) | NO | 0 | Value of acd frequency value. |
acd_frequency_unit | cnt_peri_udm | numeric(1,0) | NO | 0 | Value of acd frequency unit. |
acd_calculation_operation | cnt_operazione | numeric(1,0) | NO | 0 | Value of acd calculation operation. |
acd_value_source_type | cnt_valore_tipo1 | numeric(1,0) | NO | 0 | Value of acd value source type. |
acd_value_source_code | cnt_valore_tipo2 | character(10) | NO | ''::bpchar | Code of acd value source code. |
acd_calculation_expression | cnt_valore_expr | text | NO | ''::text | Formula used to calculate the value to add/subtract to the counter. |
acd_carry_forward_enabled | cnt_val_prec | boolean | NO | false | If true, the balance from the previous period is carried over. |
acd_a1_min_threshold | cnt_az1_minimo | numeric(9,2) | NO | 0 | Value of acd a1 min threshold. |
acd_a1_max_threshold | cnt_az1_massimo | numeric(9,2) | NO | 0 | Value of acd a1 max threshold. |
acd_a1_operator | cnt_az1_oper | numeric(1,0) | NO | 0 | Value of acd a1 operator. |
acd_a1_alert_code | cnt_az1_alert | character(4) | NO | ''::bpchar | Code of acd a1 alert code. |
acd_a2_min_threshold | cnt_az2_minimo | numeric(9,2) | NO | 0 | Value of acd a2 min threshold. |
acd_a2_max_threshold | cnt_az2_massimo | numeric(9,2) | NO | 0 | Value of acd a2 max threshold. |
acd_a2_operator | cnt_az2_oper | numeric(1,0) | NO | 0 | Value of acd a2 operator. |
acd_a2_alert_code | cnt_az2_alert | character(4) | NO | ''::bpchar | Code of acd a2 alert code. |
acd_a3_min_threshold | cnt_az3_minimo | numeric(9,2) | NO | 0 | Value of acd a3 min threshold. |
acd_a3_max_threshold | cnt_az3_massimo | numeric(9,2) | NO | 0 | Value of acd a3 max threshold. |
acd_a3_operator | cnt_az3_oper | numeric(1,0) | NO | 0 | Value of acd a3 operator. |
acd_a3_alert_code | cnt_az3_alert | character(4) | NO | ''::bpchar | Code of acd a3 alert code. |
acd_min_allowed_value | cnt_limite_minimo | numeric(9,2) | NO | 0 | Value of acd min allowed value. |
acd_max_allowed_value | cnt_limite_massimo | numeric(9,2) | NO | 0 | Value of acd max allowed value. |
acd_sort_order | cnt_order | integer | NO | 0 | Value of acd sort order. |
acd_carry_forward_periods_count | cnt_val_prec_n_periodi | numeric(2,0) | NO | 0 | Value of acd carry forward periods count. |
acd_apply_to_all_employees | cnt_x_tutti | boolean | NO | false | Boolean flag for acd apply to all employees. |
acd_check_min_limit | cnt_controlla_minimo | boolean | NO | false | Boolean flag for acd check min limit. |
acd_check_max_limit | cnt_controlla_massimo | boolean | NO | false | Boolean flag for acd check max limit. |
acd_consume_previous_period_first | cnt_consumo_prec | boolean | YES | false | Boolean flag for acd consume previous period first. |
acd_negative_value_expression | cnt_valore_expr_neg | text | YES | ''::text | Value of acd negative value expression. |
acd_is_visible_on_web | cnt_web | boolean | NO | false | Boolean flag for acd is visible on web. |
acd_pro_rata_for_part_time | cnt_prop_ptime | boolean | YES | false | Time associated with acd pro rata for part time. |
acd_block_on_min_limit | cnt_blocca_minimo | boolean | YES | false | Boolean flag for acd block on min limit. |
acd_block_on_max_limit | cnt_blocca_massimo | boolean | YES | false | Boolean flag for acd block on max limit. |
acd_balance_transfer_target | cnt_dest_saldo | smallint | YES | 0 | Target counter or balance where the residual value is moved at the end of the period. |
acd_balance_transfer_expression | cnt_expr_saldo | text | YES | ''::text | Value of acd balance transfer expression. |
acd_balance_transfer_reason_code | cnt_causale_saldo | character(4) | YES | ''::bpchar | Code of acd balance transfer reason code. |
_deleted | _deleted | boolean | NO | false | Flag indicating whether the record is soft-deleted. |