payslip_line |
Payslip Line
Catalog: Odoo
Schema: hr
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table payslip_line are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
amount_fix |
decimal |
Fixed Amount |
☐ |
|
amount_percentage |
decimal |
Percentage (%) |
☐ |
For example, enter 50.0 to apply a percentage of 50% |
amount_select |
string |
Amount Type |
☐ |
The computation method for the rule amount. |
amount |
decimal |
Amount |
☐ |
|
appears_on_payslip |
boolean |
Appears on Payslip |
☐ |
Used to display the salary rule on payslip. |
category_id_label |
string |
|
☐ |
|
category_id |
string |
|
☐ |
|
code |
string |
Code |
☑ |
The code of salary rules can be used as reference in computation of other rules. In that case, it is case sensitive. |
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
contract_id_label |
string |
|
☐ |
|
contract_id |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
currency_id_label |
string |
|
☐ |
|
currency_id |
string |
|
☐ |
|
date_from |
datetime |
From |
☐ |
|
date_to |
datetime |
To |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
employee_id_label |
string |
|
☐ |
|
employee_id |
string |
|
☐ |
|
id |
int32 |
ID |
☐ |
|
name |
string |
Name |
☑ |
|
note |
string |
Description |
☐ |
|
partner_id_label |
string |
|
☐ |
Eventual third party involved in the salary payment of the employees. |
partner_id |
string |
|
☐ |
Eventual third party involved in the salary payment of the employees. |
quantity |
decimal |
Quantity |
☐ |
|
rate |
decimal |
Rate (%) |
☐ |
|
salary_rule_id_label |
string |
|
☐ |
|
salary_rule_id |
string |
|
☐ |
|
sequence |
int32 |
Sequence |
☑ |
Use to arrange calculation sequence |
slip_id_label |
string |
|
☐ |
|
slip_id |
string |
|
☐ |
|
total |
decimal |
Total |
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826