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_ |
varchar2 |
||||
account_ |
varchar2 |
||||
accounting_ |
datetime |
Accounting Date | |||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
address_ |
varchar2 |
||||
address_ |
varchar2 |
||||
amount_ |
numeric |
Amount Due | |||
approval_ |
datetime |
Approval Date | |||
attachment_ |
int32 |
Number of Attachments | |||
bank_ |
varchar2 |
The payment method used when the expense is paid by the company. | |||
bank_ |
varchar2 |
The payment method used when the expense is paid by the company. | |||
can_ |
boolean |
Can Approve | |||
can_ |
boolean |
Can Reset | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
department_ |
varchar2 |
||||
department_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
expense_ |
varchar2 |
||||
expense_ |
int32 |
Number of Expenses | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
is_ |
boolean |
Expense Lines Are Editable By Current User | |||
is_ |
boolean |
Handle lines with different currencies | |||
journal_ |
varchar2 |
The journal used when the expense is done. | |||
journal_ |
varchar2 |
The journal used when the expense is done. | |||
message_ |
int32 |
Attachment Count | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Expense Report Summary | |||
payment_ |
varchar2 |
Paid By | |||
payment_ |
varchar2 |
Payment Status | |||
product_ |
varchar2 |
||||
sale_ |
int32 |
Sale Order Count | |||
state |
varchar2 |
Status | |||
total_ |
numeric |
Total Amount | |||
total_ |
numeric |
Taxes | |||
untaxed_ |
numeric |
Untaxed Amount | |||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: