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_ |
varchar2 |
||||
account_ |
varchar2 |
||||
account_ |
varchar2 |
||||
account_ |
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_ |
numeric |
Importo fisso | |||
amount_ |
numeric |
Percentage (%) | For example, enter 50.0 to apply a percentage of 50% | ||
amount_ |
varchar2 |
Percentage based on | result will be affected to a variable | ||
amount_ |
varchar2 |
Python Code | |||
amount_ |
varchar2 |
Tipo di importo | The computation method for the rule amount. | ||
analytic_ |
varchar2 |
||||
analytic_ |
varchar2 |
||||
appears_ |
boolean |
View on Employer Cost Dashboard | Used to display the value in the employer cost dashboard. | ||
appears_ |
boolean |
View on Payroll Reporting | |||
appears_ |
boolean |
Appears on Payslip | Used to display the salary rule on payslip. | ||
category_ |
varchar2 |
||||
category_ |
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_ |
varchar2 |
Python Condition | Applied this rule for calculation if condition is true.You can specify condition like basic > 1000. | ||
condition_ |
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_ |
numeric |
Maximum Range | The maximum amount, applied for this rule. | ||
condition_ |
numeric |
Minimum Range | The minimum amount, applied for this rule. | ||
condition_ |
varchar2 |
Condition Based on | |||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Nome visualizzato | |||
id |
int32 |
ID | |||
name |
varchar2 |
Name | |||
not_ |
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_ |
varchar2 |
Eventual third party involved in the salary payment of the employees. | |||
partner_ |
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_ |
varchar2 |
||||
struct_ |
varchar2 |
||||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: