order: Odoo itgen_odoo_order
read only per partition
- Catalogo:
Odoo - Schema:
repair - Etichetta: itgen_odoo_order
Repair Order
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella order. 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 |
||||
address_ |
varchar2 |
||||
address_ |
varchar2 |
||||
allowed_ |
varchar2 |
||||
amount_ |
numeric |
Taxes | |||
amount_ |
numeric |
Total | |||
amount_ |
numeric |
Untaxed Amount | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
default_ |
varchar2 |
||||
default_ |
varchar2 |
||||
description |
varchar2 |
Repair Description | |||
display_ |
varchar2 |
Nome visualizzato | |||
fees_ |
varchar2 |
||||
guarantee_ |
datetime |
Warranty Expiration | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
internal_ |
varchar2 |
Note interne | |||
invoice_ |
varchar2 |
||||
invoice_ |
varchar2 |
||||
invoice_ |
varchar2 |
Metodo di fatturazione | Selecting 'Before Repair' or 'After Repair' will allow you to generate invoice before or after the repair is done respectively. 'No invoice' means you don't want to generate invoice for this repair order. | ||
invoice_ |
varchar2 |
Invoice State | |||
invoiced |
boolean |
Invoiced | |||
is_ |
boolean |
Returned | True if this repair is linked to a Return Order and the order is 'Done'.False otherwise. | ||
location_ |
varchar2 |
This is the location where the product to repair is located. | |||
location_ |
varchar2 |
This is the location where the product to repair is located. | |||
lot_id |
varchar2 |
Products repaired are all belonging to this lot | |||
lot_ |
varchar2 |
Products repaired are all belonging to this lot | |||
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 |
||||
move_ |
varchar2 |
||||
move_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Repair Reference | |||
operations |
varchar2 |
||||
partner_ |
varchar2 |
Choose partner for whom the order will be invoiced and delivered.You can find a partner by its Name, TIN, Email or Internal Reference. | |||
partner_ |
varchar2 |
Choose partner for whom the order will be invoiced and delivered.You can find a partner by its Name, TIN, Email or Internal Reference. | |||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
picking_ |
varchar2 |
Return Order from which the product to be repaired comes from. | |||
picking_ |
varchar2 |
Return Order from which the product to be repaired comes from. | |||
pricelist_ |
varchar2 |
Pricelist of the selected partner. | |||
pricelist_ |
varchar2 |
Pricelist of the selected partner. | |||
priority |
varchar2 |
Priority | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
numeric |
Product Quantity | |||
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 |
||||
quotation_ |
varchar2 |
Note relative al preventivo | |||
repaired |
boolean |
Repaired | |||
sale_ |
varchar2 |
Sale Order from which the product to be repaired comes from. | |||
sale_ |
varchar2 |
Sale Order from which the product to be repaired comes from. | |||
schedule_ |
datetime |
Data programmata | |||
state |
varchar2 |
Status | * The 'Draft' status is used when a user is encoding a new and unconfirmed repair order. * The 'Confirmed' status is used when a user confirms the repair order. * The 'Ready to Repair' status is used to start to repairing, user can start repairing only after repair order is confirmed. * The 'Under Repair' status is used when the repair is ongoing. * The 'To be Invoiced' status is used to generate the invoice before or after repairing done. * The 'Done' status is set when repairing is completed. * The 'Cancelled' status is used when user cancel repair order. | ||
tag_ |
varchar2 |
||||
tracking |
varchar2 |
Product Tracking | Ensure the traceability of a storable product in your warehouse. | ||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
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: