order: Odoo itgen_odoo_order
read only per partition
- Catálogo:
Odoo - Esquema:
pos - Etiqueta: itgen_odoo_order
Point of Sale Orders
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 | |||
account_ |
varchar2 |
||||
account_ |
varchar2 |
||||
amount_ |
numeric |
Paid | |||
amount_ |
numeric |
Returned | |||
amount_ |
numeric |
Taxes | |||
amount_ |
numeric |
Total | |||
cashier |
varchar2 |
Cashier | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
config_ |
varchar2 |
||||
config_ |
varchar2 |
||||
create_ |
datetime |
Creado en | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
crm_ |
varchar2 |
||||
crm_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
numeric |
Tipo de cambio de la moneda | The rate of the currency to the currency of rate applicable at the date of the order | ||
date_ |
datetime |
Date | |||
display_ |
varchar2 |
Nombre para mostrar | |||
employee_ |
varchar2 |
Person who uses the cash register.It can be a reliever, a student or an interim employee. | |||
employee_ |
varchar2 |
Person who uses the cash register.It can be a reliever, a student or an interim employee. | |||
failed_ |
boolean |
Failed Pickings | |||
fiscal_ |
varchar2 |
||||
fiscal_ |
varchar2 |
||||
has_ |
boolean |
Has Refundable Lines | |||
id |
int32 |
ID | |||
is_ |
boolean |
Se factura | |||
is_ |
boolean |
Is Refunded | |||
is_ |
boolean |
Is this already tipped? | |||
is_ |
boolean |
Is Total Cost Computed | Allows to know if all the total cost of the order lines have already been computed | ||
lines |
varchar2 |
||||
margin |
numeric |
Margin | |||
margin_ |
numeric |
Margin (%) | |||
name |
varchar2 |
Order Ref | |||
nb_ |
int32 |
Number of Print | |||
note |
varchar2 |
Notas internas | |||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
payment_ |
varchar2 |
||||
picking_ |
int32 |
Picking Count | |||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
pos_ |
varchar2 |
Número de recibo | |||
pricelist_ |
varchar2 |
||||
pricelist_ |
varchar2 |
||||
procurement_ |
varchar2 |
||||
procurement_ |
varchar2 |
||||
refund_ |
int32 |
Number of Refund Orders | |||
refunded_ |
varchar2 |
||||
refunded_ |
int32 |
Refunded Orders Count | |||
sale_ |
varchar2 |
Accounting journal used to post POS session journal entries and POS invoice payments. | |||
sale_ |
varchar2 |
Accounting journal used to post POS session journal entries and POS invoice payments. | |||
sale_ |
int32 |
Sale Order Count | |||
sequence_ |
int32 |
Número de Secuencia | A session-unique sequence number for the order | ||
session_ |
varchar2 |
||||
session_ |
varchar2 |
||||
session_ |
varchar2 |
||||
session_ |
varchar2 |
||||
shipping_ |
datetime |
Fecha de envío | |||
state |
varchar2 |
Status | |||
tip_ |
numeric |
Tip Amount | |||
to_ |
boolean |
To invoice | |||
user_ |
varchar2 |
Person who uses the cash register.It can be a reliever, a student or an interim employee. | |||
user_ |
varchar2 |
Person who uses the cash register.It can be a reliever, a student or an interim employee. | |||
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: