order: Odoo itgen_odoo_order
read only per partition
- Catálogo:
Odoo - Esquema:
purchase - Etiqueta: itgen_odoo_order
Orden de Compra
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla order. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | 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 |
Creado en | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
numeric |
Tipo de cambio de la moneda | 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 |
Nombre para mostrar | |||
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 |
Estado de facturación | |||
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 |
Número de archivos adjuntos | |||
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 |
Número de acciones | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
mrp_ |
int32 |
Count of MO Source | |||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Referencia del pedido | |||
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 |
Estado de la recepción | |||
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 |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: