invantive documentation
Forum di supporto InvantiveAccedi / Registrati

salary_rule: Odoo itgen_odoo_salary_rule

read only per partition

  • Catalogo: Odoo
  • Schema: hr
  • Etichetta: itgen_odoo_salary_rule

Salary Rule

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella salary_rule. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
account_credit varchar2
account_credit_label varchar2
account_debit varchar2
account_debit_label varchar2
active boolean Active If the active field is set to false, it will allow you to hide the salary rule without removing it.
amount_fix numeric Importo fisso
amount_percentage numeric Percentage (%) For example, enter 50.0 to apply a percentage of 50%
amount_percentage_base varchar2 Percentage based on result will be affected to a variable
amount_python_compute varchar2 Python Code
amount_select varchar2 Tipo di importo The computation method for the rule amount.
analytic_account_id varchar2
analytic_account_id_label varchar2
appears_on_employee_cost_dashboard boolean View on Employer Cost Dashboard Used to display the value in the employer cost dashboard.
appears_on_payroll_report boolean View on Payroll Reporting
appears_on_payslip boolean Appears on Payslip Used to display the salary rule on payslip.
category_id varchar2
category_id_label varchar2
code varchar2 Code The code of salary rules can be used as reference in computation of other rules.In that case, it is case sensitive.
condition_python varchar2 Python Condition Applied this rule for calculation if condition is true.You can specify condition like basic > 1000.
condition_range varchar2 Range Based on This will be used to compute the % fields values; in general it is on basic, but you can also use categories code fields in lowercase as a variable names (hra, ma, lta, etc.) and the variable basic.
condition_range_max numeric Maximum Range The maximum amount, applied for this rule.
condition_range_min numeric Minimum Range The minimum amount, applied for this rule.
condition_select varchar2 Condition Based on
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
display_name varchar2 Nome visualizzato
id int32 ID
name varchar2 Name
not_computed_in_net boolean Not computed in net accountably This field allows you to delete the value of this rule in the "Net Salary" rule at the accounting level to explicitly display the value of this rule in the accounting.For example, if you want to display the value of your representation fees, you can check this field.
note varchar2 Description
partner_id varchar2 Eventual third party involved in the salary payment of the employees.
partner_id_label varchar2 Eventual third party involved in the salary payment of the employees.
quantity varchar2 Quantity It is used in computation for percentage and fixed amount.E.g. a rule for Meal Voucher having fixed amount of 1€ per worked day can have its quantity defined in expression like worked_days.WORK100.number_of_days.
sequence int32 Sequence Use to arrange calculation sequence
struct_id varchar2
struct_id_label varchar2
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: