request: Odoo itgen_odoo_request
read only per partition
- Catalog:
Odoo - Schema:
approval - Label: itgen_odoo_request
Approval Request
Can only retrieve data.
Table Columns
The columns of the table request 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 |
|---|---|---|---|---|---|
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 | |||
approval_ |
int32 |
Minimum Approval | |||
approval_ |
varchar2 |
Approval Type | Allows you to define which documents you would like to create once the request has been approved | ||
approver_ |
varchar2 |
||||
approver_ |
boolean |
Approvers Sequence? | If checked, the approvers have to approve in sequence (one after the other). If Employee's Manager is selected as approver, they will be the first in line. | ||
attachment_ |
int32 |
Number of Attachments | |||
automated_ |
boolean |
Automated Sequence? | If checked, the Approval Requests will have an automated generated name based on the given code. | ||
category_ |
varchar2 |
||||
category_ |
varchar2 |
||||
category_ |
varbinary |
Image | |||
change_ |
boolean |
Can Change Request Owner | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date |
datetime |
Date | |||
date_ |
datetime |
Date Confirmed | |||
date_ |
datetime |
Date end | |||
date_ |
datetime |
Date start | |||
display_ |
varchar2 |
Display Name | |||
has_ |
boolean |
Has Access To Request | |||
has_ |
varchar2 |
Has Amount | |||
has_ |
varchar2 |
Has Date | |||
has_ |
varchar2 |
Has Location | |||
has_ |
boolean |
Has Message | |||
has_ |
varchar2 |
Has Contact | |||
has_ |
varchar2 |
Has Payment | |||
has_ |
varchar2 |
Has Period | |||
has_ |
varchar2 |
Has Product | Additional products that should be specified on the request. | ||
has_ |
varchar2 |
Has Quantity | |||
has_ |
varchar2 |
Has Reference | An additional reference that should be specified on the request. | ||
hide_ |
boolean |
Hide Location | |||
id |
int32 |
ID | |||
location |
varchar2 |
Location | |||
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 |
Approval Subject | |||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
product_ |
varchar2 |
||||
purchase_ |
int32 |
Purchase Order Count | |||
quantity |
numeric |
Quantity | |||
reason |
varchar2 |
Description | |||
reference |
varchar2 |
Reference | |||
request_ |
varchar2 |
||||
request_ |
varchar2 |
||||
request_ |
varchar2 |
Request Status | |||
requirer_ |
varchar2 |
Documents | |||
user_ |
varchar2 |
User Status | |||
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: