salary_attachment |
Salary Attachment
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 salary_attachment are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
active_amount |
decimal |
Active Amount |
☐ |
Amount to pay for this month, Monthly Amount or less depending on the Remaining Amount. |
attachment_name |
string |
Attachment Name |
☐ |
|
attachment |
byte[] |
Document |
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
currency_id_label |
string |
|
☐ |
|
currency_id |
string |
|
☐ |
|
date_end |
datetime |
End Date |
☐ |
Date at which this assignment has been set as completed or cancelled. |
date_estimated_end |
datetime |
Estimated End Date |
☐ |
Approximated end date. |
date_start |
datetime |
Start Date |
☑ |
|
deduction_type |
string |
Type |
☑ |
|
description |
string |
Description |
☑ |
|
display_name |
string |
Display Name |
☐ |
|
employee_id_label |
string |
|
☐ |
|
employee_id |
string |
|
☐ |
|
has_message |
boolean |
Has Message |
☐ |
|
has_similar_attachment_warning |
string |
Has Similar Attachment Warning |
☐ |
|
has_similar_attachment |
boolean |
Has Similar Attachment |
☐ |
|
has_total_amount |
boolean |
Has Total Amount |
☐ |
|
id |
int32 |
ID |
☐ |
|
message_attachment_count |
int32 |
Attachment Count |
☐ |
|
message_follower_ids |
string |
|
☐ |
|
message_has_error_counter |
int32 |
Number of errors |
☐ |
Number of messages with delivery error |
message_has_error |
boolean |
Message Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_has_sms_error |
boolean |
SMS Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_ids |
string |
|
☐ |
|
message_is_follower |
boolean |
Is Follower |
☐ |
|
message_main_attachment_id_label |
string |
|
☐ |
|
message_main_attachment_id |
string |
|
☐ |
|
message_needaction_counter |
int32 |
Number of Actions |
☐ |
Number of messages which requires an action |
message_needaction |
boolean |
Action Needed |
☐ |
If checked, new messages require your attention. |
message_partner_ids |
string |
|
☐ |
|
monthly_amount |
decimal |
Monthly Amount |
☑ |
Amount to pay each month. |
paid_amount |
decimal |
Paid Amount |
☐ |
|
payslip_count |
int32 |
# Payslips |
☐ |
|
payslip_ids |
string |
|
☐ |
|
remaining_amount |
decimal |
Remaining Amount |
☐ |
Remaining amount to be paid. |
state |
string |
Status |
☑ |
|
total_amount |
decimal |
Total Amount |
☐ |
Total amount to be paid. |
website_message_ids |
string |
|
☐ |
Website communication history |
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826