invantive documentation
Invantive Support ForumsLog In / Sign Up

order: Odoo itgen_odoo_order

read only per partition

  • Catalog: Odoo
  • Schema: pos
  • Label: itgen_odoo_order

Point of Sale Orders

Can only retrieve data.

Table Columns

The columns of the table order are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type 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 Created on
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 Currency Rate The rate of the currency to the currency of rate applicable at the date of the order
date_order datetime Date
display_name varchar2 Display Name
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 Is Invoiced
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 Internal Notes
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 Receipt Number
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 Sequence Number 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 Shipping Date
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

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: