request: Odoo itgen_odoo_request
read only per partition
- Catalogo:
Odoo - Schema:
approval - Etichetta: itgen_odoo_request
Approval Request
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella request. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | 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 |
Tipo di approvazione | 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 |
Numero di allegati | |||
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 |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date |
datetime |
Date | |||
date_ |
datetime |
Data confermata | |||
date_ |
datetime |
Date end | |||
date_ |
datetime |
Date start | |||
display_ |
varchar2 |
Nome visualizzato | |||
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 |
Numero di allegati | |||
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 |
Numero di azioni | 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 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: