---
title: "expense_sheet (Odoo)"
description: "itgen_odoo_expense_sheet"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.hr.expense_sheet
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.hr.expense_sheet
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# expense_sheet: Odoo itgen_odoo_expense_sheet

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `hr`
- Label: itgen_odoo_expense_sheet

Expense Report

Can only retrieve data.

## Summary

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
        =================================================================================

## Table Columns

The columns of the table `expense_sheet` 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_move_id` | `varchar2` |  | [ ] |  |  |
| `account_move_id_label` | `varchar2` |  | [ ] |  |  |
| `accounting_date` | `datetime` | Accounting Date | [ ] |  |  |
| `activity_calendar_event_id` | `varchar2` |  | [ ] |  |  |
| `activity_calendar_event_id_label` | `varchar2` |  | [ ] |  |  |
| `activity_date_deadline` | `datetime` | Next Activity Deadline | [ ] |  |  |
| `activity_exception_decoration` | `varchar2` | Activity Exception Decoration | [ ] |  | Type of the exception activity on record. |
| `activity_exception_icon` | `varchar2` | Icon | [ ] |  | Icon to indicate an exception activity. |
| `activity_ids` | `varchar2` |  | [ ] |  |  |
| `activity_state` | `varchar2` | Activity State | [ ] |  | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. |
| `activity_summary` | `varchar2` | Next Activity Summary | [ ] |  |  |
| `activity_type_icon` | `varchar2` | Activity Type Icon | [ ] |  | Font awesome icon e.g. fa-tasks |
| `activity_type_id` | `varchar2` |  | [ ] |  |  |
| `activity_type_id_label` | `varchar2` |  | [ ] |  |  |
| `activity_user_id` | `varchar2` |  | [ ] |  |  |
| `activity_user_id_label` | `varchar2` |  | [ ] |  |  |
| `address_id` | `varchar2` |  | [ ] |  |  |
| `address_id_label` | `varchar2` |  | [ ] |  |  |
| `amount_residual` | `numeric` | Amount Due | [ ] |  |  |
| `approval_date` | `datetime` | Approval Date | [ ] |  |  |
| `attachment_number` | `int32` | Number of Attachments | [ ] |  |  |
| `bank_journal_id` | `varchar2` |  | [ ] |  | The payment method used when the expense is paid by the company. |
| `bank_journal_id_label` | `varchar2` |  | [ ] |  | The payment method used when the expense is paid by the company. |
| `can_approve` | `boolean` | Can Approve | [ ] |  |  |
| `can_reset` | `boolean` | Can Reset | [ ] |  |  |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `currency_id` | `varchar2` |  | [ ] |  |  |
| `currency_id_label` | `varchar2` |  | [ ] |  |  |
| `department_id` | `varchar2` |  | [ ] |  |  |
| `department_id_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `employee_id` | `varchar2` |  | [ ] |  |  |
| `employee_id_label` | `varchar2` |  | [ ] |  |  |
| `expense_line_ids` | `varchar2` |  | [ ] |  |  |
| `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` | `varchar2` |  | [ ] |  | The journal used when the expense is done. |
| `journal_id_label` | `varchar2` |  | [ ] |  | The journal used when the expense is done. |
| `message_attachment_count` | `int32` | Attachment Count | [ ] |  |  |
| `message_follower_ids` | `varchar2` |  | [ ] |  |  |
| `message_has_error` | `boolean` | Message Delivery error | [ ] |  | If checked, some messages have a delivery error. |
| `message_has_error_counter` | `int32` | Number of errors | [ ] |  | Number of messages with delivery error |
| `message_has_sms_error` | `boolean` | SMS Delivery error | [ ] |  | If checked, some messages have a delivery error. |
| `message_ids` | `varchar2` |  | [ ] |  |  |
| `message_is_follower` | `boolean` | Is Follower | [ ] |  |  |
| `message_main_attachment_id` | `varchar2` |  | [ ] |  |  |
| `message_main_attachment_id_label` | `varchar2` |  | [ ] |  |  |
| `message_needaction` | `boolean` | Action Needed | [ ] |  | If checked, new messages require your attention. |
| `message_needaction_counter` | `int32` | Number of Actions | [ ] |  | Number of messages which requires an action |
| `message_partner_ids` | `varchar2` |  | [ ] |  |  |
| `my_activity_date_deadline` | `datetime` | My Activity Deadline | [ ] |  |  |
| `name` | `varchar2` | Expense Report Summary | [x] |  |  |
| `payment_mode` | `varchar2` | Paid By | [ ] |  |  |
| `payment_state` | `varchar2` | Payment Status | [ ] |  |  |
| `product_ids` | `varchar2` |  | [ ] |  |  |
| `sale_order_count` | `int32` | Sale Order Count | [ ] |  |  |
| `state` | `varchar2` | Status | [x] |  |  |
| `total_amount` | `numeric` | Total Amount | [ ] |  |  |
| `total_amount_taxes` | `numeric` | Taxes | [ ] |  |  |
| `untaxed_amount` | `numeric` | Untaxed Amount | [ ] |  |  |
| `user_id` | `varchar2` |  | [ ] |  |  |
| `user_id_label` | `varchar2` |  | [ ] |  |  |
| `website_message_ids` | `varchar2` |  | [ ] |  | Website communication history |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Odoo](/en/release-notes/drivers?driver=odoo)

