invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

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_token varchar2 Security Token
access_url varchar2 Portal Access URL Customer Portal URL
access_warning varchar2 Access warning
account_move varchar2
account_move_label varchar2
amount_paid numeric Paid
amount_return numeric Returned
amount_tax numeric Taxes
amount_total numeric Total
cashier varchar2 Cashier
company_id varchar2
company_id_label varchar2
config_id varchar2
config_id_label varchar2
create_date datetime Creado en
create_uid varchar2
create_uid_label varchar2
crm_team_id varchar2
crm_team_id_label varchar2
currency_id varchar2
currency_id_label varchar2
currency_rate 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_order datetime Date
display_name varchar2 Nombre para mostrar
employee_id varchar2 Person who uses the cash register.It can be a reliever, a student or an interim employee.
employee_id_label varchar2 Person who uses the cash register.It can be a reliever, a student or an interim employee.
failed_pickings boolean Failed Pickings
fiscal_position_id varchar2
fiscal_position_id_label varchar2
has_refundable_lines boolean Has Refundable Lines
id int32 ID
is_invoiced boolean Se factura
is_refunded boolean Is Refunded
is_tipped boolean Is this already tipped?
is_total_cost_computed 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_percent numeric Margin (%)
name varchar2 Order Ref
nb_print int32 Number of Print
note varchar2 Notas internas
partner_id varchar2
partner_id_label varchar2
payment_ids varchar2
picking_count int32 Picking Count
picking_ids varchar2
picking_type_id varchar2
picking_type_id_label varchar2
pos_reference varchar2 Número de recibo
pricelist_id varchar2
pricelist_id_label varchar2
procurement_group_id varchar2
procurement_group_id_label varchar2
refund_orders_count int32 Number of Refund Orders
refunded_order_ids varchar2
refunded_orders_count int32 Refunded Orders Count
sale_journal varchar2 Accounting journal used to post POS session journal entries and POS invoice payments.
sale_journal_label varchar2 Accounting journal used to post POS session journal entries and POS invoice payments.
sale_order_count int32 Sale Order Count
sequence_number int32 Número de Secuencia A session-unique sequence number for the order
session_id varchar2
session_id_label varchar2
session_move_id varchar2
session_move_id_label varchar2
shipping_date datetime Fecha de envío
state varchar2 Status
tip_amount numeric Tip Amount
to_invoice boolean To invoice
user_id varchar2 Person who uses the cash register.It can be a reliever, a student or an interim employee.
user_id_label varchar2 Person who uses the cash register.It can be a reliever, a student or an interim employee.
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: