salary_rule: Odoo itgen_odoo_salary_rule
read only per partition
- Catalog:
Odoo - Schema:
hr - Label: itgen_odoo_salary_rule
Salary Rule
Can only retrieve data.
Table Columns
The columns of the table salary_rule are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | 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 |
Fixed Amount | |||
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 |
Amount Type | 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 |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
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 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: