order: Odoo itgen_odoo_order
read only per partition
- Catalogo:
Odoo - Schema:
purchase - Etichetta: itgen_odoo_order
Ordine di acquisto
È 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 |
|---|---|---|---|---|---|
access_ |
varchar2 |
Security Token | |||
access_ |
varchar2 |
Portal Access URL | Customer Portal URL | ||
access_ |
varchar2 |
Access warning | |||
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 |
Taxes | |||
amount_ |
numeric |
Total | |||
amount_ |
numeric |
Untaxed Amount | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
country_ |
varchar2 |
Country code | The ISO country code in two chars.You can use this field for quick search. | ||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
numeric |
Tasso di cambio della valuta | Ratio between the purchase order currency and the company currency | ||
date_ |
datetime |
Confirmation Date | |||
date_ |
datetime |
Date Calendar Start | |||
date_ |
datetime |
Order Deadline | Depicts the date within which the Quotation should be confirmed and converted into a purchase order. | ||
date_ |
datetime |
Expected Arrival | Delivery date promised by vendor.This date is used to determine expected arrival of products. | ||
default_ |
varchar2 |
Destination Location Type | Technical field used to display the Drop Ship Address | ||
dest_ |
varchar2 |
Put an address if you want to deliver directly from the vendor to the customer.Otherwise, keep empty to deliver to your own company. | |||
dest_ |
varchar2 |
Put an address if you want to deliver directly from the vendor to the customer.Otherwise, keep empty to deliver to your own company. | |||
display_ |
varchar2 |
Nome visualizzato | |||
effective_ |
datetime |
Arrival | Completion date of the first receipt order. | ||
fiscal_ |
varchar2 |
||||
fiscal_ |
varchar2 |
||||
group_ |
varchar2 |
||||
group_ |
varchar2 |
||||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
incoming_ |
int32 |
Incoming Shipment count | |||
incoterm_ |
varchar2 |
International Commercial Terms are a series of predefined commercial terms used in international transactions. | |||
incoterm_ |
varchar2 |
International Commercial Terms are a series of predefined commercial terms used in international transactions. | |||
incoterm_ |
varchar2 |
Incoterm Location | |||
invoice_ |
int32 |
Bill Count | |||
invoice_ |
varchar2 |
||||
invoice_ |
varchar2 |
Stato della fatturazione | |||
is_ |
boolean |
Is Shipped | |||
mail_ |
boolean |
Reception Confirmed | True if PO reception is confirmed by the vendor. | ||
mail_ |
boolean |
Reminder Confirmed | True if the reminder email is confirmed by the vendor. | ||
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 |
||||
mrp_ |
int32 |
Count of MO Source | |||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Riferimento dell'ordine | |||
notes |
varchar2 |
Terms and Conditions | |||
on_ |
numeric |
On-Time Delivery Rate | Over the past 12 months; the number of products received on time divided by the number of ordered products. | ||
order_ |
varchar2 |
||||
origin |
varchar2 |
Source Document | Reference of the document that generated this purchase order request (e.g. a sales order) | ||
partner_ |
varchar2 |
You can find a vendor by its Name, TIN, Email or Internal Reference. | |||
partner_ |
varchar2 |
You can find a vendor by its Name, TIN, Email or Internal Reference. | |||
partner_ |
varchar2 |
Vendor Reference | Reference of the sales order or bid sent by the vendor.It's used to do the matching when you receive the products as this reference is usually written on the delivery order sent by your vendor. | ||
payment_ |
varchar2 |
||||
payment_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
This will determine operation type of incoming shipment | |||
picking_ |
varchar2 |
This will determine operation type of incoming shipment | |||
priority |
varchar2 |
Priority | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
receipt_ |
boolean |
Receipt Reminder Email | Automatically send a confirmation email to the vendor X days before the expected receipt date, asking him to confirm the exact date. | ||
receipt_ |
varchar2 |
Stato della ricevuta | |||
reminder_ |
int32 |
Days Before Receipt | Number of days to send reminder email before the promised receipt date | ||
sale_ |
int32 |
Number of Source Sale | |||
state |
varchar2 |
Status | |||
tax_ |
varchar2 |
Technical field to filter the available taxes depending on the fiscal country and fiscal position. | |||
tax_ |
varchar2 |
Technical field to filter the available taxes depending on the fiscal country and fiscal position. | |||
tax_ |
varbinary |
Tax Totals | |||
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: