expense: Odoo itgen_odoo_expense
read only per partition
- Catalogo:
Odoo - Schema:
hr - Etichetta: itgen_odoo_expense
Spesa
È possibile solo recuperare i dati.
Riepilogo
Base model to inherit from to add extract functionality to a model.
Colonne della tabella
Di seguito sono riportate le colonne della tabella expense. 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 |
|---|---|---|---|---|---|
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 |
Somma da pagare | |||
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 |
Numero di allegati | |||
can_ |
boolean |
Can be reinvoiced | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
numeric |
Tasso di cambio della valuta | |||
date |
datetime |
Data della spesa | |||
description |
varchar2 |
Note interne | |||
display_ |
varchar2 |
Nome visualizzato | |||
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 |
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 |
Description | |||
payment_ |
varchar2 |
Paid By | |||
predicted_ |
varchar2 |
Predicted Category | |||
product_ |
varchar2 |
Descrizione del prodotto | |||
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 |
Prezzo unitario | |||
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 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: