# expense_sheet Expense Report Here are the rights associated with the expense flow Action Group Restriction ================================================================================= Submit Employee Only his own Officer If he is expense manager of the employee, manager of the employee or the employee is in the department managed by the officer Manager Always Approve Officer Not his own and he is expense manager of the employee, manager of the employee or the employee is in the department managed by the officer Manager Always Post Anybody State = approve and journal_id defined Done Anybody State = approve and journal_id defined Cancel Officer Not his own and he is expense manager of the employee, manager of the employee or the employee is in the department managed by the officer Manager Always ================================================================================= - 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 `expense_sheet` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `account_move_id_label` | `string` | | ☐ | | | `account_move_id` | `string` | | ☐ | | | `accounting_date` | `datetime` | Accounting Date | ☐ | | | `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` | | ☐ | | | `address_id_label` | `string` | | ☐ | | | `address_id` | `string` | | ☐ | | | `amount_residual` | `decimal` | Amount Due | ☐ | | | `approval_date` | `datetime` | Approval Date | ☐ | | | `attachment_number` | `int32` | Number of Attachments | ☐ | | | `bank_journal_id_label` | `string` | | ☐ | The payment method used when the expense is paid by the company. | | `bank_journal_id` | `string` | | ☐ | The payment method used when the expense is paid by the company. | | `can_approve` | `boolean` | Can Approve | ☐ | | | `can_reset` | `boolean` | Can Reset | ☐ | | | `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` | | ☐ | | | `department_id_label` | `string` | | ☐ | | | `department_id` | `string` | | ☐ | | | `display_name` | `string` | Display Name | ☐ | | | `employee_id_label` | `string` | | ☐ | | | `employee_id` | `string` | | ☐ | | | `expense_line_ids` | `string` | | ☐ | | | `expense_number` | `int32` | Number of Expenses | ☐ | | | `has_message` | `boolean` | Has Message | ☐ | | | `id` | `int32` | ID | ☐ | | | `is_editable` | `boolean` | Expense Lines Are Editable By Current User | ☐ | | | `is_multiple_currency` | `boolean` | Handle lines with different currencies | ☐ | | | `journal_id_label` | `string` | | ☐ | The journal used when the expense is done. | | `journal_id` | `string` | | ☐ | The journal used when the expense is done. | | `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` | | ☐ | | | `my_activity_date_deadline` | `datetime` | My Activity Deadline | ☐ | | | `name` | `string` | Expense Report Summary | ☑ | | | `payment_mode` | `string` | Paid By | ☐ | | | `payment_state` | `string` | Payment Status | ☐ | | | `product_ids` | `string` | | ☐ | | | `sale_order_count` | `int32` | Sale Order Count | ☐ | | | `state` | `string` | Status | ☑ | | | `total_amount_taxes` | `decimal` | Taxes | ☐ | | | `total_amount` | `decimal` | Total Amount | ☐ | | | `untaxed_amount` | `decimal` | Untaxed Amount | ☐ | | | `user_id_label` | `string` | | ☐ | | | `user_id` | `string` | | ☐ | | | `website_message_ids` | `string` | | ☐ | Website communication history | | `write_date` | `datetime` | Last Updated on | ☐ | | | `write_uid_label` | `string` | | ☐ | | | `write_uid` | `string` | | ☐ | |