expense_sheet: Odoo itgen_odoo_expense_sheet
read only per partition
- Catálogo:
Odoo - Esquema:
hr - Etiqueta: itgen_odoo_expense_sheet
Expense Report
Solo puede recuperar datos.
Resumen
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
=================================================================================
Columnas de la Tabla
A continuación se muestran las columnas de la tabla expense_sheet. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | 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 |
Cantidad Adeudada | |||
approval_ |
datetime |
Fecha de aprobación | |||
attachment_ |
int32 |
Número de archivos adjuntos | |||
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 |
Creado en | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
department_ |
varchar2 |
||||
department_ |
varchar2 |
||||
display_ |
varchar2 |
Nombre para mostrar | |||
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 |
Número de archivos adjuntos | |||
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 |
Número de acciones | 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 |
Estatus del pago | |||
product_ |
varchar2 |
||||
sale_ |
int32 |
Sale Order Count | |||
state |
varchar2 |
Status | |||
total_ |
numeric |
Cantidad Total | |||
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 |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: