# payslip Pay Slip - 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` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `activity_calendar_event_id_label` | `string` | | ☐ | | | `activity_calendar_event_id` | `string` | | ☐ | | | `activity_date_deadline` | `datetime` | Next Activity Deadline | ☐ | | | `activity_exception_decoration` | `string` | Activity Exception Decoration | ☐ | Type of the exception activity on record. | | `activity_exception_icon` | `string` | Icon | ☐ | Icon to indicate an exception activity. | | `activity_ids` | `string` | | ☐ | | | `activity_state` | `string` | Activity State | ☐ | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | | `activity_summary` | `string` | Next Activity Summary | ☐ | | | `activity_type_icon` | `string` | Activity Type Icon | ☐ | Font awesome icon e.g. fa-tasks | | `activity_type_id_label` | `string` | | ☐ | | | `activity_type_id` | `string` | | ☐ | | | `activity_user_id_label` | `string` | | ☐ | | | `activity_user_id` | `string` | | ☐ | | | `attendance_count` | `int32` | Attendance Count | ☐ | | | `basic_wage` | `decimal` | Basic Wage | ☐ | | | `company_id_label` | `string` | | ☐ | | | `company_id` | `string` | | ☐ | | | `compute_date` | `datetime` | Computed On | ☐ | | | `contract_domain_ids` | `string` | | ☐ | | | `contract_id_label` | `string` | | ☐ | | | `contract_id` | `string` | | ☐ | | | `country_code` | `string` | Country Code | ☐ | The ISO country code in two chars. You can use this field for quick search. | | `country_id_label` | `string` | | ☐ | | | `country_id` | `string` | | ☐ | | | `create_date` | `datetime` | Created on | ☐ | | | `create_uid_label` | `string` | | ☐ | | | `create_uid` | `string` | | ☐ | | | `credit_note` | `boolean` | Credit Note | ☐ | Indicates this payslip has a refund of another | | `currency_id_label` | `string` | | ☐ | | | `currency_id` | `string` | | ☐ | | | `date_from` | `datetime` | From | ☑ | | | `date_to` | `datetime` | To | ☑ | | | `date` | `datetime` | Date Account | ☐ | Keep empty to use the period of the validation(Payslip) date. | | `department_id_label` | `string` | | ☐ | | | `department_id` | `string` | | ☐ | | | `display_name` | `string` | Display Name | ☐ | | | `edited` | `boolean` | Edited | ☐ | | | `email_cc` | `string` | Email cc | ☐ | | | `employee_id_label` | `string` | | ☐ | | | `employee_id` | `string` | | ☐ | | | `gross_wage` | `decimal` | Gross Wage | ☐ | | | `has_message` | `boolean` | Has Message | ☐ | | | `has_negative_net_to_report` | `boolean` | Has Negative Net To Report | ☐ | | | `has_refund_slip` | `boolean` | Has Refund Slip | ☐ | | | `id` | `int32` | ID | ☐ | | | `input_line_ids` | `string` | | ☐ | | | `is_regular` | `boolean` | Is Regular | ☐ | | | `is_superuser` | `boolean` | Is Superuser | ☐ | | | `job_id_label` | `string` | | ☐ | | | `job_id` | `string` | | ☐ | | | `journal_id_label` | `string` | | ☐ | | | `journal_id` | `string` | | ☐ | | | `line_ids` | `string` | | ☐ | | | `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` | | ☐ | | | `move_id_label` | `string` | | ☐ | | | `move_id` | `string` | | ☐ | | | `my_activity_date_deadline` | `datetime` | My Activity Deadline | ☐ | | | `name` | `string` | Payslip Name | ☑ | | | `negative_net_to_report_amount` | `decimal` | Negative Net To Report Amount | ☐ | | | `negative_net_to_report_display` | `boolean` | Negative Net To Report Display | ☐ | | | `negative_net_to_report_message` | `string` | Negative Net To Report Message | ☐ | | | `net_wage` | `decimal` | Net Wage | ☐ | | | `normal_wage` | `int32` | Normal Wage | ☐ | | | `note` | `string` | Internal Note | ☐ | | | `number` | `string` | Reference | ☐ | | | `paid` | `boolean` | Made Payment Order ? | ☐ | | | `payslip_run_id_label` | `string` | | ☐ | | | `payslip_run_id` | `string` | | ☐ | | | `planning_slot_count` | `int32` | Planning Slot Count | ☐ | | | `queued_for_pdf` | `boolean` | Queued For Pdf | ☐ | | | `salary_attachment_count` | `int32` | Salary Attachment count | ☐ | | | `salary_attachment_ids` | `string` | | ☐ | | | `state` | `string` | Status | ☐ | * When the payslip is created the status is 'Draft' * If the payslip is under verification, the status is 'Waiting'. * If the payslip is confirmed then status is set to 'Done'. * When user cancel payslip the status is 'Rejected'. | | `struct_id_label` | `string` | | ☐ | Defines the rules that have to be applied to this payslip, according to the contract chosen. If the contract is empty, this field isn't mandatory anymore and all the valid rules of the structures of the employee's contracts will be applied. | | `struct_id` | `string` | | ☐ | Defines the rules that have to be applied to this payslip, according to the contract chosen. If the contract is empty, this field isn't mandatory anymore and all the valid rules of the structures of the employee's contracts will be applied. | | `struct_type_id_label` | `string` | | ☐ | | | `struct_type_id` | `string` | | ☐ | | | `sum_worked_hours` | `decimal` | Sum Worked Hours | ☐ | Total hours of attendance and time off (paid or not) | | `wage_type` | `string` | Wage Type | ☐ | | | `warning_message` | `string` | Warning Message | ☐ | | | `website_message_ids` | `string` | | ☐ | Website communication history | | `worked_days_line_ids` | `string` | | ☐ | | | `write_date` | `datetime` | Last Updated on | ☐ | | | `write_uid_label` | `string` | | ☐ | | | `write_uid` | `string` | | ☐ | |