expense: Odoo itgen_odoo_expense
read only per partition
- Catalog:
Odoo - Schema:
hr - Label: itgen_odoo_expense
Expense
Can only retrieve data.
Summary
Base model to inherit from to add extract functionality to a model.
Table Columns
The columns of the table expense 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 |
An expense account is expected | |||
account_ |
varchar2 |
An expense account is expected | |||
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 |
||||
amount_ |
numeric |
Amount Due | |||
amount_ |
numeric |
Tax amount in Currency | Tax amount in currency | ||
amount_ |
numeric |
Tax amount | Tax amount in company currency | ||
analytic_ |
varchar2 |
Analytic Distribution | |||
analytic_ |
int32 |
Analytic Precision | |||
approved_ |
varchar2 |
||||
approved_ |
varchar2 |
||||
approved_ |
datetime |
Approved On | |||
attachment_ |
int32 |
Number of Attachments | |||
can_ |
boolean |
Can be reinvoiced | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
numeric |
Currency Rate | |||
date |
datetime |
Expense Date | |||
description |
varchar2 |
Internal Notes | |||
display_ |
varchar2 |
Display Name | |||
duplicate_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
extract_ |
boolean |
Can show the ocr send button | |||
extract_ |
varchar2 |
Error message | |||
extract_ |
int32 |
Id of the request to IAP-OCR | |||
extract_ |
varchar2 |
Extract state | |||
extract_ |
boolean |
Extract State Processed | |||
extract_ |
int32 |
Status code | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
is_ |
boolean |
Is Editable By Current User | |||
is_ |
boolean |
Is In Extractable State | |||
is_ |
boolean |
Reference Is Editable By Current User | |||
is_ |
boolean |
Explicitly Refused by manager or accountant | |||
label_ |
varchar2 |
Label Convert Rate | |||
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 |
Description | |||
payment_ |
varchar2 |
Paid By | |||
predicted_ |
varchar2 |
Predicted Category | |||
product_ |
varchar2 |
Product Description | |||
product_ |
boolean |
Is product with non zero cost selected | |||
product_ |
boolean |
Whether tax is defined on a selected product | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
Conversion between Units of Measure can only occur if they belong to the same category. The conversion will be made based on the ratios. | |||
product_ |
varchar2 |
Conversion between Units of Measure can only occur if they belong to the same category. The conversion will be made based on the ratios. | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
quantity |
numeric |
Quantity | |||
reference |
varchar2 |
Bill Reference | |||
sale_ |
varchar2 |
If the category has an expense policy, it will be reinvoiced on this sales order | |||
sale_ |
varchar2 |
If the category has an expense policy, it will be reinvoiced on this sales order | |||
same_ |
boolean |
Is currency_id different from the company_currency_id | |||
sample |
boolean |
Sample | |||
sheet_ |
varchar2 |
||||
sheet_ |
varchar2 |
||||
sheet_ |
boolean |
Sheet Is Editable | |||
state |
varchar2 |
Status | |||
tax_ |
varchar2 |
||||
total_ |
numeric |
Total In Currency | |||
total_ |
numeric |
Total | |||
unit_ |
numeric |
Unit Price | |||
unit_ |
numeric |
Unit Price Display | |||
untaxed_ |
numeric |
Total Untaxed Amount In Currency | |||
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: